Category Archives for Blog

Identify Downstream Dataset Dependencies

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

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 this Power BI training post, we will examine DA-100 exam – Manage Datasets: Identify Downstream Dataset Dependencies. […]

Continue reading
Create and manage workspaces: Apply sensitivity labels to workspace content

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

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 this Power BI training post, we will examine DA-100 exam – Create and manage workspaces: Apply sensitivity […]

Continue reading
Promote or certify a dataset

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

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 this Power BI training post, we will examine DA-100 exam – Manage datasets: Promote or certify a […]

Continue reading
Design and configure for accessibility

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

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 this Power BI training post, we will examine DA-100 exam – Create reports: Design and configure for […]

Continue reading
DA100-Flatten out a parent-child hierarchy

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

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 this post, we will examine DA-100 exam – Design a data model: Flatten out a parent-child hierarchy. […]

Continue reading
DA-100 Exam Tips - Get Data from Different Data Sources: Use Parameters

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

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 this post, we will examine DA-100 exam – Get Data from Different Data Sources: Use Parameters. This […]

Continue reading
Easily Change All Data Sources from Excel to SQL Server

Easily Change All Data Sources from Excel to SQL Server

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 are coming from, has been around for a long time. What we are going to do in this […]

Continue reading
Get Data - Web

Connecting to Web Data (Get Data – Web)

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 in any format: CSV, XML, JSON etc. However, be aware that accessing web data using its native connector […]

Continue reading
Loading and non-Loading Queries

Replicating Qlik Sense Keep Operations in Power Query

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 Query. The Keep functionality allows report developers to import two tables which each observe a join but where the two tables […]

Continue reading

Connecting to SharePoint Folders

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 the data they contain into a single query. You simply specify the folder you want to connect to and all […]

Continue reading
1 34 35 36 37 38 42