I'm trying to connect cube data to power bi.
when I choose "import" it works but when I choose "live connection" it doesn't work.
what could be the reason for it? I do it on my power desktop
Solved! Go to Solution.
As you mentioned, live connection to SSAS cube doesn't work in desktop, is there any error throwing out? Please try to run the desktop latest version 2.45.4704.442.
You can also check limitation to use a live connection against tabular or multidimensional instances: Limitations of Analysis Services live connections. To check if target SSAS meet the requirement, you can contact your SQL Server administrator.
@v-qiuyu-msft I have to most updated desktop version, according to the video tutorial (Guy in the Cube) it is possible to use a
live connect so I guess the only problem is the SQL server (need to check with my administrator).
this is the error message that I get when I'm trying to use live connect: