---
title: "Discussion on \"Calculating and Reducing Power BI Dataset Size Using Semantic Link\" | Hashnode"
description: "Discussion on \"Calculating and Reducing Power BI Dataset Size Using Semantic Link\". Using Semantic Link v0.6 to find dataset optimization opportunities across workspaces"
url: "https://hashnode.com/posts/calculating-and-reducing-power-bi-dataset-size-using-semantic-link/65e111a44415a26cd718b44c"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Calculating and Reducing Power BI Dataset Size Using Semantic Link](https://fabric.guru/calculating-and-reducing-power-bi-dataset-size-using-semantic-link?utm_source=hashnode&utm_medium=feed)

Using Semantic Link v0.6 to find dataset optimization opportunities across workspaces

Feb 29, 2024 · 6 min read · fabric.guru  
Read the article

-   [#dataset-optimization](https://hashnode.com/tag/dataset-optimization)
-   [#vertipaq-analyzer](https://hashnode.com/tag/vertipaq-analyzer)
-   [#microsoft-fabric](https://hashnode.com/tag/microsoft-fabric)
-   [#microsoftfabric](https://hashnode.com/tag/microsoftfabric)
-   [#semantic-link](https://hashnode.com/tag/semantic-link)

## Written by

[Sandeep Pawar](https://hashnode.com/@PawarBI)

@PawarBI

  
[View profile](https://hashnode.com/@PawarBI)

Building Data Analytics and Data Science solutions using Microsoft Fabric | Principal PM, Microsoft Fabric CAT

Principal Program Manager, Microsoft Fabric CAT helping users and organizations build scalable, insightful, secure solutions. Blogs, opinions are my own and do not represent my employer.

## Responses 3

Markdown supported · ⌘↵ to post

[Afeez Raheem](https://hashnode.com/@AfeezRaheem)

[Apr 2, 2024](https://hashnode.com/posts/calculating-and-reducing-power-bi-dataset-size-using-semantic-link/65e111a44415a26cd718b44c/comment/660c40f995784e3fde989d9f)

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!

[Sumanta Das](https://hashnode.com/@das448)

[Mar 21, 2024](https://hashnode.com/posts/calculating-and-reducing-power-bi-dataset-size-using-semantic-link/65e111a44415a26cd718b44c/comment/65fc8a19e5b3d1fd633325e9)

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

[Mar 21, 2024](https://hashnode.com/posts/calculating-and-reducing-power-bi-dataset-size-using-semantic-link/65e111a44415a26cd718b44c/comment/65fc8a19e5b3d1fd633325e9#reply-65fc9dc1e451d1cc96ff3456)

Hey [Sumanta Das](https://hashnode.com/@das448) .. you need to run this in Fabric notebook not in Power BI desktop. I will update the blog to make it clear.

[Sumanta Das](https://hashnode.com/@das448)

[Mar 21, 2024](https://hashnode.com/posts/calculating-and-reducing-power-bi-dataset-size-using-semantic-link/65e111a44415a26cd718b44c/comment/65fc8a19e5b3d1fd633325e9#reply-65fc9e64398512b3b78037ef)

[Sandeep Pawar](https://hashnode.com/@PawarBI)Thank you Sandeep :)

[Martin du Toit](https://hashnode.com/@martindut)

[Mar 12, 2024](https://hashnode.com/posts/calculating-and-reducing-power-bi-dataset-size-using-semantic-link/65e111a44415a26cd718b44c/comment/65f01b0b1d5e027184d5f457)

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?

[Sandeep Pawar](https://hashnode.com/@PawarBI)

[Mar 12, 2024](https://hashnode.com/posts/calculating-and-reducing-power-bi-dataset-size-using-semantic-link/65e111a44415a26cd718b44c/comment/65f01b0b1d5e027184d5f457#reply-65f0c814c76e9ddbd7f84c88)

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 ?

[Sandeep Pawar](https://hashnode.com/@PawarBI)

[Mar 12, 2024](https://hashnode.com/posts/calculating-and-reducing-power-bi-dataset-size-using-semantic-link/65e111a44415a26cd718b44c/comment/65f01b0b1d5e027184d5f457#reply-65f0c83f328b0bcd0c5f44ed)

or it could be a dataset generated by a datamart (which doesnt have an xmla endpoint)
