Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
We are using the pro trial version of power bi. Our data comes from sql server with queries and excel. I installed the gateway's personnel and entreprise mode on my computer. I am connecting to the server remotely. I'm getting data with ip. Excel files are on my computer. When i use gateway entreprise, Power BI service does not update and gives an error. I guess it doesn't accept my username and password. Don't we enter our username and password that we used when setting up the gateway here? Why doesn't he accept?
However, when using the gateway in personnel mode, it updates the excel files on my computer. but it does not update the database on the server remote.
I would be glad if you help. Thank you
Solved! Go to Solution.
Hi @ict ,
This issue is caused by the credentials of your data source.
It seems that you are using the username and password of your gateway?
When setting the datasource: select an Authentication Method to use when connecting to the data source. For SQL Server, choose Windows or Basic (SQL Authentication). Enter the credentials for your data source.
Note: If the selected authentication method is OAuth:
For more details, please refer to:
Add or remove a gateway data source - Power BI | Microsoft Learn
Manage your data source - SQL - Power BI | Microsoft Learn
Troubleshoot gateways - Power BI | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ict ,
This issue is caused by the credentials of your data source.
It seems that you are using the username and password of your gateway?
When setting the datasource: select an Authentication Method to use when connecting to the data source. For SQL Server, choose Windows or Basic (SQL Authentication). Enter the credentials for your data source.
Note: If the selected authentication method is OAuth:
For more details, please refer to:
Add or remove a gateway data source - Power BI | Microsoft Learn
Manage your data source - SQL - Power BI | Microsoft Learn
Troubleshoot gateways - Power BI | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |