Cannot View Measure Definitions on a Downloaded Report

[Anonymous]

The data is imported for the Power BI model for this report.  What also seems odd is that the Model and Data icons are missing with just the Report Icon showing.

Need help understanding what is going on. We need to make an update to some measures in the report.

Thanks!

[Anonymous]

Hi @Anonymous ,

What data source you are connecting to ? What connection mode was applied ? The available views tab is different depending on the data source and connection method . For example , the data source you connect to be SQL Server, and the connection mode is Import , then " Report " , " Data " and " Model " view tabs are all available . However , if applied direct query connection mode with same data source , " Report " and " Model " view tabs are available .

Besides that, if connect the data with Power BI dataset or SQL Server Analysis Service(connection mode: live connection), then only “Report” tab is available. If your scenario is same with this, you have to update the measure in original dataset/model.

 

Best Regards

Rena

[Anonymous]

Rena,

You are correct. The report was devolped using a dataset via the service. So now I understand why I can't see the measures. The interesting part was going into the data source settings where it didn't tell me what datasource/dataset was being used.

Thanks again for your help - greatly appreciated!

[VasTg · Accepted solution]

@Anonymous 

As I mentioned in my previous post, you could check the souce dataset at the bottom right.. In my case, my report is connected to dataset "Email Test" in "BI-Dev" workspace.

There are certain limitations.

Keep in mind that when you rename the column/measure name in the orginal dataset, it will appear as a new column/measure and all the visuals that used the old name will be broken.

If this helps, mark it as solution.

Kudos are nice too.

[Anonymous]

Wow - my eyes didn't pick that up. Thanks you have a been a great help!

[VasTg]

@Anonymous 

Is that report connected to Power BI Dataset as a source? If so, the Report and Model icons won't appear.

If you want to view/change the measure definition or modify the model, you would have to do it in the dataset.

The bottom right shows which dataset the report is pointing too.

Also, When you rename a column in the dataset, it won't reflect the related report. It will appear as a new column and you have to fix all the visuals.

If this helps, mark it as a solution

Kudos are nice too.