Location Date tables not refreshing

Hi Diane_Gribi ,

 

This tables are created automatically by Power BI when you have the Auto-date time turn on you can turn it off in:

• Options & Settings
• Options
• General - Data Load 
• Current File - Data Load

Search for the time-intelligence

 

 

 

This automatic table are not stopping your refresh because they are dependent on the tables you have on your model with date columns.

 

If you are having problems with the refresh you should look for the queries that refer a specific error, the ones that are identified with waiting for other queries are not the responsible for those problems because they were not loaded at the time of the error they are only run after the others that they depend on.

Hi Diane_Gribi 

 

Please check in that table which column has inconsistent data

For example, some of the records in Date column might have a text data. 

 

You can go to Power Query and check those records, check in all the columns for which it is happening 

 

Then you can replace with Blank or NA or 0 or if those records are not required for the reporting you can delete 

Hi Diane_Gribi,

Have you had a chance to review the solution shared by MFelix, Tahreem24, krishnakanth240? If the issue persists, feel free to reply so we can help further.

 

Thank you.

Hi Diane_Gribi,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

 

Thank you.