Getting data from data lake.

[Anonymous]

Hello all,

Could you please help me with the query below?

I'm getting data from Data Lake to Power BI Desktop, where all the joins and relationships were created on the backend, which means I'm importing one big table with all dimensions and facts together (without having a DateTable, only dates from the dimensions).  That said, I need to know if I should, by best practices, split the big table into dimensions and facts and have a Dim_Date table? 

Many thanks in advance,

Renata

[Pragati11 · Accepted solution]

HI @Anonymous ,

• Working with a single big table can be challenging in the scenarios where you have so many columns and millions of rows.
• Splitting one big table into DIMENSIONS & FACT tables, can help with performance on the report, specially when you are slicing you data at different granularity.
• As a best practice, it is good to have a DATE table in your model in Power BI.

Thanks,

Pragati

[Anonymous]

Thanks, Pragati. I thought the same, but I wasn't 100% sure if I could have done it in another way.