How to check if power query is valid

[jaryszek]

Hi Guys,

Screenshot_124.png

i want to check if data soure in Power Query has error via VBA.
How ?

Let imagine that i am loading data from server like web query.
If something is wrong on server Excel will create queary with error.

And I would like to check if query has error or not in order to avoid inputting it to listobject.

Code to add query:

Please Login or Register  to view this content.

I added source table in seperate table to reproduce error.
You can just run code to create query and you will see datasourceError in PQ. How to detect it?

Please help,
Jacek

[jaryszek]

Hi,

anyone?

Jacek

[jaryszek]

anyone has idea?

Best,
Jacek

[jaryszek]

Hello,

cross posted here:

https://www.mrexcel.com/board/thread...m-vba.1162285/

Best,
Jacek

[jaryszek]

Hello,

up,

Jacek