Forum Discussion

jetboy2k's avatar
jetboy2k
Icon for Helper I rankHelper I
9 years ago
Solved

Replicate an Excel connection to an SSAS cube in Power BI Desktop

I have an Excel report that uses an SSAS cube as its data source, and it is painfully slow. I'd like to move it to PBI desktop to get better performance, but I'm not sure exactly how to replicate the...
Need Help
  • jetboy2k's avatar
    jetboy2k
    9 years ago

    Figured it out. Turns out there was an obvious way to do it. I just inserted a new pivot table in the Excel workbook, and used the Data Connection as the source for the table. Then I was able to look at all of the available tables, fields, etc., and determine that the list of tables and fields was identical to the one that is present in PBI when you use the Live Query connection.

jetboy2k's avatar
jetboy2k
Icon for Helper I rankHelper I
9 years ago

Figured it out. Turns out there was an obvious way to do it. I just inserted a new pivot table in the Excel workbook, and used the Data Connection as the source for the table. Then I was able to look at all of the available tables, fields, etc., and determine that the list of tables and fields was identical to the one that is present in PBI when you use the Live Query connection.