Forum Discussion

MMJen's avatar
MMJen
Helper I
6 years ago

ETL Data Load

Hi, I read and was recommended to avoid an ETL data load for a date table I created.  Any tips on how to do this?  
All very new to me. 
Thank you Jennifer

Need Help
Show and Tell

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    MMJen sorry not very clear what you are asking. Could you provide bit more context?

    • MMJen's avatar
      MMJen
      Helper I
      6 years ago

      Thanks for your reply, 

      This was on a blog I read today on creating a Date Table

      Date Dimension will be normally loaded once, and used many times after it. So it shouldn’t be part of your every night ETL or data load process.

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        MMJen I don't think it is a big deal if it is a part of ETL, it is very few rows, you can surely add Date dimension directly in Power bI using DAX or Power Query. There are many posts on how to create one directly in Power BI but honestly, I don't see it is a big issue having Date dimension from backend source. 

         

        I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!