Forum Discussion

RV1's avatar
RV1
Helper I
7 years ago
Solved

Data Refresh failure

 

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

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.

    • RV1's avatar
      RV1
      Helper I
      7 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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.