Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

Connection to a Dataset

For the last two years I have a process of updating a large PBIX file and publishing it. Then I make changes to a copy, saving it as a different name, then removing the Power Query queries to empty it of data, and finally go to Power BI datasets to connect to the original PBIX, thus getting a variation report which I can then publish to the cloud.

With March 2020 Desktop version I now get this error message when i click on the Power BI datasets icon on the ribbon. There are no query statements in the file.
Datasets.jpgPower Query.jpg


This is a big problem for me. Can anyone advise? Is this just my copy or do other people have the same problem?

My alternate method will be to publish three datasets (there's a second report still to do) but that could be a problem for us in terms of data size, memory, etc.

Community Support
Community Support

Hi @Anonymous ,

If you have access to Admin Portal in power bi service, you can try this way:

  1. Go Power BI service
  2. Go to the Admin portal
  3. Click Tenant settings on the left side and check the export and sharing settings
  4. Enable the export data feature

admin portal.png

If you have no access, please contact your administrator to try.


Best Regards,

Yingjie Li


If this post helps then please consider Accept it as the solution to help the other members find it more quickly.


Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.