Cannot refresh all my web sources and only some of them are detected because url names looks similar

[Ania_Learn]

Hello every one,  I have 4 web csv sources, meaning that i want to refresh my 4 tables, here an example :  www.website.com/public/downloaddata?Red=true

www.website.com/public/downloaddata?Red=false

www.website.com/public/downloaddata?Green=true

www.website.com/public/downloaddata?Green=false

In my Desktop version everything is working fine, when refreshing all the sources are refreshed. But in Desktop "Data source setting" and in  app.powerbi.com only two of them are used (one red and one green) and false/true depending on which one i have used first. For example

www.website.com/public/downloaddata?Red=true

www.website.com/public/downloaddata?Green=false

Or 

www.website.com/public/downloaddata?Red=true

www.website.com/public/downloaddata?Green=true

Or 

www.website.com/public/downloaddata?Red=false

www.website.com/public/downloaddata?Green=false

If i publish the updated Desktop version it is working but here the issue is that if i want a automatic refresh only two sources are detected and refreshed. I tried other websites and i always have the same problem : when web source have the same characters in the beggining www.testdatadata.com/notworking/ [here even if there are 100 data basis only one is detected and refreshed in the app.powerbi parameters).

What's wrong ? do you have any solution ?

Thanks !

[v-lionel-msft]

Hi @Ania_Learn ,

As @lbendlin  said, you can try to create four query parameters. The specific steps are like this.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ania_Learn]

I'm sorry I did an error my sources looks more to this : 

 www.website.com/public/downloaddataRed?parameter=true

 www.website.com/public/downloaddataRed?parameter=false

 www.website.com/public/downloaddataGreen?parameter=true

 www.website.com/public/downloaddataGreen?parameter=false

I used  www.website.com/public/downloaddataRed?

(two times)

and 

 www.website.com/public/downloaddataGreen?

(also for two tables)

I did what you said i have created two Queries parameters p1 with paremeter = false and p2 with parameter = true.

But in the power bi web site, when i go to my sources it show me only two web connections which are :

 www.website.com/public/downloaddataRed?parameter=false

And

 www.website.com/public/downloaddataGreen?parameter=false

I can't verify if it will refresh the 4 data basis or only the ones with parameter = false , bacause my  data is supposed two refresh once a month.

What do you think ? I'm i supposed to get 4 sources ? or only two of them ?

[lbendlin]

Your goal is to end up with one connection. Not two, not four. One. Please check the above guidance again.

[Ania_Learn]

have tried one more time, set the first url web for each table :  www.website.com/public/

I created 4 queries parameters 

p1 = downloaddataRed?parameter=false

p2=  downloaddataRed?parameter=true

p3 =  downloaddataGreen?parameter=false

p4 =  downloaddataGreen?parameter= true

I get the right tables but when publishing i still see two web sources www.website.com/public/downloaddataRed?parameter=true  and www.website.com/public/downloaddataGreen?parameter= true.

So i think only this ones are refreshed

I dont want it to take into account the   "downloaddataGreen?parameter= true "  only otherwise i want the 4 sources. 

  

[lbendlin]

You can try to parameterize your data sources so that they have a common base.

Instead of

 www.website.com/public/downloaddata?Red=true

You would use

 www.website.com/public/downloaddata, [Query=[Red=true]]

Note: I noticed that recently the web connector on the gateways has become much more intelligent so that this may no longer be needed for internal web URLs.