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.
Hi Team,
We could successfully connect Excel with Mondrian cube created by Pentaho and the data can be visualized thru Excel.
We have used XMLA Provider to connect Mondrian Schema
We tried to connect the same Mondrian schema with Power BI using the same XMLA provider using OLEDB datasource.
The connection has been successfully connected but the schema is not loaded.and we are not able to see any data.
It is giving below error
"Details: "OleDb.DataSource does not currently support multidimensional data sources."
Please help us on this.pease let us if this is possible
Thanks
Vishnu
@Vpuliya,
What specific connector do you use in Excel? Based on the above error message, it doesn't support to connect to the cube using OLEDB connector in Power BI Desktop.
Regards,
Lydia
Hi,
Thank you for the reply
I am using XMLA Provider 1.0.103. Could you please suggest a Connector to connect POWER BI with Mondrian?
Thanks
Vishnu
Hi,
Any help will be appreciated,
Thanks Vishnu
Hi PBI Team,
Any answer for this issue?
Thanks
Vishnu
@Vpuliya,
I am unable to find any methods that can be used to connect to Mondrian in Power BI Desktop. There is an idea about this issue, please vote it up.
Regards,
Lydia
Hi Team,
Any Update on this issue?
Thanks
Vishnu
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |