Create Bookmark/Search filter for excel files that have a power Query/Connection

[gazmoz17]

Hi,

I'm new to power query so having a play. Is there a way to do the above....so I can quickly find excel files I've been using to practice. Have an excel filter, but It distinguish excel files feeding data from our Accs software via ODBC connector and power query?

Many thanks

[void]

From what I can see, no.

There are no power query/connection properties provided by Office.
There might be a third party property handler that provides this information.

Right click an xlsx file with a power query connection and click Properties.
Click the Details tab.
Are there any properties here that identify the file as having a power query/connection?
Everything 1.5 will have access to any of these properties.

[gazmoz17]

Hi,

No problem thanks for looking. I cant see anything in properties which distinguishes between normal excel.

Thanks