Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Cannot see how measures are calculated, blank Power Query

I have downloaded a pbix file from the online platform, the file was created by someone else. In the file, there are connections to mongo db, big query and a third party database, the first two I have access to, the third I do not.

 

I want to see how they calculated some measures, as this is a large file, however I cannot see the usual top bar with a formula. 

 

I can see only report view and model view, not the third one usually visible (screenshot below) .

 

marzwrob_0-1703753972415.png

When Igo to Transform data, I get the warning as in screenshot below. I add a local model, it seems to be processing and finish, and then I get the Transform data with absolutely nothing like in screenshot below

 

marzwrob_1-1703754041948.png

 

marzwrob_2-1703754218905.png

 

I never worked with a report uploaded by someone else outside the organisation and I dont know how to solve this so i can document how these measures are calculated, and edit if necessary.

 

Does anyone have an idea what I can do in this case?

1 ACCEPTED SOLUTION
olgad
Super User
Super User

Hi, make sure you chose the first option while downloading, then you will be able to see the measures and their calculations. 

 

olgad_0-1703765987805.png

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

4 REPLIES 4
olgad
Super User
Super User

Hi, make sure you chose the first option while downloading, then you will be able to see the measures and their calculations. 

 

olgad_0-1703765987805.png

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
Anonymous
Not applicable

Hi @olgad your message was what. Ineeded , turns out that I needed to convert from a large data model and then I can download the file and see the metrics. Thanks!

Always welcome! Please dont forget to like the answer as well:)) 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
Anonymous
Not applicable

Thanks @olgad , this option is not available for me:, not sure how to solve it

marzwrob_0-1703769736131.png

 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors