Forum Discussion
Why does Power Query for Excel need to create a folder query by selecting a folder?
Hi Power-muke ,
According to your description, you want to connect by entering the url address without opening power query, you can enter the url you want to change in Get Data->Data Source Setting ->Change data sourceBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks for your reply, Anonymous .
I understand, but I need to query through a shared folder connection, so I need to fill it out in this format, such as: \\IP address\folder\file
My Excel version has always been 2019. I could fill it out directly before, but now I can only select a local folder. I know I can modify it in Power Query, but it's too troublesome. I wonder if there is an option that can be modified to query by filling in the address?
Hi Power-muke ,
According to your description, you want to connect by entering the url address without opening power query, you can enter the url you want to change in Get Data->Data Source Setting ->Change data source
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
This answer solved my problem, thanks for your help！