RADACAD Blog

Latest Power BI and AI articles from RADACAD team

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

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

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

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

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?

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

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[…]

Automating machine learning with SQL Server 2019

Automating machine learning with SQL Server 2019 By Leila Etaati   Machine learning is a powerful tool for making predictions based on data. With a plethora of models and approaches available to choose from, simply knowing where to begin can be a project in itself. Data scientists can spend a significant amount of time configuring, Read more about Automating machine learning with SQL Server 2019[…]

Analyzing PASS SQL Saturday data using Power BI

I use Power BI for analyzing any data! and recently realized that there is no public report about SQL Saturdays around the world, hence, I build this report. This report is using live data from SQL Saturday website. What is SQL Saturday If you don’t know what SQL Saturday is, here is some information: SQL Read more about Analyzing PASS SQL Saturday data using Power BI[…]

Power BI Salary Survey and Report 2020

Are you underpaid? or you are getting paid in the market range? If you are looking for a job, what range of salary you should be looking for? The Salary survey and the report is helpful to answer these questions. The salary survey, is a form that everyone fills, and from the result of that, Read more about Power BI Salary Survey and Report 2020[…]

DAX Variables: Better Readability, Consistency, and Performance in Power BI Calculations

Have you ever had a scenario that you need to use part of your calculation multiple times? You might go and create a table or column for that and then re-use it. However, there are times that you just need that calculation to be re-used multiple times within one place. DAX variables can help you Read more about DAX Variables: Better Readability, Consistency, and Performance in Power BI Calculations[…]