Forum Discussion

Dali748's avatar
Dali748
Icon for Helper II rankHelper II
7 years ago

Edit Queries grayed out - How can I view the source data in Excel and append data to this source?

I still have access to an intern's account who no longer works here.  He created a report in "Service" under his "personal workspace" so there isn't an option to download the *.pbix file.  So I ended...
Need Help
Dali748's avatar
Dali748
Icon for Helper II rankHelper II
7 years ago

When I try to do the "Analyze in Excel" option on this dataset, the *.odc file downloads but when I try to open it I get a message saying "Excel cannot find OLAP cube Model..." but on datasets where I can download the *.pbix file I can open the *.odc file fine.

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Dali748 ,

 

I think the limitation section has described the reason why you can't download the pbix file:

 

  • To download the file, you must have edit access to the report.
  • The report must have been created by using Power BI Desktop and published to the Power BI service, or the .pbix file must have been uploaded to the Power BI service.
  • Reports must be published or updated after November 23, 2016. Reports published earlier aren't downloadable.
  • This feature won't work with reports and content packs originally created in the Power BI service.
  • Always use the latest version of Power BI Desktop when you open downloaded files. Downloaded .pbix files might not open in non-current versions of Power BI Desktop.
  • If your administrator has turned off the ability to download data, this feature won't be visible in the Power BI service.
  • Datasets with incremental refresh can't be downloaded to a .pbix file.

 

Community Support Team _ Jimmy Tao

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