excel refresh issue

[Syndicate_Admin]

Hi All

I have an excel file which connects to my dataverse table and then creates a table in excel

Also on another sheet i have excel table which is created by connecting to a public website

But for some reason its giving some reference error when i open the file, dont know why, i checked my connections dont have any error, also my data model seems ok, so why its giving this reference error? its connecting to dataverse without any error and also to a website to extract fuel prices

[Syndicate_Admin]

hi

Thanks for reply, yes u r write, issue was that i referenced a table in pivot , and that table was deleted

[edhans]

I don't think this is Power Query related, or Power Pivot. I recommend you check out some Excel forums. Here is one article that addresses a few possible reasons for it. https://www.technewstoday.com/fix-reference-isnt-valid-excel/