Forum Discussion

spiderrob's avatar
spiderrob
Advocate III
6 years ago

MicroStrategy data source and service refresh

Hi, I have MicroStrategy as a data source using the custom connector. Everything works fine locally and refreshes on demand as expected. However, I'm unable to refresh in the service. My gateway work...
Need Help
venal's avatar
venal
Memorable Member
6 years ago

spiderrob Anonymous 

Please refer the link.

As suggested in the above link, please click the "add to gateway" in dataset settings and add the data source to the gateway.

Note:- Please use the latest version of the on-premises data gateway.

If you have any queries, please let us know.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

  • spiderrob's avatar
    spiderrob
    Advocate III
    6 years ago

    venal Anonymous 

    I've still not got this working. I think the fundamental issue is that the PowerBI service thinks that the data source is in the cloud. It's not - It's on-prem. The PowerBI Microstrategy connector makes use of the MicroStrategy library api. This is accessed through a local web address. Eg:

    Data Source settings in the pbix shows as:

    {"apiServer":"https:\/\/xxxxxxxxxx\/api","authMode":"LDAP"} where xxxxxx is my local URL

    As a consequence, the service seems to think it's a cloud connection. In the service settings window for the gateway connection, 'Data Sources included in this dataset' shows as blank?

    Any ideas?

    Thanks!

    • venal's avatar
      venal
      Memorable Member
      6 years ago

      spiderrob 

      I would like to suggest you to submit a support ticket to investigate on this issue.

      Please share the support ticket number here for reference.

      If you have any concerns, please let us know.

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more
      If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi spiderrob ,

        I was able to setup the Enterprise Gateway connector(Standard and Personal) to on Prem Microstrategy Dataset,using Microstrategy 2020 Custom  Connector for PowerBI.

         

        Thanks,

        Hima