Forum Discussion
A problem occurred while validating the content for deployment
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,