Forum Discussion
Data Refresh failure
RV1 The purpose of marking a date table is that you should only have just 1 inside your entire model. Once you have the one you want, you should remove the others and update the table relationships to point to the single date table.
Just make sure you select your table before clicking that option. Its greyed out in my screenshot as i just opened Power BI Desktop quickly to take the screenshot.
I tried two solutions:
1.
Make a backup of your Power BI file
Navigate to Options -> Data Load -> Untick "Auto Date/Time".
Refresh all data
Navigate to Options -> Data Load -> tick "Auto Date/Time".
Refresh all data
When I unticked Auto date/time, I received another set of errors. Hence I back tracked.
2. Identified 2 date tables as date tables. There was a third table as well. When I tried to mark it as a date table, an error was generated as the dates field had gaps i.e. some dates were missing.
End result is that I am still getting the same error message.
RV1 The purpose of marking a date table is that you should only have just 1 inside your entire model. Once you have the one you want, you should remove the others and update the table relationships to point to the single date table.
Thanks Ross. I think I'll go back to the drawing board. The reports have been in making over a period of time with multiple developers. They require a cleanup. Thanks for educating me. Regards.