5/13/2023 0 Comments Power automate desktopImagine a hypothetical IoT scenario where thousands of devices send billions of data points per day. Now with the support for in-partition aggregations, you can obtain data in real time and optimize performance with the aggregations being executed in Azure Cosmos DB, avoiding the load of big volumes of data into Power BI cache. The DirectQuery mode in the V2 connector enables you to query and visualize large Azure Cosmos DB datasets without the limitations imposed by the Import mode.īefore the V2 connector, Power BI developers and users were limited to the imported dataset, refreshed or not with a fixed schedule. This new capability unlocks real time reporting and enables connecting directly to Cosmos DB without needing to import the data into Power BI cache. The DirectQuery mode enables queries pushdown, including aggregations to the Azure Cosmos DB container, when a filter on partition key is specified. Real-time reporting without importing data It’s available now on Power BI components including Desktop, Power BI service, Power BI Mobile and on the Power Query platform. The new V2 connector also supports Azure Cosmos DB as a data source in Power BI dataflows. The Azure Cosmos DB V2 Connector for Power BI, with support for querying the Azure Cosmos DB transactional store in both DirectQuery and Import modes, is now in preview.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |