PowerBI API DirectQuery Update Datasource

welifjweklgilrw — Thu, 09 May 2024 11:20:57 GMT

I want to update a Datasource using PowerBI API.

The datasource is from Databricks and it is using DirectQuery.
I was able to get details from the datasource, as shown belown

I've started by following this link to update the datasource:
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-datasources

then I saw that it does not work for Datatabricks, so I should use the Update Parameters endpoint
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-parameters

In the link it is stated that

DirectQuery connections are only supported with enhanced dataset metadata.

I can't seem to find any example of how to update the DirectQuery datasource, can someone help me?
For now I just want to change the "path" of the connection (shown in the image above), but my ultimate goal is to be able to update the connection personal access token.

Re: PowerBI API DirectQuery Update Datasource

blidia1 — Thu, 09 May 2024 18:38:58 GMT

Hello,

I'm struglling with connecting Power BI with Redcap database. I followed the steps (downloading and saving the GitHub code in the right folder). My problem is, the Redcap customer connetor is not popping up in Power Bi GetData. How can I solve this problem?

topic PowerBI API DirectQuery Update Datasource in Developer

PowerBI API DirectQuery Update Datasource

Re: PowerBI API DirectQuery Update Datasource