Blog - Page 2 of 8 - G Com Solutions Limited

Power BI DA-100 Exam Tips
Manage Datasets
Identify Downstream Dataset Dependencies

16th July 2021
/ Power BI
/ By Grant Gamble

In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. In

Power BI DA-100 Exam Tips
Create and manage workspaces
Apply sensitivity labels to workspace content

12th July 2021
/ Power BI
/ By Grant Gamble

In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. In

Power BI DA-100 Exam Tips
Manage datasets
Promote or certify a dataset

8th July 2021
/ Power BI
/ By Grant Gamble

In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. In

Power BI DA-100 Exam Tips
Create reports
Design and configure for accessibility

7th July 2021
/ Power BI
/ By Grant Gamble

In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. In

Power BI DA-100 Exam Tips
Design a data model
Flatten out a parent-child hierarchy

26th June 2021
/ Power BI
/ By Grant Gamble

In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. In

Power BI DA-100 Exam Tips
Get Data from Different Data Sources
Use Parameters

31st May 2021
/ Power BI
/ By Grant Gamble

In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. In

Easily Change All Data Sources from Excel to SQL Server

16th April 2021
/ Power BI
/ By Grant Gamble

This blog post will show you how to Easily Change All Data Sources from Excel to SQL Server in a given solution. The idea of using power query parameters to rapidly change which data sources your tables

Connecting to Web Data (Get Data – Web)

31st March 2021
/ Power BI
/ By Grant Gamble

Connecting to Web Data (Get Data – Web) When connecting to web data (Get Data – Web), connecting to a web URL does not imply any specific format. The file being accessed via the web may be

Replicating Qlik Sense Keep Operations in Power Query

28th February 2021
/ Blog
/ By Grant Gamble

Replicating Qlik Sense Keep Operations in Power Query turns out to be fairly straightforward. I was recently asked by a client whether the Keep operations present in Qlik Sense could be replicated in Power

Connecting to SharePoint Folders

30th January 2021
/ Blog
/ By Grant Gamble

Connecting to SharePoint Folders is similar to connecting to folders on your file system. The Get Data > Folder connector allows you to connect to a folder containing files of the same type and combine