The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi, my coworker and I are experiencing an issue where not all cube attributes are being brought in to the pbix file when connected to an Analytics Cube via Live Connection. We used the following steps to connect to our dev server and to a specific cube:
Get Data -> Analysis Services -> Connect live
Majority of attributes are visible in the FIELDS pane however, the most crucial one - OrderID is not.
When we tried a different approach and imported the data instead of connecting to it live, the attribute was visible in the Import (Load) Pane and in the FIELDS pane.
Get Data -> Analysis Services -> Import
We would prefer to continue using the Live Connection for our reports over Import. How can we fix this issue?
Is this a known bug? I have noticed only in this version of the application, I am running off of April 2019.
Any suggestions are greatly appreciated!!
Hi @Anonymous ,
Based on my research, there do have some limitations and security for SSAS, you could refer to below link:
https://docs.microsoft.com/en-us/power-bi/desktop-ssas-multidimensional#security
Regards,
Daniel He
Thanks so much for the quick reports. I am pretty sure I remember our sql developer saying that the Order ID that is not showing up is a part of the Parent-child entity with key attributes. This is probably the reason why the measure is now showing up in the Fields pane - tabular model. We will check this on Monday post our findings here.
Thanks,
Izolda
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
122 | |
85 | |
77 | |
55 | |
48 |
User | Count |
---|---|
135 | |
127 | |
78 | |
64 | |
63 |