Using PowerBI Datasets in multiple reports

Hi, CarlsBerg999 

Q:

In other words, we have 3 icons on the left side (Report, Data and Model). I only see Report and Model when i open a report that is connected to the PowerBI Dataset. I need to download the original PowerBI Dataset from the service to add calculated columns or tables. Is this a setting thing?

Yes ,it's a setting thing. When you connect to a Power BI dataset, you can only see the Report and Model Icons, and the connection is Live Connection. You cannot create calculated columns or calculated tables, but you can still create report-level measures.

You can think of it as creating a copy connected to the source data, so you can't modify the original PowerBI Dataset directly. When you download the original PowerBI Dataset from the service, then you can modify the original PowerBI Dataset.

Q:

What becomes difficult is determining where a calculated column or a measure is used. Is there a functionality of "Where used" or some way to get this data? 

Power BI desktop itself doesn't offer such a feature, but you can still use third-party tools to help you.

Refer to my answer in the thread below to help you:
Unused measures affecting performance?

more:

Monitor/Measure & Improve Power BI Dataset Performance

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

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