cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vpuliya Frequent Visitor
Frequent 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
Vpuliya Frequent Visitor
Frequent Visitor

Re: Issue in connectin PBI desktop with Mondrian cube

Hi Team,

 

Any Update on this issue?

 

Thanks

Vishnu

Moderator v-yuezhe-msft
Moderator

Re: Issue in connectin PBI desktop with Mondrian cube

@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.
Vpuliya Frequent Visitor
Frequent Visitor

Re: Issue in connectin PBI desktop with Mondrian cube

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

Vpuliya Frequent Visitor
Frequent Visitor

Re: Issue in connectin PBI desktop with Mondrian cube

Hi,

 

Any help will be appreciated,

 

 

Thanks Vishnu

Vpuliya Frequent Visitor
Frequent Visitor

Re: Issue in connectin PBI desktop with Mondrian cube

Hi PBI Team,

 

Any answer for this issue?

 

 

Thanks

Vishnu

Moderator v-yuezhe-msft
Moderator

Re: Issue in connectin PBI desktop with Mondrian cube

@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.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 145 members 1,984 guests
Please welcome our newest community members: