Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
Best regards,
Yuliana Gu
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |