OLE DB connection - no error message available

[odumna]

Hello

I have a report with OLE DB connection to powerbi dataset.
example of string connection is next:

provider=MSOLAP.8;initial catalog=sobe_wowvirtualserver-xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx;data source=pbiazure://api.powerbi.com;mdx compatibility=1;safety options=2;mdx missing member mode=Error;identity provider=https://login.microsoftonline.com/common, https://analysis.windows.net/powerbi/api, xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx;update isolation level=2

this report was working and refreshing  fine on desktop and portal.

But now I need to do changes in this report and in desktop I get error "Datasource error OLE DB no error message available, result code -895352820(0xCAA2000C)"
I tried to find solution by myself and I found that if delete from connection string phrase "sobe_wowvirtualserver-" all works fine in desktop, but once I publish report to portal I needed create new gatway.

On portal report is still working and autorefreshing fine.
How can I fix issue and use  initial connection string ? OR How can I change existing getway?

[v-henryk-mstf]

Hi @odumna ,

I can't reproduce this kind of error for the time being, can you provide the test file for me to do further troubleshooting?

Looking forward to your reply.

Best Regards,
Henry

[odumna]

sorry, I can not provide such file.

I have an idea that issue is related to our company internal network settings.. I am cheking this idea with my colleagues

[v-henryk-mstf]

Hi @odumna ,

Thank you for your feedback and I look forward to the results of your discussions.

Best Regards,
Henry

[odumna]

As result issue was resolved by installing older driver x64_15.0.2000.558_SQL_AS_OLEDB
instead of the lastest x64_16.0.519.0_SQL_AS_OLEDB.
Once driver x64_15.0.2000.558_SQL_AS_OLEDB was installed all works fine.

[cher90]

Hi Oduman

Can you provide a link to download this driver please? I can't find it anywhere ( x64_15.0.2000.558).