Posts tagged: DirectQuery

Announcing general availability of automatic aggregations

Today, we are excited to announce General Availability (GA) of automatic aggregations, along with several important improvements. By using automatic aggregations in Power BI Premium, you can unlock cloud-scale data volumes for interactive analysis. Automatic aggregations import data into the dataset only at the aggregated level while leaving the detail data at the source to minimize data duplication. In this way, most BI queries can benefit from Power BI’s blazing fast query performance in import mode, while occasional detail queries can still work transparently against the data source in DirectQuery mode.

» Read more

Update to required permissions when using composite models on a Power BI dataset

The ability to create a composite model on top of a Power BI dataset or an Azure Analysis Services model is in preview since December 2020. Since then, we have seen great adoption of this feature and have received great feedback that allowed us to make it even better! The team has been hard at work readying the feature for general availability, and although we are not announcing that today, we have great news to share regarding permissions.

» Read more

Announcing Public Preview of Hybrid Tables in Power BI Premium

We are excited to announce support for Hybrid Tables and Incremental refresh with real-time data in Power BI Premium to strike the right balance between query performance and data freshness. Now you can have blazing fast performance in import mode and the latest data changes in the data warehouse reflected in user reports without having to perform a dataset refresh.

» Read more

Power BI June 2021 Feature Summary

Welcome to the June update! Loads of updates on connectors this time around. Also, DirectQuery support for Dataflows is now generally available! On top of that, we are happy to announce the preview of the paginated reports visual – we know many of you have been eagerly awaiting it, so take it for a spin and provide your feedback! Our Small Multiples and DirectQuery for Power BI datasets and Azure Analysis Services previews are still ongoing and receiving some updates this month. There is much more, so read on!

» Read more

Microsoft Business Application Summit Recap

There is a big chance you haven’t been able to catch all the news at MBAS or that some items just escaped your attention as they were drowned out by the next big thing. Don’t worry, we’ve got your back. In this post we do our best to recap what happened en provide links to the detail blog posts where applicable. Also, we’ll list the session so you can go and re-watch them.

» Read more

Power BI April 2021 Feature Summary

Welcome to the first Power BI feature summary of the Spring! In this update we have an exciting new preview for the Power Automate visual! Also, the ongoing previews (Small Multiples and DirectQuery for Power BI datasets and Azure Analysis Services) are getting some new features. Next to that, we are presenting huge improvements to the shapes in Power BI Desktop and we are introducing a new, easier, way to share reports. To top it off, enhancements to Sensitivity Labels provide for even better protection of your data. Of course, there is much more, so read on!

» Read more

Power BI March 2021 Feature Summary

This month, we are continuing our work on the ongoing previews of DirectQuery for PowerBI datasets and Azure Analysis Services, Small Multiples, and the Model View UI. Also, we are making it easier to specify filters in the DAX CALCULATE function. On the Service side, when you click on a dataset in the workspace list view you will be taken to our new dataset details page, which includes information about when the report was last refreshed as well as actions such as creating a new report. Of course, there is much more, so read on!

» Read more