Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
Greetings!
I have a issue while connecting to SSAS tabular model from Power BI.
The tabular model is getting connected but I am unable to see the measures in a separate folder but it is listed down under the tables. It will be easy for the business users to have a look at them if they are shown separately at the top. I tried searching but could not resolve this issue.
Attaching the screenshots for your reference. Kindly let me know if you require further clarifications.
Solved! Go to Solution.
Hi Team,
Thanks for your support.
I found out what caused fact tables not to appear with Measures symbol.
This is because, there are other elements apart from measures being present in the SSAS tabular model. Once I hide the elements and then deleted the database in SSMS and then redeployed the model to the server.
If I connect to the model via Power BI, I am able to see the measures segregated at the top appropriately.
Hi Arunsundar,
From your description, it seems that you are connecting live to SSAS tabular model, right?
As it’s a live connection, the table structure is depend on the model design on SSAS side. You can post a thread in SSAS forum to design a desired model firstly.
Regards,
Jimmy Tao
Hi Team,
Thanks for your support.
I found out what caused fact tables not to appear with Measures symbol.
This is because, there are other elements apart from measures being present in the SSAS tabular model. Once I hide the elements and then deleted the database in SSMS and then redeployed the model to the server.
If I connect to the model via Power BI, I am able to see the measures segregated at the top appropriately.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |