Category: Power BI

Reference from Another Query in Dataflow – No Premium Needed – Power Platform Dataflows

Posted on by Reza Rad

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 Read more about Reference from Another Query in Dataflow – No Premium Needed – Power Platform Dataflows[…]

Power BI Get Data from Multiple Files in a Folder on OneDrive for Business, No Gateway Needed

Posted on by Reza Rad

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 Read more about Power BI Get Data from Multiple Files in a Folder on OneDrive for Business, No Gateway Needed[…]

What Happens to Your Job With the Revolution of Power BI and Self-Service BI?

Posted on by Reza Rad

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 Read more about What Happens to Your Job With the Revolution of Power BI and Self-Service BI?[…]

New Video Course: DAX and Calculations in Power BI

Posted on by Reza Rad

We are pleased to let you know that our DAX and Calculations in Power BI video course is now available. This course, like many other video courses we offer, is part of the Power BI from Rookie to Rock Star training. This is a course to consider if you need to create calculations for adding Read more about New Video Course: DAX and Calculations in Power BI[…]

Get the Image URL in Power BI Using Power Query Get Table from Example

Posted on by Reza Rad

I have written previously a blog article that I explained in detail how I fetch the image URL from a website using Power Query. That method, however, is what I call a bit of a techie way of doing it because you have to look at the HTML code of the page. There is an Read more about Get the Image URL in Power BI Using Power Query Get Table from Example[…]

Microsoft Regional Director’s Power BI Report

Posted on by Reza Rad

Over the last week of December 2019, I’ve had a bit of time to play with some free available datasets over the internet. One of them was the SQL Saturday data which I built a Power BI report for it, and another one is the Microsoft Regional Director‘s data. Let’s see what I built for Read more about Microsoft Regional Director’s Power BI Report[…]

Refresh Power BI Queries Through Power Platform Dataflows: Unlimited Times with Any Frequency

Posted on by Reza Rad

If you don’t have a Power BI Premium capacity license, then you are limited to refresh your dataflows up to eight times a day, with the frequency of 30 minutes. The good news for you is that you have a way to do unlimited refreshes and with whatever frequency you like using Power Platform Dataflows. Read more about Refresh Power BI Queries Through Power Platform Dataflows: Unlimited Times with Any Frequency[…]

Change Excel Source in Power BI to OneDrive for Business – No Gateway Needed

Posted on by Reza Rad

If you used an excel file in a local source (or even OneDrive for Business, but sourced locally), you need to do one extra step to make your query refreshable without the need to the gateway. Here in this blog post, I’ll explain an easy way to do that change. If you want to learn Read more about Change Excel Source in Power BI to OneDrive for Business – No Gateway Needed[…]

What should be your Salary in 2020 if you work with Power BI?

Posted on by Reza Rad

The Power BI 2020 Salary survey was popular enough to get some interesting results. In this post, I am sharing the result of that survey (which is filled by the public) as a Power BI report. The report gives you an overall idea of how much the minimum, maximum, and average salary should be based Read more about What should be your Salary in 2020 if you work with Power BI?[…]

Power BI Helper December 2019 Feature Summary

Posted on by Reza Rad

December 2019 is a major update in Power BI Helper. We believe this is the biggest update we have done so far. The list of updates is big. To name a few, now we have pages, visuals and bookmarks metadata available, visual comparer, visualization tree, the reverse dependency tree, DMV execution page, and dependant calculations Read more about Power BI Helper December 2019 Feature Summary[…]