Posts

Showing posts with the label Dataset

Announcing backup and restore improvements for large datasets near the size limit

Image
In August 2021, we announced  general availability (GA) of backup and restore for large datasets . This Power BI feature closes an important gap to Azure AS. You can backup Power BI datasets on a regular basis to meet the data retention and disaster recovery requirements of your organization. You can also use this feature to migrate enterprise BI workloads from Azure AS to Power BI. Another common scenario is to roll back an existing Power BI dataset to a previous version. Yet, rolling back was not without challenges for large datasets near the max dataset size. But thanks to the latest improvements, you can now even restore a backup file when the dataset size is near the SKU limitation. You no longer need to be concerned that size limits impact restorability. For example, a P3 capacity has a max dataset size of 100 GB. If you wanted to maximize memory usage, you might have intended to host a dataset with 70 GB on this capacity. However, prior to the recent backup and restore ...

Dataset refresh cancellation is now available in Power BI Premium

Image
We are excited to share that cancelling an in-progress dataset refresh in Power BI Premium, Power BI Premium Per User, and Power BI Embedded just got significantly easier. A top-20 idea on Power BI Ideas (we do listen and appreciate your feedback), we acknowledge that this capability couldn’t have come soon enough for our customers. In the past, cancelling an ongoing refresh was an unreliable process that required external tools. Earlier this year, we released the Enhanced refresh with Power BI REST API, that – in addition to XMLA based refreshes – allows refresh cancellation. However, it requires the refresh operation to be triggered by the API. Today, users can cancel an ongoing scheduled or on-demand refresh using a contextual button in the Power BI service. Earlier limitations that constrained cancellation no longer apply. To begin using this feature in your Premium workspace, no actions are required. Please note that for datasets created as part of Datamart...

Introducing Cross-tenant Power BI Dataset Sharing

Image
Introducing Cross-tenant Power BI Dataset Sharing Our new cross-tenant dataset sharing capability is now available in public preview! This exciting capability allows customers to share their Power BI datasets with external users (consumers) in a way that allows these external users to access the datasets in their own Power BI tenant. This is in-place sharing, meaning that from their own tenant, consumers can discover and connect to live data from providers. They can then work with these shared datasets in their own tenant and create composite models by meshing the shared datasets with their own internal data. The composite model can then be published on the service for reporting purposes.   With in-place sharing, the shared data remains in the provider tenant. Consumers query the shared datasets directly in the source data systems. Consumers can connect to external datasets using the Direct Query method and build their own composite models and reports on top of the shared data, eli...