Forum Discussion

kevinglb's avatar
kevinglb
Frequent Visitor
4 years ago

Issue - Update Data Source Credentials through REST API failed for Web Source

  I was trying to update the data source credentials through REST API (https://api.powerbi.com/v1.0/myorg/gateways/{gatewayId}/datasources/{datasourceId}) for a PBI report whose data source tpye is ...
Gateways
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi kevinglb,

How did you config 'get data' operations from that data source? Can you please share some more detail to help us clarify and troubleshoot your scenario?

How to Get Your Question Answered Quickly  

In addition, you can take a look at the following link to directly get data from the link of the files that are stored in onedrive/sharepoint:

Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

kevinglb's avatar
kevinglb
Frequent Visitor
4 years ago

Hi Xiaoxin,

 

Followings are the steps that I used to get data from SharePoint:

 

1. Get Data -> SharePoint Folder -> enter the root URL of the site 
2. Click "Transform Data" -> Select the files you want to use by filtering the folder path / extension , then combine them

3. Build visualization model based on the data just loaded and save locally

 

And I also tried the way you suggested through the link to get data by enter the URL of the Excel / CSV file and the data is retrieved same as above method.

 

I believed the problem occurs during the credentials validation process rather than the getting data process for the report.

 

If you can let us know whethere there are known issues for the refresh operation or credentials update operation that will be helpful as we can re-arrange our develppment plan. 

 

Thanks,