Excel.CurrentWorkbook() is returning error in contents column

Shatrunjay Tayal 6

when trying to use = Excel.CurrentWorkbook() in power pivot steps - Data menu --> Get Data --> From other sources --> Blank Query in the formula bar added = Excel.CurrentWorkbook() and pressed Enter result as below Content Name [Table] Table3 [Table] Table2 [Table] Table1 Error P2C!_FilterDatabase Error 'R2R'!_FilterDatabase Error S2P!_FilterDatabase can anyone advice how can i resolve this

Lz._ 8,991 Reputation points

2021-03-12T08:12:54.06+00:00

Hi @Shatrunjay Tayal

Can anyone advice how can i resolve this?
Virtualy not with the (to few) information you shared. + It's not clear which product you use: trying to use = Excel.CurrentWorkbook() in power pivot (???)
Jeana Henley 0 Reputation points

2023-06-30T17:34:50.37+00:00

I have the same problem. When using Power Query and getting data from a blank query using =Excel.CurrentWorkbook() it pulls all of the tables plus two Error tables(?) in the Contents column. The query works because I filter those miscellaneous 'Error" tables(?) out when I am in my desktop version of Excel, however the query does not work when in the online Excel version. It comes back with a 400: Bad Request message. How do I remove these erroneous pseudo tables? This is only a guess on my part that they are causing the 'Bad Request' error. Nothing else has seemed to make a difference and other queries on the same spreadsheet seem to work fine.