Microsoft Business Intelligence

Recently I faced a scenario where I needed to find if a particular url is used in hyperlink in 100s of ppt. Opening ppt and looking for the ppt is cumbersome,  so wrote a small PowerShell to find the url. Here is the PowerShell Script code $FilePath= "C:\Users\xxx\Path" Add-Type -AssemblyName Office $ppt = New-Object -ComObject powerpoint.Application $DocumentsLib = Get-ChildItem -Path "$FilePath" -Filter "*.ppt*" -Recurse $Doc = New-Object -ComObject powerpoint.Application $i=0 $DocumentsLib | ForEach-Object { Write-Host $_.FullName $Doc = $ppt.Presentations.Open($_.FullName,$Null,$Null,[Microsoft.Office.Core.MsoTriState]::msoFalse) $Slides = $Doc.Slides Foreach ($Slide in $Slides) {     $Slide.Hyperlinks | ForEach-Object {                 if ($_.Address -like "*texttofind*" -or $_.Text -like "texttofind*")          {            write-host $_.Address        ...

In this article, we  are going to demonstrate easiest way to create SharePoint List using your Excel Workbook. The SharePoint List comes handy to maintain your data as it allows great flexibility and collaboration to manage the content, modify, etc. Step 1: Select the worksheet from your excel workbook which you want to publish as SharePoint List and then format it as HTML. Step 2: Once the data in worksheet is formatted as table, select the table and go to Table Design Menu and then select Export Table To SharePoint List. In the dialog box as below, enter the Address - URL of the SharePoint site where you want the List to be Created and then Finish. This shall publish the Excel Table to SharePoint List and done.  Step 3: Visit your SharePoint List on the SharePoint and set the data fields as needed.

This article demonstrate steps to install MariaDB/MySQL on Ubuntu using sudo. This is part of our getting started journey to learn MariaDB/MySQL. I will be covering PostgreSQL in another article. Before we get started, very first step would be to install MariaDB/MySQL Server and client. You can install any of these RDBMS on Windows but this blog will mostly be following Ubuntu OS. There are various tools to access MariaDB/MySQL Server, we are going to use mysqlclient and Heidisql. Lets get started with installation of MariaDB. Step 1: Open your Ubuntu terminal window or bash and run following cmd. This step is going to check if mariadb-server is already installed and is going to remove it. You can either continue using the current setup or go to next step to do a fresh installation sudo apt-get remove mariadb-server Step 2: run sudo apt-get install software-properties-common Step 3: Check for Ubuntu updates sudo apt-get updates Step 4: Install Ubuntu updates sudo ...

In our previous post, we demonstrated steps to install MariaDB Server on Ubuntu , in this article, we are going to show how to create database in MySQL/MariaDB. We are going to talk about DDL(Data Definition Language), how to create tables and authorize users to access them. Start your mariadb-server and follow the steps Creating Databases, Tables, and Authorized Users Step 1: Connect to your mariadb-server and run below sql. This can be done via mysql client or any other tools like Heidisql, phpmyadmin etc. This is going to create a new database in your server.  CREATE DATABASE myFirstDB; Check if the database already exists and create CREATE DATABASE IF NOT EXISTS myFirstDB; To list all the databases in a server. SHOW DATABASES; To connect to your database USE DATABASE_NAME; Once you have selected your database, use following to create user CREATE USER 'username'@'localhost' IDENTIFIED BY 'user_password'; To create a user that can connect fro...

Recently I have been put in to a scenario where I need data from SharePoint list to be published into Power BI Report. The columns used in SharePoint list where of type Multi Line Text and contained HTML tags. Up here I am going to show how to consume HTML in Power BI reports, Power BI itself offers way to clean your HTML text allowing you to use only text from it. Step 1: Connect to SharePoint List  using PowerBI Step 2: Select Transform Data Step 3: Find column FieldValueAsHtml, click to expand and select the column with Html data and click ok. This will extract the column data and create a new column with only texts extracted from Html. This new column will be called FieldValueAsHtml.YourColName. Enjoy.