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