how can i make a LIVE CONNECTION From Power BI Desktop To 2008 R2 SSAS Cube

[MEDCHERIF]

Hello,

i'm  trying to  make a live connection  between  Power BI  Desktop and an SSAS 2008 R2 Cube, if there is a way  to  do  this please help.

Thanks

[Greg_Deckler]

I *believe* only 2012 and later are supported:

https://powerbi.microsoft.com/en-us/documentation/powerbi-sql-server-analysis-services-tabular-data/

[MEDCHERIF]

Yes smoupre, i know but i'm asking for indirect way to make it possible.
My entire problem is that when i try to import data (the only way to uses ssas 2008 cube). The calculated measures i can't find them an that's logical. So i wan't to find a way to solve this

[v-huizhn-msft]

Hi @MEDCHERIF,

When you upload the data using import mode, the calculated measure can't be imported? I test import data from SSAS 2012/2016, it works fine.

Mayebe you can try to output your data from SSAS Cube to excel, then upload data from excel to Power BI. Or you'd better update your SSAS to latest version, there are better features for new version.

Best Regards,
Angelia 

[MEDCHERIF]

All  about the version of SQL. thank you any way 🙂

Regards

[Greg_Deckler · Accepted solution]

Sorry, I can't think of a work-a-round for this off the top of my head, you're going to have to upgrade your cube or build a new cube on a new version of SQL Server or something like Azure Analysis Services.