Power BI REST API - Updating Dataset datasource for Azure Data Lake

[Anonymous]

Hello,

I'm trying to update the dataset datasource for an Azure Data Lake. I would like to modify the path "https://xxx.azuredatalakestore.net/temp/test" by environment.

I tried to use the API: POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.UpdateDatasources

with the following body:

{

  "updateDetails":[

    {

        "connectionDetails":{

            "path":"https://xxx.azuredatalakestore.net/temp/NEW_TEST",

            "kind":"DataLake"

        },

        "datasourceSelector": {

            "datasourceType":"AnalysisServices",

            "connectionDetails":{

                "path":"https://xxx.azuredatalakestore.net/temp/TEST",

                "kind":"DataLake"

            }

        }

    }

]}

But I got the following error:
{
    "error": {
        "code": "InvalidRequest",
       "message": "Parameter UpdateDetails is missing or invalid"
    }
}

After I tried to use the following API:

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.UpdateParameters

with the following body:

{
    "updateDetails": [
    {
        "name": "path",
        "newValue": "https://xxx.azuredatalakestore.net/temp/NEW_TEST"
    }
]}

But I got the following error:

{
    "error": {
        "code": "ItemNotFound",
        "message": "Dataset parameters at positions 1 cannot be found in f21c26c3-e894-4d61-9414-5c9458d2706c",
        "target": "f21c26c3-e894-4d61-9414-5c9458d2706c"
   }
}

So is there a way to update a Dataset datasource for Azure Data Lake ? I'm wrong ?

Thanks

Regards

[jlazlabs]

I really hope you were able to resolve your issue because the Microsoft support people who get PAID to assist these issues is absolutely useless.  What are these people getting paid???  I sure hope its minimal because if all they do is go Google the issue and then copy and past a (circular) reference to a Microsoft document I will take 50 of their jobs, you can pay me for 25 of them and I will still provide equal or better responses.  

They are ZERO help and then harp you to close the ticket so the lifetime of the question is low to meet SLA.  This is just wasted time and money.  Youre better off posting these questions to other stacks than come here and wasted time doing exactly what you could do yourself.  

[Anonymous]

Hi, has anyone handle this issue? I have exact one. The documentation as always treat about obvious things but miss the details.

PS. Fully agree with you about MS support, current support from MS is tottally useless. Recently we stopped even raise a tickets to MS as it is waste of time. As long as you get someone who barely can speak english then you get into loop with them of useless solutions. As a company we are thinking on changing software provider. 

[v-kelly-msft]

Hi @Anonymous ,

Check whether below thread help:

https://community.powerbi.com/t5/Service/Get-a-list-of-Power-BI-refresh-times-across-all-apps-in-tenancy/m-p/865244

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[v-kelly-msft]

Hi  @Anonymous ,

Check the details below about updating datasources via Rest Api:

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasources

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi,

I thank you for your help but your link didn't help me. I need a way to update the connectionDetails by REST API.

Regards

[v-kelly-msft]

Hi @Anonymous ,

Is your issue solved？Does my suggestion work ?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!