Unable to utilize & (and) symbol for query parameters

[MillsMachine]

I have run into a fairly large issue for using Power BI for reporting. With 30+ API endpoints, without the ability to create multiple query parameters within a URL, I'm unable to use the tool for reporting. For example:

Creating the following source:

Results in the following error:

Is there a workaround for this? If not, this seems like a huge oversight for REST API functionality.

[AlexChen]

Hi,

1.  You need to set parameter for “auth” and “team”. Set both “Type” to “Text”

2. Just add your parameters as URL parts, you don’t need to add string like “auth=”, ”team=”.

3. After click OK, you will be able to get data from the web.

Best Regards

Alex

[BhaveshPatel]

You need to create a parameter table for passing a dynamic patrameter value to your web queries.

First create a function 

(team) =>

let

 Source = Web.Page(Web.Contents("https://api.acme.com/api/monitor/list?auth=[auth] & team=" & Number.ToText(Page) &" & view=releasedate&view2=domestic&yr=2013&p=.htm")),

    Data1 = Source{1}[Data],   

in

invoke function

Create a Parameter Table based on your team names by using the blank query. Pass on your parameter values

This will solve your problem if I take your requirements correctly.