Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
2 years ago

reporting on data lake

is it good idea to build power bi reports directly on data lake (Azue Data Lake Storage) compare with data warehouse (Snowflake) , will there be any performance issue while building report on data lake?

Need Help

2 Replies

  • ahadkarimi's avatar
    ahadkarimi
    Solution Specialist
    2 years ago

    Hi powerbiexpert22, building Power BI reports straight off a data lake is doable, but it can be slow and clunky compared to using a slick data warehouse like Snowflake. Data lakes ain't optimized for heavy-duty querying, so you might hit performance issues, especially with big datasets. Best bet? Use the lake for storage and the warehouse for speed when you need those reports snappy.

     

    Did I answer your question?  If so, please mark my post as the solution!✔️
    Your Kudos are much appreciated!  Proud to be a Responsive Resident!

  • sevenhills's avatar
    sevenhills
    Super User
    2 years ago

    My 2 cents: We all know ADLS is slow for consuming directly in Power BI. You can add dataflow and datasets as additional steps to consume in Power BI. This is one approach. I did this approach for a project and going smooth.

     

    For ad-hoc or once in a while reports, you can consume ADLS data, which could be slow. 

     

    For regular reports, building Fact-Dim model, say dataflow+dataset or Snowflake, will always is your better choice for Power BI consumption. 

     

    Thanks