Forum Discussion
Reference query in Query Editor vs. creating calculated table in DAX?
Hi, I have an import from a large Excelsheet with 1 table, with a lot of columns. As I have learned, I create a starschema from this table, with 1 fact table and 15 dimension tables. Now I have ...
That also is an interesting question. Why not just importing the table without any dimensions?
I think the benefit of extra dimension tables comes in when creating extra measures in DAX.
Hi Arie,
When we import data in import model, we import the table without any dimensions. When you get data in Direct Query or Live connect, you connect the datasource direcly, so the relationship are still there.
Power BI – Live connection vs. Import, comparison and limitations
Best Regards,
Angelia