Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
4 years ago
Solved

Star schema in SQL. Fact updated Monthly dims updated daily

Hi all,   Just trying to get some refresh logic for power BI sorted and wondered if I could get some opinions.   Say you have a  few star schemas in SQL with conformed dimensions. Star Schema 1....
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

DebbieE it is not a different refresh schedule but incremental refresh will help since you will create a refresh policy in the incremental refresh, as there is no new data, there will be nothing to refresh. Read here for incremental refresh Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs

 

There are lot more blog posts on this so you should be able to put this together very easily.

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

  • DebbieE's avatar
    DebbieE
    Icon for Community Champion rankCommunity Champion
    4 years ago

    I will mention that to the guys creating the fact table so they can plan for a LastEditDate or update date. i dont honestly think a full refresh would hurt because its not a big model but this is definitely something we can plan in if neccessary. thanks