Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi I'm trying to connect my gateway to a sharepoint list and I'm getting the following error
Solved! Go to Solution.
The solution I found was to use the Personal Gateway. Then add the SQL on premise to it, and the Sharepoint list just needed my credentials. It worked perfefctly an keeps running with scheduled refreses.
Hello, I have the same problem with connection on PBI Cloud. I´m trying to connect and i get an error:
Hi @Anonymous ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
The solution I found was to use the Personal Gateway. Then add the SQL on premise to it, and the Sharepoint list just needed my credentials. It worked perfefctly an keeps running with scheduled refreses.
Hi @Anonymous ,
The 400 ERROR means a bad http request. Please updata on-premise gateway to the lastest version. If you already have updated the gateway to the latest version, then you can refer to steps below for troubleshooting.
1. Check if the server is using a proxy and the proxy. Some proxies restrict traffic to only ports 80 and 443. By default, communication to Azure Service Bus will occur on ports other than 443.
2. You can force the gateway to communicate with Azure Service Bus using HTTPS instead of direct TCP. You will need to modify the Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config file. Change the value from AutoDetect
to Https
. This file is located, by default, at C:\Program Files\On-premises data gateway.
3. Restart the gateway and check if the issue persists.
To stop the service, run this command:
''' net stop PBIEgwService '''
To start the service, run this command:
''' net start PBIEgwService '''
4. You may export the data gateway log by selecting Diagnostics and then selecting the Export logs link near the bottom of the page. Reference: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#tools-for-troubleshooting.
similar error question refer:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi, I found this helpful. It seems to be that it's not neccessary a gateway when we work with sharepoint lists.
Solved: Sharepoint Gateway Connection Failure - Microsoft Power BI Community
No, it isn't necessary, but it won't cause an error. You can allow the gateway to manage cloud resources in the gateway config on line. That can be useful if you are mashing up an Online SharePoint list with an on-prem datasource. See Merge or append on-premises and cloud data sources - Power BI | Microsoft Docs for info about doing this. It is a simple checkbox, but can be very handy.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @Anonymous
It appears that you cannot connect to the dataset, if you can ensure that you have correctly configured the data source settings?
I have two datasets. The first from SQL server and the second from a Sharepoint List. I successfully connected both of them to Power BI and I was trying to make an schedule refresh with the gateway.
Hi @Anonymous
Yeah that should be working if it successfully is connected in the gateway data sources?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.