Power BI

I have previously written about how to sort a column by another column, and I used Month Names as an example. However, still, many are unaware that the same technique with slight modifications can be applied to any other columns. You can have a text column in your slicer (product category for example), and sort…

We look at how you can sign up for Power BI without a work email. If all you have is a personal email, this video is for you!

This article describes how to write efficient DAX expressions that compute the compound interest of incremental investments made throughout the holding peri

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…

This is a new post of the Bad Practices in Power BI series – This time we discuss the momentum of Power BI and what you can do about it (or fail to). In Power BI’s 4th birthday celebration, Arun Ulag, the general manager of the Power BI product team shared a stunning visual. On …

This webinar walks through how to make Custom Visuals with no Code. Learn how to use Charts.PowerBI.Tips to enhance your reports. Click here...

Easily copy your Power BI reports to other workspaces. Including your My Workspace! We walk through what you need to do to accomplish this.

The new Get-PowerBIActivityEvent has got some new columns which allow for better reporting insights which is shown in this blog post.

Yes! It is possible to use incremental refresh with files that are hosted in a folder either locally or in SharePoint. This article gives you the general pattern to carry it out.

The easiest way to get data from the new Power BI REST API Event Activity Log. It uses a Power BI Custom Connector with start and end date parameters to query the data from the API.

Well – creating measures in the Power BI desktop is usually doing a lot of copying and pasting of measures. And unfortunately, we haven’t yet gotten a Copy measure in the shortcut menu when w…

When designing your model you will in most cases need a date dimension and one of the things you always should do is set the Summarization of the number columns in your table to none instead of the…

Build out powerful Power BI custom themes

This article provides ways for you to monitor and optimize the performance of the on-premises data gateway activities.

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

I have written a dozen of blogs and a book about Power BI row-level security and the security on the dataset. However, I always get this question that: "What if I want some people to see only a few pages of my report, and some others to see other pages?" or "How can I put…

Tracing and diagnostics for Power Query can get you crucial information to troubleshoot problems in Power BI Desktop. Find out how!

Learn how to use Power Automate to detect issues with your Power Query data refreshes in this hands on tutorial from PowerBI.Tips.

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…