Power BI

There are times that you need to get the list of FOLDERS and not just files. Of course folder itself (without considering files in it), doesn't contain data to be used for a report. However, sometimes, even the folder name might contain some useful information. The Get Data From Folder option in Power BI will…

If you want to create a row-number statically as a pre-calculation in Power BI, then Power Query has a very simple way of doing it; Add Index Column. However, the Index column creates the row number regardless of any grouping or categorization. sometimes you want to take that into account too. There is a little…

If you are looking to find out information about your Power BI Licensing or whom the Power BI Pro licenses have been allocated this blog post is for you.

Access activity logs in Office 365 and Power BI to provide a data-driven measurement of Power BI adoption.

Visit the post for more.

When I shared on Twitter the most recent installment in the BI Polar “data culture” series, BI developer Chuy Varela replied to agree with some key points from the video on executive sp…

In December of 2019 Power BI team updated the KPI visual with a ton more features and options. This tutorial walks us through all the new hot features.

Recently I received a question on how to Unfill in Power Query - remove all duplicate instances of a value, replacing them with null

From the day Microsoft made the "PowerBI - Refresh a dataset" Power Automate connector available, and having seen this video by GuyInACube https://guyinacube.com/2019/10/24/use-microsoft-flow-and-other-options-to-refresh...

Detecting outliers and anomalies using the three-sigma rule of thumb in Power BI with no code

Refresh a Power BI dataset on a schedule built in an Outlook calendar using Power Automate

As a Data & Analytics consultant, working on tons of different projects, it is very likely that I’m the creator and owner of a whole lot of dataflow and dataset refreshes. Since these ref…

Announcing Updates to the Center of Excellence (CoE) Starter Kit – a set of templates that are designed to help get started with developing a strategy for adopting and supporting the Power Platform, with a focus on Power Apps and Power Automate.

Some time back we looked at creating Azure Logic Apps for cloud integrations. In this post, we will look at how to create an Azure Logic App that performs Common Data Service functions based on Common Data Service events. We will create an Azure Logic App that, when an account is created in Dynamics 365 / Power Apps, we will also create a contact and assign that contact to the new account. Let’s … Continue reading How to Create an Azure Logic App that Integrates with the Common Data Service

Continuing on our series on data culture, we’re examining the importance of having an executive sponsor. This is one of the least exciting success factors for implementing Power BI and gettin…

A lot has already been written on aggregations and it is one of the most exciting features of Power BI in a while. The guys at SQLBI did a session...

As a Data & Analytics consultant, working on tons of different projects, it is very likely that I’m the creator and owner of a whole lot of dataflow and dataset refreshes. Since these ref…

Multiple patterns on how to tackle things with DAX vs with Power Query in terms of column creation and which approach is the most optimal.

Refresh a Power BI dataset on a schedule built in an Outlook calendar using Power Automate

I have written another blog article previously about how to set up your Power BI to get data from a file in OneDrive for Business folder without needing gateway. That was a popular blog article, but I got questions about what if I want to get data from a folder in OneDrive for business but…

I have previously explained one of the benefits of Power Platform dataflows, which was the ability to refresh the data as many times as you want (on a scheduled basis), and the ability to refresh even with the frequency of a minute. Another useful feature of Power Platform dataflows is the ability to have referenced…

Understand different techniques to help reduce the data loaded into Import models.

Managing the assignment of Power BI Pro licenses is a fundamental task of Power BI administrators. The Power BI admin, the BI team, and possibly other stakeholders may all pose a number of common q…

The job function, market, structure, and role definition in the world of Business Intelligence had big changes throughout the past few years. The big change from traditional BI to self-service BI is not just about tools, but also about roles, and jobs, and organizational structure. In this post, I am sharing my views on this…

Power BI started as a self-service tool and has become a part of the enterprise reporting tooling. Managing reports centrally can be done with Azure DevOps.

Recently, I was faced with a very interesting problem. I had developed a complex dataset. Beside that there are more than 200 reports using a live connection to this dataset. A report’s user had come and asked for negating a Boolean value of a column – because I had misunderstood the meaning of the ...