1.7K reads
7 comments
Hi Sandeep. Thanks for the article. When I run the code I get this error: AdomdErrorResponseException: The 'xxxxx' user does not have permission to call the Discover method. I am setup as workspace admin. Any idee where I can fix this?
The error indicates either the workspace is Pro (not premium), doesn;t have an XMLA endpoint and/or it's a default dataset. In my code I tried to capture this as an exception but may not have worked for your instance.. whats the dataset, where is it ?
or it could be a dataset generated by a datamart (which doesnt have an xmla endpoint)
Hi Sandeep. Thanks for the article. A bit confused here..Could you please tell me where exactly we need to run this code. I don't see any capacity details being passed on the code..Is this something I can run in Power BI Desktop using parameters.?? Will really appreciate if you can give some pointers. TIA
Hey Sumanta Das .. you need to run this in Fabric notebook not in Power BI desktop. I will update the blog to make it clear.
Sandeep PawarThank you Sandeep :)
Hello Mr Sandeep! Many thanks for putting this together and sharing with the community. Fantastic gesture
I wanted to ask a question, please. I managed to run the first code snippet in my Notebook, but it looks like it returned data from only one workspace. I have checked the Admin portal to turn on XMLA to "Read Only". I was wondering if you could share any more info to allow the code scan through the entire tenant. Do I need to have admin role in all the workspaces?
Thank you!