Forum Discussion
MicroStrategy as a datasource
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.
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
- Levajar7 years agoAdvocate II
Yes, it is there
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.
- w3eagle7 years agoRegular Visitor
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