Forum Discussion
Import data from SSAS Tabular model
In PB Desktop, I am connecting with "Import" mode to a basic Tabular SSAS model with 3 tables. However when imported into powerBI I have the results： 1. Only a single (Model) table with all fields w...
I know this is an old post, but it sounds like you need to establish relationships between your tables. You will only ever have one Model.bim file by the way; this is not affected by the number of tables you import. If you haven't done so, click on the Diagram icon (highlighted in the screen snip below) and establish those relationships.
Thank you for the input Petri. Relationships are there in AS, and Direct Query works very well. It's just that we were expecting a different behaviour in import mode. When you choose data from eg. 3 tables in AS, instead of getting 3 tables with relationships between them in Power BI, you get one flat table created based on the relationships between the 3 tables.