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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
data_analyst12
Frequent Visitor

Reports Not Loading in Production Environment

I used a Web API for a Power BI report, published it, and deployed it in our Production setup. However, among 47 reports, only two face an 'InvalidOrMalformedSemanticQueryDefinition' error.

 

These reports act inconsistently, sometimes loading data and visuals and sometimes not thus giving an error, especially when refreshed or opened. 

 

This inconsistency in loading poses a challenge in ensuring consistent accessibility and functionality for these particular reports.

Reports are working fine in Power BI Desktop and Power BI Service.

 

If somebody can help on this issue, I'd greatly appreciate it.

IHMM Error.png

 

image.png

3 REPLIES 3
v-xiandat-msft
Community Support
Community Support

Hi @data_analyst12 ,

InvalidSemanticQuery is a critical error that MUST occur when the SemanticQuery element is invalid and the error is detected while validating either the XML syntax or XSD Schema.

You can do this by applying changes or refreshing the data, or by running evaluations when you open a report to check if you have unsupported queries.

Best Regards,

Xianda Tang

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

lbendlin
Super User
Super User

Please clarify if this is an issue with Report Server or Power BI Service.

Hi,

 

The issue seems to lie with the Report Server because the same report loads successfully in both Power BI Service and Power BI Desktop. However, while 45 other reports load successfully in the production environment, only two reports are giving me errors.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Kudoed Authors