cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RV1 Regular Visitor
Regular Visitor

Data Refresh failure

Data Refresh Error.PNG

 

I am extracting data from Dynamics 365. I have used Edit Query to limit each table to 7-10 fields. Some tables have row level filters as well. I am getting this error even on Excel Sheets for Dates. Can anybody help me with this?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: 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.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


8 REPLIES 8
Super User
Super User

Re: Data Refresh failure

Based on the way those tables are named, they look like date tables that are attached to your "Time Entry" and "Bookable Resource" tables.

 

It is advised that you create your own date table and make use of the "Mark as Date Table" function.  I've personally converted some PBIX files into Analysis Services and had to manually delete out some Local Data Tables that had appeared.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


RV1 Regular Visitor
Regular Visitor

Re: Data Refresh failure

Thanks Ross. 'Time Entry'  and 'Bookable Resources' etc are all Dynamics 365 tables. These are the user friendly names given to them. Apart from Date tables in Excel, all other tables have been sourced directly from D365.

Super User
Super User

Re: Data Refresh failure

Have you tried creating a date table and marking it as a date table as I have suggested?  The local data table that its complaining about comes about without a set date table.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


RV1 Regular Visitor
Regular Visitor

Re: Data Refresh failure

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.

Super User
Super User

Re: Data Refresh failure

Capture.PNG

 

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.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


RV1 Regular Visitor
Regular Visitor

Re: Data Refresh failure

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.

Super User
Super User

Re: 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.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


RV1 Regular Visitor
Regular Visitor

Re: Data Refresh failure

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.