All posts by Grant Gamble

Working in DirectQuery Mode

In this post, we will contrast the importing of SQL Server data with working in DirectQuery Mode. When you use the DirectQuery option, data is not imported from SQL Server into the data model of your SQL

Continue reading

Power BI DA-100: Edit and configure interactions between visuals

Exam DA-100 | Edit and configure interactions between visuals 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

Continue reading

Creating Mobile-Only Content in Power BI

Mobile-optimized Reports Mobile reports are based on the regular web report which you will have already created, with the layout adapted and optimized for mobile. For example, adapting a four-column desktop

Continue reading

Power BI DAX “X” Functions

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. The

Continue reading

The CALCULATE Function is a DAX TARDIS

In spite of its bland name, the CALCULATE function is the most important function in the DAX language and by far the most widely used in advanced DAX calculations. The power of the CALCULATE function stems

Continue reading

Power Query Trim and Clean Functions

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. The

Continue reading

Power BI Formal and Informal Hierarchies

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. The

Continue reading

Parameterizing SQL Server Connections

Query Parameters allow you to make the content of a report dependent on one or more parameter values. If we parameterize a data source, then we can update all our queries using that data source simply

Continue reading

Power BI MCSA Certification Training Tips – Part 14: On-premises Data Gateway

To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap

Continue reading

Power BI MCSA Certification Training Tips – Part 13: Analyze in Excel

To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap

Continue reading
1 2 3 5