Forum Discussion

jennyy's avatar
jennyy
Frequent Visitor
8 years ago
Solved

there was a data source access error. Please contact the gateway administrator

the gateway worked well before but since yeasterday we encountered error when retriving data. i can see the metedata but cannot retrive data. error message is "there was a data source access error. Please contact the gateway administrator"

 

 

Couldn't load the data for this visual
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.
Activity IDc349a39d-6b93-4276-a7df-251164a09310
Request IDf16b3549-53df-d103-3615-bb1dab7d88cd
Correlation ID3bc112ad-4317-6c2b-3fd5-8948970e5870
TimeFri Nov 17 2017 13:44:21 GMT+1100 (AUS Eastern Daylight Time)
Version13.0.3074.197
Cluster URIhttps://wabi-south-east-asia-redirect.analysis.windows.net
 
any advise is appreciaed. Thanks
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    8 years ago

    jennyy

     

    Please launch Regedit, search for HKEY_CLASSES_ROOT\MSOLAP.5

    If there is a MSOLAP.5 key, delete it and restart the GW service to see if it works. (Please backup your registry keys before deleting)

     

    Best Regards,
    Herbert

3 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    jennyy

     

    Please launch Regedit, search for HKEY_CLASSES_ROOT\MSOLAP.5

    If there is a MSOLAP.5 key, delete it and restart the GW service to see if it works. (Please backup your registry keys before deleting)

     

    Best Regards,
    Herbert

    • jennyy's avatar
      jennyy
      Frequent Visitor
      8 years ago

      Hi Herbert,

       

      Your solution works for me. Thank you very much.

       

      Best Regards

       

      Jenny

  • jennyy's avatar
    jennyy
    Frequent Visitor
    8 years ago

    Have just found that a windows patching was implemented yesterday. does this related?

     

    i have tried

    regsvr32 -u "C:\Program Files\Microsoft Analysis Services\AS OLEDB\130\msolap130.dll"

     

    regsvr32  "C:\Program Files\Microsoft Analysis Services\AS OLEDB\130\msolap130.dll"

     

    to unregister the dll and registered again with no luck

     

    Thanks