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.
Hello,
When working with a Tabular AAS live connection in PBI, I've noticed that the organization of the fields is automated based on the presence of attributes in a fact/dim (if there are no attributes and only measures, PBI will designate the table as a Fact).
However, if a Fact table has a single attribute present, it will automatically label it as a Dimension, and I cannot override this command. There should be a way to toggle whether or not a table is a Dimension or a Fact, or have a similar folder structure like Excel, where measures are at the top of the field, and attributes are in a separate folder.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.