Forum Discussion

odumna's avatar
odumna
Icon for Helper I rankHelper I
4 years ago

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's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity 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's avatar
      odumna
      Icon for Helper I rankHelper 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's avatar
        v-henryk-mstf
        Icon for Community Support rankCommunity Support

        Hi odumna ,

         

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


        Best Regards,
        Henry