Hi, I need to show Measure tables on the top and dimensions in the bottom when I connect the Power BI to the tabular model. How can I do that?
Hi, I need to show Measure tables on the top and dimensions in the bottom when I connect the Power BI to the tabular model. How can I do that?
Hi,
Power BI arrange the tables alphabetically.So if you want to make measure tables on top, you could modity your model tables with prefix so they could show on top. For example 0 for fact tables, 1 for dimension tables.
Something like 0_measure-table-names, and 1_dimension-table-names, could make this sorting happen in Power BI.
Regards.
Lukas
Actually, the tables where only measures are visible are displayed first. The alphabetical sorting then happens independently within the 'measures-only' group and within all the other tables.
@AlexeiStoyanovsky: They are not showing up that way.
@LukasYu-msft : I already got this way. But, trying to avoid the prefix.
@SrikanthKoritala-4778 they are for me (there's a hidden column in table z). A single visible column moves the table to the lower bucket (table b), or perhaps it could be your tabular server's version/model's compatibility level.

Hi ,
Have you tested with empty table which has only measures in it? Any success on this issue?
Hi, my fact table has all dimension keys inivisible. Not all columns are calculated measures. Some of them are just numbers.
Measure table is not invisible dimension table, it is create only for storing meausres, maybe you could see this and try if it works: Measure Tables in Power BI
5 people are following this question.
File for a cloned Vertipaq data object conflicts with a master data object file
dimension security on a combination of dimensions
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
Getting error message as "Unable to find any Microsoft OLE DB providers on the machine."
How to schedule SQL profiler to auto start/stop to capture SSAS synchronization?