cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Seattle-1 Frequent Visitor
Frequent Visitor

How to connect a cube saved in .odc file or excel file (pivot table) via Power BI

Currently, I do not have the source information connecting to SSAS cube directly via Power BI.

 

I only have one file stored in .odc file, and the other stored in excel (pivot table). Does anyone know how to connect to it? What type of source do they belong to in Power BI Desktop? 

2 REPLIES 2
Community Support Team
Community Support Team

Re: How to connect a cube saved in .odc file or excel file (pivot table) via Power BI

Hi @Seattle-1,

 

You could directly  Import Excel workbooks into Power BI Desktop to load the pivot models.

 

However, the .odc file is not a supported data source in Power BI desktop. Here are some similar ideas, you can upvote it or add your own comments.

ODC equivalent for Power BI Desktop

ODC

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Seattle-1 Frequent Visitor
Frequent Visitor

Re: How to connect a cube saved in .odc file or excel file (pivot table) via Power BI

Hi Yuliana,

 

Thank you for your input. I just received the access to connecting to the cube.

 

I will give it a try for the pivot model.

 

Ellen