Forum Discussion

IAmStandard's avatar
IAmStandard
Frequent Visitor
2 years ago

Set Datasource Credential with API - Fabric SQL Endpoint issue

Hi,   I'm working on a project where I need to update the credentials of some Dataset programatically. I got it working for SharePoint, Dataverse and Dataflow. Now i'm trying to do the same for Fa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  IAmStandard ,

 

According to your requirement description, it seems that you need to update credentials for SharePoint and other Power BI dataset datasources, according to my view of the permissions requirements for this corresponding rest API in the official documentation, it seems that it needs at least the Power BI side of the permission scope: Dataset.ReadWrite. .All, would it be convenient for you to add this to the corresponding application before trying it out?

Datasets - Update Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • IAmStandard's avatar
    IAmStandard
    Frequent Visitor
    2 years ago

    Hi Anonymous ,

     

    Thanks for your reply. The API I use if actually this one. And it works very well for SharePoint and Dataflows, my only issue is with the SQL Endpoint of a Fabric Lakehouse.

    I think I don't have the correct documentation to get the correct AccessToken for this specific datasource. Do you have any info on that ?