Forum Discussion
Onedrive calendar table refresh
Hi Anonymous
It may be due to the NOW() function in today column in the Excel file. The results of the NOW function change only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously. If you store the file in Onedrive and don't open it, it will not recalculate NOW() for today column. So the data in Excel file doesn't update until next time you open it.
Instead of adding these flag columns in Excel file, you could add them with DAX in data model, or add custom columns with Power Query Editor. With these two ways, they will be recalculated and get updated in Power BI when refreshing the data. There are tutorials and scripts for both methods in this link Power BI Date or Calendar Table Best Method: DAX or Power Query? - RADACAD
Hope it helps!
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi Anonymous
It may be due to the NOW() function in today column in the Excel file. The results of the NOW function change only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously. If you store the file in Onedrive and don't open it, it will not recalculate NOW() for today column. So the data in Excel file doesn't update until next time you open it.
Instead of adding these flag columns in Excel file, you could add them with DAX in data model, or add custom columns with Power Query Editor. With these two ways, they will be recalculated and get updated in Power BI when refreshing the data. There are tutorials and scripts for both methods in this link Power BI Date or Calendar Table Best Method: DAX or Power Query? - RADACAD
Hope it helps!
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.