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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
tdjohnson7700md
Regular Visitor

Measures disappeared in Data Mart created from a Data flow in Power Bi Service with Direct Query

Good afternoon everyone.  I am doing some work for a company who wanted me to design a pagained report--in doing so, they have put their data into dataflows and brought them into a data mart in the service--They wanted me to design the power bi report and measures in the service from the direct query and then create the paginated report-I am used to using the import mode on the desktop, so needless to say, this has been a challenge.  I did have everything going forward until recently.   Fast Forward to the other day--IT did some changes to the data flows and rebuilt the data mart--in doing so, ALL my measures have disappeared. The measures weren't in what IT was fixing, so I am not sure why they disappered.  My date table is also broke, but I can fix that. 

 

I had all my measures in a table.  The table is still there, but all of my measures are gone.  I had well over 100 of them.  I don't know of any place in the service that creates "versions" like the desktop, so I am at a loss of how to fix this except to recreate them.  I do have the power bi file in the service where the visuals are now broken, so I can look at those and try to recreate the measures from that.  Does anyone have another idea?  I know this is a holiday weekend, but if anyone has a fix for this or has experienced it and knows how to prevent it from happening again, I would greatly appreciate it.  #directquery, #powerbiservice, #measures

2 REPLIES 2
msabourin89
Regular Visitor

I also would like to have help on it. I noticed that depending on the connexion used, I have or not the measures from datamart. 

If I connected to datamart using 'Datamart preview connexion' on DirectQuery, I see my measures.
lbendlin
Super User
Super User

Having over 100 measures is already a red flag.

 

You have to remember that whenever you change the structure of your data source query and the final result differs from the previous version on a meta data level (say, you removed a column) this will have near-catastrophic impact on your measures, groups, hierarchies and sort orders.   At the very minimum you need to make a backup of your prior version before attempting these changes.

 

Restore the backup if you have one, otherwise take this as a hard lesson learned.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 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.