Forum Discussion

PRAVISH_SARAVAN's avatar
PRAVISH_SARAVAN
Frequent Visitor
2 years ago

Reports don't work post deploying from DEV to UAT using Deployment Pipeline

Visuals throw below error post deploying them to UAT but everything works fine in DEV.   Expression.Error: We couldn't fold the expression to the data source. Please try a simpler expression.. ;We ...
Need Help
Brunner_BI's avatar
Brunner_BI
Icon for Impactful Individual rankImpactful Individual
2 years ago

So if you download the report in UAT you can confirm it is connected to the dataset you expect it to be connected to?

 

Generally this seems to be hitting the limitations of DirectQuery by what you are doing inside the report, maybe month ending is a calculated column or so.

Make sure to read through the limitations and then analyze what could be the cause. It could be your data model or a calculated column or something with Auto Date/Time?

 

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#other-directquery-limitations

PRAVISH_SARAVAN's avatar
PRAVISH_SARAVAN
Frequent Visitor
2 years ago

sure, will go through the shared link on DirectQuery Limitations.
Also, the MonthEnding is not a calculcated column, it's pulled form the created Dataflow.

The strange reason was, until last friday(3/11/2023), the reports and deployments were wokring fine, starting this monday(6/11/2023) the reports started to not load the visual in TEST workspace. 

Was there any new release happened over last weekend? Could that be possible route cause, if so any release udpate we can expect this weekend?