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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
mmr1879
Regular Visitor

The measurement are missing after creating in tabular editor and load in the PowerBI

I have about 500 measurement already created in PowerBI that have been created in Tabular Editor. After closing the Tabular Editor, I can still see the measurement are exists in the PowerBI. When I click one of the measurement, I still can see the formula. After clicking the other formula, It will start loading and showing:

 

 Refresh:

Queries Metadata

Loading data to model....

 

After that my measurement will be disapper for the measurement that I clicked on it.

 

I already try the following method but none of it works:

  1. Uninstall the tabular editor and PowerBI.
  2. Create using new fresh file and recreated the measurement back.
  3. Get new template from development team and recreated the measurement back.

I already create a sampel file but it seem the error is not there.

 

1 ACCEPTED SOLUTION
v-tangjie-msft
Community Support
Community Support

Hi @mmr1879 ,

 

Refer this document , for queries for which the source data is not updated often or at all, it makes sense to not have the queries included in the refresh of the report. In this scenario, you can exclude queries from being refreshed when the report is refreshed by un-checking 'Include in report refresh' in the context menu of the query in Desktop or in the Properties screen:

vtangjiemsft_0-1669187260114.png

Too many measures will also burden the memory usage of the desktop, you can refer to this to optimize the measures.

 

You can also refer to the answers to similar question posts below:

Solved: Queries Metadata Loading data into Model... Fail - Microsoft Power BI Community

 

Best Regards,

Neeko Tang

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

View solution in original post

1 REPLY 1
v-tangjie-msft
Community Support
Community Support

Hi @mmr1879 ,

 

Refer this document , for queries for which the source data is not updated often or at all, it makes sense to not have the queries included in the refresh of the report. In this scenario, you can exclude queries from being refreshed when the report is refreshed by un-checking 'Include in report refresh' in the context menu of the query in Desktop or in the Properties screen:

vtangjiemsft_0-1669187260114.png

Too many measures will also burden the memory usage of the desktop, you can refer to this to optimize the measures.

 

You can also refer to the answers to similar question posts below:

Solved: Queries Metadata Loading data into Model... Fail - Microsoft Power BI Community

 

Best Regards,

Neeko Tang

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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