MicroStrategy as a datasource

[chlisa01]

Dear all,

I saw a video which show how to use MicroStrategy as a datasource for Microsoft Power BI. When I am trying to find it in the data sources I can't find it.

Could you please help me ?

[micahwilliams12]

When you import data from a database, you must establish communication between MicroStrategy and your data source. To establish communication, you create a database connection. A database connection specifies the connection information used to access the database that is your data source. The database connection enables MicroStrategy Desktop to retrieve data from your data source.

Link: http://www2.microstrategy.com/producthelp/10.8/AnalyticsDesktop/WebUser/WebHelp/Lang_1033/Content/Co...

[ranjan2000]

Hi All

Is there a connector available in Power BI Web for MicroStrategy? I know with MSTR 9.x and SouthportAg (older version of MSTR) we can connect via desktop.

Thanks

RP

[Levajar]

Yes, it is there

https://community.microstrategy.com/s/article/MicroStrategy-Dataset-Connector-for-Power-BI?language=... 

It is pretty straight forward to use it. It can be done only on Power BI Desktop. 

Security has to be within Power BI anyways. MSTR Cube will act as Warehouse connector only & data will then be in memory to Power BI. 

Automatic refresh is something to be tested if feasible or not via cloud connectors online. 

[w3eagle]

At least the (personal) gateway does not recognize this connector; scheduled refresh on powerbi.com did not work. Not sure if there's other ways schedule a refresh -

Message:	The import MicroStrategy matches no exports. Did you miss a module reference? Table: ICube - Sales Metrics
Cluster URI:	WABI-US-EAST2-redirect.analysis.windows.net
Activity ID:	68997d84-xxxx
Request ID:	ffa42e71-xxxx

[v-haibl-msft]

@chlisa01

There is no out-of-the-box data connector for MicroStrategy in Power BI Desktop now. It seems that this is a custom connector which developped by southpost.

Reference:

https://powerbi.microsoft.com/en-us/blog/data-connectors-developer-preview/

https://powerbi.microsoft.com/en-us/blog/power-bi-user-group-custom-connector/

Best Regards,
Herbert