Export data from Power Query to Local Machine or SQL Server using R scripts

There is always a discussion on how to store back the data from Power BI to local computer or SQL Server Databases, in this short blog, I will show how to do it by writing R scripts inside Power Query.   First how to Store Files to PC To store data back to a file ...

Read More

Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 2

In the first part of this series, you learned how to create an exception reporting for a column in a table using Power Query in Power BI. In the second part, you learned how to initiate that process for all columns in a table. This article continues the section one of creating exception reporting for ...

Read More

Applied more Analytics on your data with Key Influencer Visualization

In this post, I am going to demonstrate a new visualization that has been released by the AI team in Power BI in recent months. Before showing off the nice features, there are some key points about this visual. http://datascientistyuyuria.blogspot.com/2017/06/ It can be used by Data sciences, Data engineer and End users.  It is easy ...

Read More

Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 1

Previously, I have written about using Power Query transformations and functions to create an Exception report for Power BI. However, the method I mentioned there, was only doing the exception handling based on one column. In this article, I’m explaining how to do exception reporting for all columns in the entire table. There are a ...

Read More

Copy workspace, Publish to Multiple workspaces, Download all PBIX files, and much more in Power BI Helper April Edition

Posted by on Apr 11, 2019 in Power BI, Power BI Helper | 4 Comments

In RADACAD we do our best to improve user experience using Power BI every single day, and throughout that experience, we add more and more functions to Power BI Helper. The newest version of Power BI Helper comes with break-through functions such as connecting to service. Documenting all service objects such as workspaces, datasets, dashboards, ...

Read More

Register Power BI Helper in Your Tenant

Posted by on Apr 11, 2019 in Power BI Helper | 4 Comments

This article explains the setup instructions to work with the Service tab of Power BI Helper. Download Power BI Helper from here. Power BI Helper is a third party application, and any third party application if wants to connect to your tenant, needs to be authorized. You need to give permission to the Power BI ...

Read More

What Is the XMLA Endpoint for Power BI and Why Should I Care?

The news about XMLA endpoint connectivity to Power BI datasets is now all around the internet after the public preview announcement of that last week. However, I realized that the XMLA endpoint term is still too technical for many Power BI report developers. Many people come to me asking what exactly is XMLA endpoint, and ...

Read More

Workaround for Computed Entity in Power BI Pro: Dataflow in Power BI

I have previously written about What dataflow is and scenarios of using it. I also wrote an article about Computed Entity and the important role of that for performance and data lineage. However, a Computed entity is a premium-only feature. There are sometimes that you don’t really need premium functions of Power BI, and only ...

Read More