Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
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
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.
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 |
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |