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.
I do have a date table but I don't know how to mark it as a Date Table. Could you please guide me on that? Many thanks.
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.