Pull URL from table as source for new query

[Anonymous]

Hello! 

I have an issue I justcan't find a way to solve in Power Query (I have very little experience with Power Query itself to be fair) 

I'm using an API URL that returns a value 

That I converted into a table  

I need to use that URL "Value.url" (there will always only be one, but it will be dynamic), to actually pull the data I need that is stored in that target URL. 

Though I justcan't find a way to actually create a new "blank query" that uses the URL from "Value URL" to get the data I need. 

It seems like something that would be pretty easy... but can't find my way out. 

Anybody that could help me out? 

[v-lili6-msft]

hi  @Anonymous 

To my knowledge, it could not achieve in power bi for now.

As a workaround, you may refer to this post:

https://community.powerbi.com/t5/Desktop/How-to-setting-a-dynamic-URL-connection/td-p/57072

Regards,

Lin