Forum Discussion
Power BI is saying my data source is missing credentials.
Hi JRTV
Did you connect via the Excel connector, the Web connector or some other connector?
If the file is in the cloud (OneDrive, SharePoint etc) you can connect without a GateWay.
Whereas if the file is in a local drive you will need a Gateway which makes it worse.
Hi JRTV ,
Please refer to the documentation for steps:
SharePoint and OneDrive for Business files import
And make sure you select OAuth2 as the Authentication method when configuring your refresh settings.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Which connector did you use?
If it was Excel your connection will look like this in the Query Editor under Source:
Meaning it is refreshing through your computer and not through the Web.
It is from a onedrive.
Hi JRTV ,
Please refer to the documentation for steps:
SharePoint and OneDrive for Business files import
And make sure you select OAuth2 as the Authentication method when configuring your refresh settings.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum