Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.