The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have built a data model in SSDT as an analysis services tabular project. When I try to deploy to a premium workspace using the XMLA Endpoint, I get the following error on all of my tables :
Failed to save modifications to the server. Error returned: '{"error":{"code":"DMTS_MonikerWithUnboundDataSources","pbi.error":{"code":"DMTS_MonikerWithUnboundDataSources","details":[{"code":"Server","detail":{"type":1,"value":"sqladl\\sql_adl"}},{"code":"Database","detail":{"type":1,"value":"consulting_adl"}},{"code":"ConnectionType","detail":{"type":0,"value":"Sql"}}],"exceptionCulprit":1}}}
When I researched the error, it appears to be related to gateway settings, which there is no place for in SSDT that I can find. Is this something that will be fixed in future versions of SSDT / Power BI service ?
Hi @Anonymous ,
I can't reproduce your issue. If you have Pro account I suggest you try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Best Regards,
Dedmon Dai
Further testing on my part shows that it is able to deploy the metadata, but then I have to set the gateway and refresh on the service. This still seems non-optimal