Forum Discussion
Error pulling data form another semantic model
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 ,
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Thank you.
So i really cant understand what is going on here
I have 2 tables coming from Model 1; Client Bookings and the Refresh date. Both tables are connected by Direct query to Model 2
If I create a measure e.g. MAX using this refresh date column in model 2 it causes this error
If I add a column in Model 1 on the Client Booking table that just contains this date, then create a measure in model 2 e.g. MAX of this column it causes the error
If I try to add any column of data from the Model 1 [Client Booking] table to a visual in model 2 it errors
However if I add a column to my model 2 [Client] table = MAX(Refresh date) then add a measure to get the MAX of that column it works fine
So it seems you cannot use any data coming from the connected model directly (either as a row or column of a visual or in a measure). First you have to read the data into a table of the current model using a column calculation then you can use it. This seems really odd behaviour.
Am I doing something wrong with having direct query conenctions ottthe other model or something in the permissioning
So it seems that you cant