Latest Power BI and AI articles from RADACAD team
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 about Export data from Power Query to Local Machine or SQL Server using R scripts[…]
Does it take a long time to get your data refreshed in your Power BI model? Should you wait for hours for the refresh to finish because you have complex transformations behind the scene? Does the long refresh time make it hard for you to develop your solution? The good news I have for you Read more about How to Use Dataflow to Make the Refresh of Power BI Solution FASTER![…]
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 about Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 2[…]
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 about Applied more Analytics on your data with Key Influencer Visualization[…]
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 about Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 1[…]
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 about Copy workspace, Publish to Multiple workspaces, Download all PBIX files, and much more in Power BI Helper April Edition[…]
This article explains the setup instructions to work with the Service tab of the 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 Read more about Register Power BI Helper in Your Tenant[…]
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 about Workaround for Computed Entity in Power BI Pro: Dataflow in Power BI[…]
As starting my Power Apps learning journey from the last 6 months, I presented a session on Power Apps in Microsoft Ignite Sydney 2019, In that session, I demonstrated some of the features for Power Apps. One of the features that was interesting to me was Barcode Scanner for web browser available in the Preview Read more about Barcode Scanner with Microsoft Power App[…]
I have written about Date Dimension in Power BI in many posts, and it makes sense now to explain one of the most common performance challenges that I see in some of the models. Sometimes, your model size grows significantly big, and you have no idea why!? In this article, I will show you one Read more about Performance Design Tip for Power BI: Be Careful of Dates[…]