Forum Discussion
Edit Queries grayed out - How can I view the source data in Excel and append data to this source?
HI Dali748 ,
If you were able to recreate the report that means you have access to the dataset. And this has nothing to do with the intern's Account.
Now if edit queries is grayed out that means you have limited access to play with your data.
You will have to request the person who provided the dataset to give you an access to edit queries. Also the refresh is set by the person who owns the dataset(view)
Thanks,
Tejaswi
Anonymous Thank you for the reply!
I'm logged in both Power BI "Service" and "Desktop" with the intern's account; so I should have full access to the dataset since he's the one that created it.
In "Desktop" I just selected the dataset and then recreated the report view, but I can't seem to find a way to actually see the dataset in "Edit Queries" because it's grayed out and I'm sure I have full access since I'm logged in as the intern who created it.
Could it be because he initially created this dataset from "Service" and not "Desktop"?
Dali748 ,
If you connect to the power bi dataset, you can't edit the dataset in power query because it's in live connection mode. So if you want to modify the dataset or change the data model, you need to download the pbix file from power bi service and publish to replace the current dataset. Click File-> Download Report(Preview) to download the 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.
v-yuta-msft That's another issue I'm having, based on my research online since he created this report from "Service" it doesn't give me an option to download the *.pbix file, it's grayed out.
https://docs.microsoft.com/en-us/power-bi/service-export-to-pbix#considerations-and-troubleshooting
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.
Hi Dali748 ,
I meant from where is your data coming. Which source? you will have to check with that.
I had similar problem with limited access and my source was SAP HANA database. I requested to give me an access to the database and this resolved my problem.
May be this helps you!
Thanks,
Tejaswi
