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
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!

      • MMJen's avatar
        MMJen
        Helper I
        6 years ago

        Many thanks