Forum Discussion
Helper IIHow to connect to data source in dataflow and datahubs
Hi donnynz ,
You can connect to the folder through the gateway using the local path. Please install the on-premises data Gateway and follow the steps in the documentation.
After connection.
Downloads | Microsoft Power BI
Power Query Folder connector - Power Query | Microsoft Docs
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi donnynz ,
Please enter WHOAMI in CMD to get your username.
The password is the password you use to log in to the computer.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi donnynz ,
You can connect to the folder through the gateway using the local path. Please install the on-premises data Gateway and follow the steps in the documentation.
After connection.
Downloads | Microsoft Power BI
Power Query Folder connector - Power Query | Microsoft Docs
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Helper IIHello,
Thanks for all the help so far. After several hours of reading and searching and trying I think I am almost there. I managed to set up a gateway and can now put in the folder location of the data being in my 😧 drive and gateway settings options come up as per your screenshot. The issue I have now is when I try and go beyond the connection settings screen I am getting error message "Invalid credentials" The data gateway is the new one I set up that I can select from the dropbox. The Authentication kind is Windows. So I might be doing something wrong in the username and password. Is the username the 'Users' as per the gateway settings and do I need to add /admin after the name? Is the password my Power BI password or the password entered when setting up the gateway? I tried all sorts of combinations and keep getting the invalid message. Thanks
Hi donnynz ,
Please enter WHOAMI in CMD to get your username.
The password is the password you use to log in to the computer.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
- donnynz
AWESOME, got it......
Thanks so much for your help. The only problem now is that this is the last day of my free trial with premium per user so not much chance to play around hahaha.
So good to know how to do it and really appreciate your help.
Thank you
Brendan
Hi donnynz ,
Has this question been solved? If any of the responses were helpful to you, please consider marking them as solutions, which will help more users find similar problems faster. Thanks in advance!
Best Regards,
Gao
Community Support Team