Forum Discussion
Error pulling data form another semantic model
- 2 months ago
Hi masplin ,
As a next step, could you please perform the following test?
Create a new report page in Model 2.
Add a table visual containing only a simple text column from Model 1.
If possible, temporarily remove or disable any calculation groups that may be impacting the query.
Republish the report and verify whether the issue persists in the Power BI Service.If the same error occurs with a basic text column and no calculation group involvement, this would help confirm that the issue is not related to the refresh date logic itself but rather to the cross-semantic model query execution.
In that case, we would recommend opening a Microsoft Support ticket and providing the Activity ID, Correlation ID, Request ID, and timestamp from the error message. These details can be used to review the backend logs and identify the exact point of failure during query execution.
Please let us know the results of the above test, and we'll be happy to continue investigating.
Thank you.
Hi masplin
Can you try republishing both models, refreshing credentials or gateway mappings, and replacing refresh time logic with a calculated table or measure instead of metadata / DMV based queries. Also test with simple measure from the source model to confirm cross model connection itself is working