Posts

Showing posts with the label Jul

On-premises data gateway July 2022 update is now available

We are happy to announce that we have just released the July 2022 update for the On-premises data gateway (version  3000.134.9 ). This update doesn’t include changes to the data gateway application. Go to  On-Premises Data Gateway (standard Mode) download page. Go to  On-Premises Data Gateway (Personal Mode) download page. Compatible with July Power BI Desktop

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...

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...