Forum Discussion
OLE DB connection - no error message available
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?
5 Replies
- v-henryk-mstf
Community Support
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
Helper I
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
Community Support
Hi odumna ,
Thank you for your feedback and I look forward to the results of your discussions.
Best Regards,
Henry