Forum Discussion

FRANKADVIES's avatar
FRANKADVIES
Frequent Visitor
9 years ago
Solved

changes in source excel

Hi,   My Power BI Dashboard imports 48 Excel tables (Facebook Insights data), including tables with more than hundred columns (columns for several countires worldwide). When I refresh the Excel dat...
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Hi FRANKADVIES,

     

    If you need to refresh the metadata, you need to ellipsis and then click refresh data.

     

    Regards,

    Charlie Liao

     

ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

FRANKADVIES If you go to power bi desktop query editor (Edit queries) and refresh there first then it will pick up metadata changes in your source file and then hit Close&Apply. Unfortunately if you just hit refresh in pbi desktop or via pbi service that is just the data refresh and won't pick metadata changes ie if your column name changes it will fail.