Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
We have set up a CI/CD pipeline in Azure devops where we are able to deploy:
- binary pbix to PBI service
- XMLA (tabular editor) to PBI service
As an extra step of course we want to be able to set the credentials to our Azure Databricks endpoint programmatically via API. But this seems not as trivial. I found the following page Datasets - Update Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Docs , but it seems the limitations cancel out the use case for Databricks.
Also found Gateways - Update Datasource - REST API (Power BI Power BI REST APIs) | Microsoft Docs but we are not working with a gateway since it's a cloud connection.
I also found TOM as a means to manage data sources, but not sure if this could be a valid option.
Any ideas on this?
Solved! Go to Solution.
Hi @PaginatedDino ,
Could you check the PATCH Datasource method? We're using this in our team, and it works even for XMLA datasets.
Hi @PaginatedDino ,
Could you check the PATCH Datasource method? We're using this in our team, and it works even for XMLA datasets.
Hi, @PaginatedDino
The official documentation mentions that 'for other data sources, use the Update Parameters API call'.
Have you tried the content in the link below?
Best Regards,
Community Support Team _ Eason
Thanks for the feedback, sorry for the late reply but I was on holiday.
Okay that might work for the "binary pbix to PBI service" scenario, but I see the following limitation for XMLA based data sets:
So if I understand correctly, because we leverage some PPU workspaces where we deploy via XMLA (DEVOPS + Tabular Editor), we basically cannot go around the usage of Tabular Object Model, right? At least not for the initial deployment. I think XMLA deployments don't overwrite credentials, so that could potentially be, for now, an accepted caveat.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.