Forum Discussion

Amjad1002's avatar
Amjad1002
Helper III
3 years ago
Solved

Error on Refresh

Hello Folks,   I have data files located into sharepoint and I am using web link to connect data for PB dashboard. This is happening second time. I created the dashboard and refresh, it work good ...
Need Help
  • GregMarbais's avatar
    GregMarbais
    3 years ago

    That's pretty easy - in this section:


    Find "PRIORITY" in red and change it to "DC Week" - just make sure it matches what's shown in the column header in the step earlier

GregMarbais's avatar
GregMarbais
Kudo Collector
3 years ago

Amjad1002 Rather than refreshing the table, go into Power Query:

In Power Query, you should be able to see which queries have errors in it - it looks like it may be a handful of the tables.
If you don't see any errors when you open Power Query, click the drop down arrow under "Refresh Preview" and click "Refresh All"


That will try refreshing the preview data for each table. And you'll likely see errors in the tables. Then you can update any table names in Power Query or delete the tables and re-import them. But for sure, you'll need to make the updates in Power Query to fix the errors you're seeing. It looks like it may be a mix of changes to the location of files, changes to the name of files, changes to the tab names in excel files that may be causing those errors.