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
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

    • sveerisetty's avatar
      sveerisetty
      Frequent Visitor
      6 years ago

      Hi ,

       

      what datasource type you had used while setting datasource for Gateway Cluster.

      your reply shows that u can able to refresh MSTR dataset through on-premises Gateway , can you share few screenshots for same or indetails Note how  you did. it would be more helpfull to some folks who doesn't achieve this.

       

      Also , please provide info on  below points:

      MSTR URL version 

      Power version

      MSTR connector for power bI version

      Gateway version

       

      PS:

      (we are able import MSTR dataset into power Bi desktop ,also able to publish to Power BI service ,we can able to set datasource for cluster Gateway(on-premises) but still showing Not Configured currectly for both cloud and on-premises Data source while configurinf Gateway for Dataset. also for cloud dataset , showing as no Gateway is needed but while trying refresh showing error as ":"The import MicroStrategy matches no exports. Did you miss a module reference?)

       

      expecting your reply at  the earliest

       

       

       

      Thanks in Advance ,

      Sireesha