Forum Discussion

RenaG's avatar
RenaG
Frequent Visitor
2 years ago
Solved

Getting a 'Sheet1$FilterDatabase' when importing from Web source

Hi,

 

I'm trying to import a file into my PBIX using the New Source | Web option.  I have copied the path from the Info on the Excel spreadsheet. I tried importing this file previously but it has errors so had to re-create it and try again.  Now I am getting this:

I don't know what the Sheet1$FilterDatabase is or what it means. Normally I just see the Sheet1 checkbox.  Is that the one I should use?

Thanks,

Rena

Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    That is a hidden sheet in Excel that keeps track of your interactions with the actual sheet.  You should ignore it and always only use the original sheet as a source.

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    That is a hidden sheet in Excel that keeps track of your interactions with the actual sheet.  You should ignore it and always only use the original sheet as a source.