topic Re: Suggestion for data integration from different data source in Developer

Thank You

Arbind — Thu, 01 Feb 2024 04:07:22 GMT

Re: Suggestion for data integration from different data source

Anonymous — Thu, 01 Feb 2024 02:36:46 GMT

AFAIK, current some of tyep of datsorue existed correposnd data conectore, you can use these to gettting data on power bi side.

SAP Interface: current power bi existed SAP connectors, you can try to use SAP hana or SAP Business Warehouse connector to getting data.

For other types of data sources which not existed official data connector, you can check the data driver they supported(e.g. ODBC, older...) Then you can use these types of connectors to get data at power Bi side.

If they also not provide the data provider, you can take a look at the API or export features to export to general data formats.(e.g. csv, txt, json, excel) Then you can use power bi to getting data from rest api or exported files.

Regards,

Xiaoxin Sheng

Re: Suggestion for data integration from different data source

Arbind — Thu, 08 Feb 2024 05:47:45 GMT

Dear Xiaoxin Sheng

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.

Please do help me to resolve this issue