Forum Discussion
Invalid connection credentials
As I mentioned. If the source for your data is an excel file , csv file or something stored on disk, the service account that the Gateway is running under should have access to that share. Usually, the best way to do this when using gateways is to have a central share where you store files that Power BI uses to refresh its datasets.
It depends where you are sourcing your data into power bi from. I have seen this work fine in PBI desktop and not on the service when the service account running the gateway does not have access to the folder the file that sources your data is. This usually happens with Excel or csv based data sources.
Hope this helps.
If this helps, please mark as resolved to help other users get the answer.
thanks.
luisrh Thanks for your reply. So, what can I do to resolve this ??
As I mentioned. If the source for your data is an excel file , csv file or something stored on disk, the service account that the Gateway is running under should have access to that share. Usually, the best way to do this when using gateways is to have a central share where you store files that Power BI uses to refresh its datasets.