Loading csv from sharepoint online (Web Connection)

[notrag]

Trying to refresh a csv file from SharePoint Online which sits within the Power Bi workspace. The data source refreshed from Power BI Desktop (Web Source) works but not once published to the Power BI portal.

Data source in Power BI is using organisational credientials with the following URL (masked the tenant name):

https://tenant.sharepoint.com/sites/reporting/Shared%20Documents/50_iq_export.csv

Failed to update data source credentials: Hide details

Activity ID:	b3d5c588-4520-46fb-af4f-18e6667b6ff8
Request ID:	2741f133-3580-ede0-bc33-a1150da92ac7
Status code:	400
Time:	Mon Jul 24 2017 17:01:30 GMT+1000 (AUS Eastern Standard Time)
Version:	13.0.1930.145
Cluster URI:	https://wabi-australia-southeast-redirect.analysis.windows.net

I put in my same credientials which work in Power BI but not in the manage refresh page. Using OAuth2 credientials - any ideas why it fails in the portal?

What else can I try?

[v-qiuyu-msft]

Hi @notrag,

I'm not able to reproduce the issue on my side. Please run the Fiddler with Https encrypt enabled and repeat the steps to edit credential for dataset, collect the trace and share .saz file with us.

Best Regards,
Qiuyun Yu

[notrag]

How do I upload the Saz file ? the forum only allows images and videos in the rich text editor...

[notrag]

try this view access to my one drive:

https://bhcg-my.sharepoint.com/personal/lgarton_bendigohealth_org_au/_layouts/15/guestaccess.aspx?do...