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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
CJunior
New Member

Issue with Accessing DAX Formulas in Power BI Desktop after Downloading Published Dashboard

Hello everyone, I have a question about a small issue that occurred. Well, basically I'm using Power BI Desktop and Power BI web in Microsoft 365 with different workspaces. The dashboards are built in Power BI Desktop and published in the workspaces.

What happened was, someone built 2 measures in one of the dashboards and published that dashboard, the metrics working correctly and appearing in Power BI web, but if I were to download the dashboard, for example, I can see the measures in my Power BI Desktop data tab but when I click on the measures I am not able to see the DAX formula used to create that metric.

The possible justification I found for this is that if the person made the formulas on a local machine other people cannot access them even if they download the published dashboard.

This is a problem because it means that if I no longer have contact with that person or something happens to their machine we would lose all the codes used, even though the metrics are working and appearing normally when published

I want to know why this happens and if there's a way to resolve it

1 ACCEPTED SOLUTION
Bmejia
Super User
Super User

One possible reason is that the report you downloaded is using the dataset from a different report.  Usually you won't see a table view option.  If this is the case then you would need to identify the dataset being use by going into transform data/Data Source Setting.  Then look for the report and make the changes there.

Bmejia_0-1712175332480.png

 

View solution in original post

1 REPLY 1
Bmejia
Super User
Super User

One possible reason is that the report you downloaded is using the dataset from a different report.  Usually you won't see a table view option.  If this is the case then you would need to identify the dataset being use by going into transform data/Data Source Setting.  Then look for the report and make the changes there.

Bmejia_0-1712175332480.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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