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.
Hi,
we cannot use our multidimensional cube in PBI Desktop because we cannot import it as a cube.
When importing the SSAS instance, normally, opening one of the database menu we can see only the cube object.
Now, after opening the db we find a folder, in which all measure groups and dimensions are listed and need to be selected all.
What could be the problem?
Thanks
Solved! Go to Solution.
It seems you are using import mode. When connect live, it should be like this:
Regards,
You aren't supposed to import a cube, you are supposed to live query it through a live connection.
Importing it flattens the cube into a huge table, and would probably crash the server.
You aren't supposed to import a cube, you are supposed to live query it through a live connection.
Importing it flattens the cube into a huge table, and would probably crash the server.
Can you just use a live (DirectQuery) connection?
Yes, we used a Live Connection, but we see as shown as below
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |