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.
Community SupportHi, afmcjarre
According to your sample picture, it seems that your gateway is turned on but you haven’t configured the corresponding data source under the gateway, so the “Date source credentials” and “Scheduled refresh” are both greyed out in your dataset setting.
Another important thing is to make sure what’s the storage location of your data source, if you used the data source in the Onedrive for business, you don’t need to configure a gateway for the data source, you just need to enter the credential you used to login to the Onedrive. If your data source is on-premise, then you have to configured the corresponding data source under the gateway like the pircture above.
More info about setting a refresh schedule
Thank you very much!
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.
afmcjarreHi,
The first problem I want to solve is figuring out why I can't put my credentials in for a dataset (a CSV file) that lives on my computer, without using the gateway.
As you can see, I am not even given the option of entering my credentials to allow me to manually refresh the dataset.
The only reason I started trying to use a gateway was because of this, but it seemed to create more problems.
_sfrostSolution Specialist
All local files/on-premises sources require gateway to refresh the data. That's how the refresh happens, through the gateway, which acts as bridge between your source local file and the Power BI Service.
Install a personal gateway and set up the refresh.
Or if you have installed an enterprise gateway, make sure you add the data source to the gateway first and bind that source with your dataset.
Then you will be able to set up the refresh.
Did I answer your questions? Give a thumbs up and accept this post as solution!