The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Dear Community,
I am gettting the following error when trying to deploy a composite model from test to production workspace. This is such a generic error message that I am unable to understand whats causing the issue.
The model uses live connections to other semantic models published in a different workspace. Those models are present in the corresponding prod workspace.
Any advanced ways to understand what the above request id is referring to ? or whats failing during the validation ? I have a ticket open with microsoft as well on this.
Appreciate any help or pointers on this.
Solved! Go to Solution.
Realized that this was being caused by a source query like the following that I had in my model, to get data in import mode into the model from another semantic model published on the power bi service. Looks like because of the "powerbi://api.powerbi.com/v1.0/myorg/<workspace>" url which was pointing to the test workspace url of the published source semantic model, it was not able to resolve this to the production url of the source semantic model during deployment resulting in the error.
Let
Source = AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/<workspace>", "<database>", [Query="
EVALUATE
<DAX Query>"])
....
I fixed this using a parameter instead of the hard coded url, but changing the parameter to the prod workspace url of the source semantic model when publishing to test workspace and then deploying from test to production.
Just in case someone else is facing the same issue.
Thanks,
Realized that this was being caused by a source query like the following that I had in my model, to get data in import mode into the model from another semantic model published on the power bi service. Looks like because of the "powerbi://api.powerbi.com/v1.0/myorg/<workspace>" url which was pointing to the test workspace url of the published source semantic model, it was not able to resolve this to the production url of the source semantic model during deployment resulting in the error.
Let
Source = AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/<workspace>", "<database>", [Query="
EVALUATE
<DAX Query>"])
....
I fixed this using a parameter instead of the hard coded url, but changing the parameter to the prod workspace url of the source semantic model when publishing to test workspace and then deploying from test to production.
Just in case someone else is facing the same issue.
Thanks,
User | Count |
---|---|
40 | |
14 | |
14 | |
13 | |
9 |
User | Count |
---|---|
51 | |
43 | |
23 | |
20 | |
18 |