Power BI
MergedDownload .pbix from Service with "Live Connection" - Even if Dataset has Incremental Refresh, etc.
Kevin H on 11 Dec 2018 23:59:18
If I create a .pbix report file in Power BI Desktop with a "Power BI service" live connection to a dataset in the Service, then publish the report to the Service...and if that dataset has incremental refresh policies...then I cannot subsequently download the .pbix report file with the live connection. It says: "Can't export to Power BI Desktop format. This dataset has some features in it that can't be downloaded to a .pbix file." (Namely, incremental refresh policies.)
This is silly! The .pbix I am trying to download just needs to have the live connection to the dataset, and the report definition. It does not HAVE incremental refresh policies; it only points to a dataset that has incremental refresh policies.
Reports should be more separate from datasets. We have many users publishing reports. Please, I need to be able to download the reports as small .pbix files, with "Power BI service" live connections (and no data) -- no matter what.
Jeroen ter Heerdt (administrator) on 22 Feb 2022 23:29:06
Parts of this scenario have been released in the latest update: https://powerbi.microsoft.com/en-us/blog/power-bi-february-2022-feature-summary/#post-18588-_Toc95419018. The other part of this scenario (downloading a brand new pbix or a pbix that was created online with a live connection to a dataset with these settings) is planned!