Forum Discussion

Helper I

5 years ago

Solved

Unable to Enter Credentials for CSV Dataset and Credentials Failing for Gateway Data Sources

I have attempted multiple times to refresh the dataset on one of my reports, which is a csv file stored in OneDrive but downloaded to my desktop, and every time I get this error: Data ...

Need Help

v-robertq-msft
5 years ago
Hi, afmcjarre

According to my test, if I used the “Web” connector to connect with the file in the Onedrive on the Power BI desktop, the gateway connection is default turned off and I can enter the credential to set the scheduled refresh for the dataset.

If I directly connected with the One dirve for business in the Power BI service to create a dataset, there’s no gateway and credential option in the setting page, you can just set the “Onedrive refresh” for the dataset.

Therefore, I think that you are not really connected to the file on one drive if you still need a gateway. You can just follow these two links to check if have done each step right.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-connect-to-files-in-app-workspace-onedrive-for-business

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-robertq-msft

Community Support

5 years ago

Hi, afmcjarre

According to my test, if I used the “Web” connector to connect with the file in the Onedrive on the Power BI desktop, the gateway connection is default turned off and I can enter the credential to set the scheduled refresh for the dataset.

If I directly connected with the One dirve for business in the Power BI service to create a dataset, there’s no gateway and credential option in the setting page, you can just set the “Onedrive refresh” for the dataset.

Therefore, I think that you are not really connected to the file on one drive if you still need a gateway. You can just follow these two links to check if have done each step right.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-connect-to-files-in-app-workspace-onedrive-for-business

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.