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

[Seattle-1]

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? 

[v-yulgu-msft]

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

[Seattle-1]

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