BI-NIGHT – Power BI (Export to PowerPoint, New Visual Liquid Fill Gauge, Tech Tip Display Text, Automating Power BI Desktop Refresh, Webinar Create PowerApps to send real time data to Power BI) – DAX Studio (Release 2.5.0)
Another week closer to SQL Pass, and here are the recent updates and interesting articles
Power BI – Export to PowerPoint
It is great to see that after some screenshots from Microsoft Ignite that this has already been implemented into the Power BI Service. I am sure that there will be more details around this in due course from the Microsoft Power BI team.
I did export a Power BI report to PowerPoint and it exported each report to a different slide. And when you clicked on the slide it would then hyperlink you to the report within the Power BI Service. I am sure that this is the first iteration, and that the features will evolve over time.
You can find the blog post from Microsoft here: Export Power BI report to PowerPoint (Preview)
Power BI – New Visual Liquid Fill Gauge
As you can see from above there is a new custom visual, the Liquid Fill Gauge. And this is another really handy visual when you quickly want to show how your value is doing.
You can find the blog details here: Visual Awesomeness Unlocked: Liquid Fill Gauge
Power BI – Tech Tip to Display Text in Tooltips
From the people at Power BI, they have released a tech tip Thursday, with this week’s tip being how to display text as a tool tip as shown above. This can be really handy for when people are interacting and using the data.
You can find the tech tip details here: Tech Tip Thursday: Displaying text columns in tool tips
Power BI – Automating Power BI Desktop Refresh
There was an interesting blog post by Teo Lachev, in which he shows 2 different ways to refresh your Power BI Desktop File automatically.
The one option is to use a PowerShell script developed by Michal Dúbravčík (I am fairly certain that it works, but as always check the code when downloading from the internet), or the other option is to use Power Update to do this for you. Which is really easy and simple to use, as well as being extremely cost effective.
You can find the details here: Automating Power BI Desktop Refresh
Power BI – Create PowerApps to send real time Power BI
Hopefully people will see this in time, and if not I am fairly certain that they will publish the webinar later.
But please if you are interested and are using Power Apps, this looks like a great webinar to see how you can leverage Power Apps to send real time data to Power BI.
You can find details here: Webinar 10/20: Create PowerApps to send real time Power BI data
DAX Studio – Release 2.5.0
I have to say that anyone that is developing using Power BI, Power Pivot or SSAS Tabular then the DAX studio is most certainly a must have tool to have in your tool belt.
It offers a whole range of really useful and helpful ways to understand exactly what you are trying to achieve. And ensure that you do it in the most efficient way possible.
You can find the updates to DAX Studio here: DAX Studio 2.5.0 Release