Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Still new to power bi and it truly is a powerful tool. I'm running into one road block with my power query. The only way I've been able to make a proper POST API call to retreive data is by putting the Content of the Web.Contents body in a type of script block. This places quotes around the entire block for values to be taken as writen, but does not allow for they use of variables or parameters inside.
Example in the screenshot works perfect, but I need to be able to use parameters preferably that way values can be changed for the same call.
The last screenshot, I've tried variables of different types and even parameters, but they break the syntax.
Any help is greatly appreciated.
Solved! Go to Solution.
Hi @papi0506
Try concatenating the string pieces rather than having everything in one string. Place the following M code in a blank query to see an example
let
#"tryagain" = "GetInThere",
BodyContent_= "{ ""password"" : " & #"tryagain" & " }"
in
BodyContent_
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Hi @papi0506
Try concatenating the string pieces rather than having everything in one string. Place the following M code in a blank query to see an example
let
#"tryagain" = "GetInThere",
BodyContent_= "{ ""password"" : " & #"tryagain" & " }"
in
BodyContent_
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Hey @AlB,
Thank you so much, your suggestion worked like a charm. I had been looking for the proper syntax to all concatening strings together. This was exactly what I was looking for.
Can you paste the query as text in this post so that experts can work on your query?
I'll keep that in mind for next time. AIB's suggestion worked perfectly and I can even use it with parameters now {yeaaaa}. Thank you very much tho.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |