topic Re: Reports Not Loading in Production Environment in Report Server

Reports Not Loading in Production Environment

data_analyst12 — Fri, 05 Jan 2024 11:28:47 GMT

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.

Re: Reports Not Loading in Production Environment

lbendlin — Sun, 07 Jan 2024 03:08:14 GMT

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

Re: Reports Not Loading in Production Environment

data_analyst12 — Sun, 07 Jan 2024 11:34:59 GMT

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.

Re: Reports Not Loading in Production Environment

Anonymous — Wed, 24 Jan 2024 07:47:36 GMT

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.