Forum Discussion

Helper I

7 years ago

Excel from onedrive as a source - WEB/URL credentials - OAuth2 - data source vs. gateway clusters

Hi. I am not sure if this is mistake or not... but I would like share this information, maybe somebody will explain it to me :-). I added excel as url link from my one-drive to Powerbi. Now I wa...

Need Help

v-piga-msft

Resident Rockstar

7 years ago

Hi ludovit8,

Why do you want to add your data source from onedrive to data gateway in Power BI Service? As I know, the online data source don't need to configure the date gateway.

For your scenario, do you mean that you get data with web conncetor by OAuth2 in Power BI Desktop, but when you add the data source in gateway, there is no OAuth2 option for you to choose?

By my tests, I can only see the option list below in Power BI Desktop with web conncetor.

If it is convenient, could you share your data credential in Power BI Desktop. You could find it by clicking Edit Queries>> Data source settings>>Edit Permissions.

In addition, do you edit Credentials under Dataset in Power BI Service?