Connect to CSV File source and get dataset update

[fabd]

Hello everybody,

This is my last chance to get help. I'm gonna be crazy with Power BI and refresh dataset.

A quick summary :

I have 3 differents reports based on 3 differents CSV File hosted on O365 Sharepoint

I created a dataset to import my CSV file , like the following video : https://www.youtube.com/watch?v=gJF2e_43FRY

Get data > Web

and input the following link

https://MYCOMPANYNAME.sharepoint.com/sites/MYSERVICE/Documents%20partages/Industrialisation/CLOUD%20...

The dataset is created, and i can create my report. Works great !!

NOW, i would like to publish my report on Power BI app to share the content to my colleague : It works great !

BUT... When i want to refresh the dataset, i have the following error :

Something went wrong
Scheduled refresh has been disabled.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: ae36bd25-01f2-40d2-9c0c-ebcd26b7aa76
Request ID: 7dfd7723-157f-e91a-6352-2d102c20a410
Time: 2019-12-24 09:11:21Z

When i go under Dataset > setting, i have the following error :

Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.

But, i can't input my credential, because it's based on 0365 organisational account and i dont have the choice listed.

Only Authentication method : Basic, Anonymous, Oath2, Windows.... Because, it's based on Web.

So how i could use my CSV file on my 0365 Sharepoint and get data refreshed without any gateway ?

I read many many articles but no one helped me. I also tryed to import data from sharepoint list / folder / ... but with no luck.

Any help would be appreciated. It could be my christmas gift 🙂

I raised several case to Microsoft for this problem, but no one was able to help me.

Thanks, and merry christmas

[mwegener · Accepted solution]

Hi @fabd ,

i use OAuth2.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[fabd]

Hello

thanks for your quick reply

You're right, it works !

What i notice is that, previously, i didn't have AOTH2 (because the sharepoint file url was a little different...)

but, thanks !! and merry christmas

[mwegener]

Merry Christmas! 😁