Incorrect Connection string for Oracle after saving report from Power BI Desktop to Report Server

ibm0522 — Fri, 12 Jan 2024 08:07:15 GMT

Hello!

Correct connection string for oracle source should be "Data Source = <host>", but after saving report from Power BI Desktop to Report Server it looks like <host> (without "Data Source =...").

Why it happens and how i can fix it?

I can't connect to oracle server with incorrect connection string

Re: Incorrect Connection string for Oracle after saving report from Power BI Desktop to Report Server

v-weiyan1-msft — Wed, 17 Jan 2024 02:53:32 GMT

Hi ibm0522 ,

Based on your description, please ensure that the Oracle client is properly installed and configured on the machine where the Power BI Report Server is running. Sometimes, connection issues can arise if the Oracle client is not set up correctly or is incompatible with the version of Power BI.

After uploading the report to the Power BI Report Server, try editing the connection string manually to include the necessary "Data Source=" part. This can typically be done in the data source settings within the Power BI Report Server interface.

I also found a similar post, please refer to it and see if it helps you.

Solved: Re: Can't connect to Oracle Database from Microsof... - Microsoft Fabric Community

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Incorrect Connection string for Oracle after saving report from Power BI Desktop to Report Server in Report Server

Incorrect Connection string for Oracle after saving report from Power BI Desktop to Report Server

Re: Incorrect Connection string for Oracle after saving report from Power BI Desktop to Report Server