Forum Discussion
Thank You
Hi Arbind ,
This URL will give you all of the out-of-the-box connectors available to you in Power BI. If you don't see one that is exactly what you need, you can always use the more "universal" ones like API, Odata, Web or something like that:
List of all Power Query connectors - Power Query | Microsoft Learn
Dear Collinq
We are encountering difficulties while attempting to establish a connection with the PSAOP Data server. Despite numerous attempts, we have been unable to execute the process successfully or comprehend the resulting output.
The overall procedure involves retrieving data stored in SQL server and importing it into Power BI using the SQL Server Connector. However, we are encountering challenges when configuring the PSAOP Data Server and attempting to fetch data from the SQL Server by creating the URL (Endpoint) as per the documented procedure. Although we have successfully generated an access token using Postman, we are unable to make the URL work for Power Bi.
The errors we are encountering include:
- Cannot establish trust relationship for the SSL/TLS secure channel.
- ODATA Request Fail
- The remote server returned an error (503) Server Unable.
Do help in solving this issue.
Hey Arbind ,
These sound like network issues to me, although I am not a network expert. If the server can't be found or the TLS doesnt work there are often things like invalid certifactes, trust store issue or DNS problems. I wouldsuggest a fiddler trace with your network people to find where the error pops up.