Discussion on "Calculating and Reducing Power BI Dataset Size Using Semantic Link"

Sandeep Pawar · 2024-02-29T23:22:12.538Z

Semantic Link v0.6 is out and it has many new exciting additions to its growing list of list_* methods. Highlighted are some of the new methods. Install the latest version and check it out. Some of the existing methods such as list_columns() have an...

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!

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 :)

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)

Discussion

Calculating and Reducing Power BI Dataset Size Using Semantic Link

Responses(3)

Recent discussions

Search Hashnode

Calculating and Reducing Power BI Dataset Size Using Semantic Link

Responses(3)

Recent discussions