Forum Discussion
Helper IUnable to Enter Credentials for CSV Dataset and Credentials Failing for Gateway Data Sources
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
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.
Solution SpecialistLooking at the source path, it is still pointed to One Drive location and not your local machine though you have stored it locally. So in this case, you wouldn't require a gateway.
The error message clearly shows that you are entering the wrong credentials. But that shouldn't be the issue as you are using the Microsoft username and password (from what I understood).
There is this note on the official documentation which might help you. Did you try it?
Reference: Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs
If you would like to use it with a gateway, use Text/CSV connector instead of Web and change the path to a local file's path instead of OneDrive's file path.
Did I answer your questions? Give a thumbs up and accept this post as solution!
afmcjarreThank you for this information. What I tried first were the sources of file and of folder, either locally or in OneDrive and I got the exact same credential error with the gateway. I was using the onedrive folder stored locally on my computer initially as well. Using the onedrive link as pictured in the error was the last thing I had attempted. All still getting the same credentialing error.
Without using the gateway, why am I unable to just put in my credentials as shown in the picture below? I also can't do anything with the gateway or data refresh, but again just getting in my credentials for the CSVs is not allowed. This is what I originally wanted to do and avoid the gateway entirely for now, but I am unable to do so on any of my datasets even though I am an Admin in the workspace (if that makes a difference).
And you are correct, I am entering the same username and password that I use with my Microsoft account....and have double checked it 100 times!
Thank you for your help.