cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dataguy
Helper III
Helper III

Cannot View Measure Definitions on a Downloaded Report

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!

1 ACCEPTED SOLUTION
VasTg
Memorable Member
Memorable Member

@dataguy 

 

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.

Cap11.PNG

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.

 

Connect on LinkedIn

View solution in original post

5 REPLIES 5
yingyinr
Community Support
Community Support

Hi @dataguy ,

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 .

connection mode1.jpg

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.

 connection mode2.jpg

Best Regards

Rena

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

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
Memorable Member
Memorable Member

@dataguy 

 

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.

Cap11.PNG

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.

 

Connect on LinkedIn

View solution in original post

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

VasTg
Memorable Member
Memorable Member

@dataguy 

 

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.

Connect on LinkedIn

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors