Power BI Weekly

Issue #107 - 27th April 2021

No updates to provide this week. We have, though, been told about the Microsoft Business Applications Summit on May 4th, 2021 where you can learn about upcoming features alongside cool demos right across the Power Platform. Do check that out - there always seems to be at least one killer feature that's demoed at the MBAS summit (which we then often have to wait for to be released, but it's still nice to see what's coming up!) Also on the official blog, Kay Unkroth has described how to use XMLA endpoints to change data sources in a Power BI dataset, showing just how flexible programmatic access to your data model is using the XMLA endpoint. Elsewhere this week, Chris Webb has written Can I Build A Power BI DirectQuery Dataset On Top Of A REST API?; the simple answer being "No" unless you go custom or bring in a third party. Finally, Ruth Pozuelo Martinez has described how to use the new Power Automate custom visual to create a Export to Excel / CSV button in Power BI, creating a file in some common file store. Obviously this is just one example of new functionality enabled by this new visual, but really the sky's the limit!