Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Vpuliya
Regular Visitor

Issue in connectin PBI desktop with Mondrian cube

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

6 REPLIES 6
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Vpuliya
Regular Visitor

Hi Team,

 

Any Update on this issue?

 

Thanks

Vishnu

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors