Posts

Showing posts from July, 2022

ExecuteQueries REST API versus XMLA endpoints at scale

Image
Thanks to the ExecuteQueries REST API reaching general availability (GA), we’re seeing an increase in custom solutions that query Power BI datasets. We’re also seeing more questions in the Power BI community concerning the main usage scenarios that this API enables. The ExecuteQueries API broadens the reach of business solutions that use Power BI datasets, but there are important limitations. As mentioned in the blog post Unlocking new self-service BI scenarios with ExecuteQueries support in Power Automate, the ExecuteQueries API is a great choice for retrieving small chunks of data, automating dataset testing, and implementing BI-driven cloud solutions, among other things. One key characteristic that these scenarios have in common is that they work at a small scale. For example, the ExecuteQueries API restricts query results to 100,000 rows or 1,000,000 values per query (whichever is encountered first), so it is clearly not the right choice if you want or need to retriev...

Visualizing views in Dynamics 365 with Power BI is now generally available

Image
We’re very excited to announce that the Power BI integration in Dynamics 365 and model driven Power Apps, which shipped as a preview last December, is now generally available. Dynamics 365 and model driven Power Apps give organizations the ability to quickly build essential line-of-business apps in a low-code environment, increasing agility and modernizing processes. Since these apps are all built on top of Dataverse, they’re backed by your core business data. With this integration directly on views, information workers are now able to tap into this data and explore it using Power BI’s powerful data analytics capabilities without ever needing to leave their app. Just click the ‘Visualize this view’ button and let Power BI automatically create a report on top of the exact data you were looking at. Of course, with this integration moving to general availability, there are lots of new features as well. Read on to learn about all the recent improvements. Saving reports to the Powe...

Power BI July 2022 Feature Summary

Image
Welcome to the July 2022 update. We are thrilled to announce the Error Bars general availability, Metric visuals and Datamarts updates, query performance and data hub improvements, Data in space augmented reality new mobile feature, accessibility enhancements for embedded reports. There is more to explore, please continue to read on. Reporting Error Bars    Filled Map for Azure Maps visual Composite models on Power BI Datasets and Analysis Services   Bold/Italics/Underline for text inside the header tooltip Metric visuals updates Modeling New DAX function: NETWORKDAYS Support multi-role RLS in composite model Query performance improvement Data connectivity and preparation Connect to Datamarts (Preview) Display name support for the Dataverse connector BitSight Security Ratings (Connector Update) Databricks (Connector Update) Eduframe Reporting (New Connector) Funnel (Connector Update) Service Data hub improvements – data preview and export Mobile apps Introducing Data...