Forum Discussion
Backend Error when publishing a composite model through the pipeline
I ended up creating parameters in the pbix for each datasource for each environment. This allowed me to set the parameter in the Settings section after I promoted via pipeline but BEFORE before I applied the new parameters in the pipeline. This allowed me to set the parameters, apply them and then refresh.
Hi andy808,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
anilgavhane, grazitti_sapna & lbendlin ,Thanks for your prompt response
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support
I still need support. I am on GCC, Premium Capacity. I do not see anywhere in the settings or in the pipeline that allows me to switch the datasources manually (from Dev to Test). In the Gateway Connection settings - "the datasource connected to this model"is greyed out. I do not want to publish direct to Test/Prod - I want to promote through the pipeline. This is only happening with a model that has import and Direct Query tables. I do not have any refresh turned on and I have the credentials/gateway mapping all set. I get this error message:
- Backend ErrorFailed to save modifications to the server. Error returned: '{"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"We are unable to retrieve the credentials for the data source '<ccon>{\"address\":{\"kind\":\"SQL\"}}</ccon>'. This error might occur when a request attempts to add a new data source to a semantic model and perform a data refresh in a single transaction, which is not supported. In such cases, add new data sources in a separate transaction first and then separately perform the data refresh."}}],"exceptionCulprit":0}}} '.