I have installed a On premise gateway ( standard) and i am trying to add data sources with it. We generally get data from our client through our one drive business and thus we want to link One drive business to our on prermise gateway. When i am trying to configure for addition, i am asked for username and password. I enter the username and password of the one drive with which i access that one drive. But it is showing me error of invalid credentials or AccessForbidden.
What username and password am i supposed to enter for the purpose of this confguration?
To use a OneDrive for Business file as a data source in the Power BI service, with Service Refresh enabled for that file, make sure you select OAuth2 as the Authentication method when configuring your refresh settings. Otherwise, you may encounter an error (such as Failed to update data source credentials) when you attempt to connect or to refresh. Selecting OAuth2 as the authentication method remedies that credentials error. By the way, for the data source OneDrive for business, as I know, the gateway is not required. You can configure the data refersh in Power BI service directly.
Community Support Team _ Frank If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Thank you so much for your response. Yes i researched yesterday and came to know that one do not require gateway for one drive business as data source and refresh. I was trying the one drive autorefresh to refresh my dataset and visual. I will also try service refresh. Thank you so much for your suggestion.