AI Insights in Power Query is a great Premium feature in Power BI. AI Insights Error can occur if you are not fully aware of the settings.
Throughout 2020 I have posted blog posts and videos covering mostly Power BI topics with some Power Apps and Power Automate posts. For me its made me learn topics properly and given me a buzz watching numbers rise. Various people have promoted blogs and videos and I cannot thank them enough. I’m am looking forward to being able to travel...
This post is to support my session at London Microsoft Reactor. The session series have all been introduction to Power BI. This session uses some Christmas Carol song lyrics and then using some AI premium tools to analyse the text. YouTube Recording Resources The Excel file used as the data can be found athttps://hatfullofdata.blog/wp-content/uploads/2020/12/Christmas-Carols.xlsx The background image and theme file...
There are times when you need to copy a dataflow from one workspace to another workspace. Power BI service provides a simple way to export the definition as a json file and then import. YouTube Version Export dataflow as json file In the workspace of the original workspace, click on the three dots next to the dataflow and select Export...
Find out which entity took the longest or caused the error in a refresh by looking at the refresh history of a dataflow in Power BI.
The new diagram view feature introduced Nov 2020, produces a brilliant diagram of how the queries and parameters relate within the dataflow.
Inform your users as to which dataflow to use by using Endorsement. This allows you to label a dataflow as promoted or certified.
This post is to support my virtual introduction to Power BI session for London Reactor on 16th November 2020.
Most dataflows needs to have scheduled refresh setup so that the data will be up to date ready for the reports connecting to it.
Create a Dataflow is a great way to give your report writers reusable transforms that doesn’t require data logins for every report writer.