We are using deployment pipelines for promoting content developed in our [Test] workspaces. Our semantic models are kept in as separate workspace from our reports for workflow purposes so two separate deployment pipelines, SM_Workspace [Test] and Workspace [Test]. We use a single source Lakehouse leveraging shortcuts in another workspace called Lakehouse EDW HUB.
We have a semantic model and report that were recently deployed from our [Test] workspaces to [QA] workspace that use the same Lakehouse as the source for the semantic models. After promotion, most of the repor works without issue but our developers noticed some visuals were erroring out. They confirmed no difference in visual filters or configuration between [Test] and [QA].
As an example for one of the errors, the bar graph visuals is erroring out and providing an error of "The resultset of a query to external data source has exceeded the maximum allowed size of '1000000'". I confirmed the issue does not occur in the [Test] version of the report, and collected the DAX statement from the visual in TEST, and collected a similiar DAX statement (had to filter the date range down from 12 months to 2 months) from QA and compared the statements. The statement in QA has some minor differences in order of filter statements, and an odd exclusion of the field parameter statement, but otherwise looks the same. I then connected via DAX studio and ran the DAX statement that was working in TEST against the QA semantic model and received the error message see in the report. I reconnected to TEST, and validated the exact same DAX query works without issue against TEST and it did.
When I run the server timings and look at the logs, for some reason the query is being handled differently for the QA model than the TEST model. Was hoping someone may have encountered an issue like this, or have some ideas on other items to check as I'm a little stumped.
Please let me know what additional details I can provide, thank you in advance for any help.
