I have a cube made in SASS as a source for Power Bi. When I try to get data from the cube in Power BI, it blocks the query editor and it doesnt allow me to add more data sources. Is there a way to solve this? Should I load the data that I need from the cube first in SQL server through SSIS and then get in in Power BI? or is there a direct way to do this?
Thanks in advance!