Forum Discussion
PowerBI Dyanmic Web Request
Benmorgan86uk are you open to share small dataset what you are trying to do? may be it is goog candidate to make a function and use that to make it work.
Exactly right, so the exact steps I am taking is I am using the user_id column, adding as a new query, then creating a managed parameter that uses "suggested value = query" then specifying the new query.
Then I go get data, web, advanced, set the first part of the URL, then add the parameter into URL part 2.
The issue I can see is that when I hit Add as new query, it comes up as a list and I can make a parameter around it but cannot convert the data type, if I then convert the query to table, I can no longer use it as a parameter query.
Thanks for your help on this, this is more or less the first day I have started playing with this with any gusto
Super UserBenmorgan86uk are you open to share small dataset what you are trying to do? may be it is goog candidate to make a function and use that to make it work.
I took your advice about a function and have actually got this working.
Found the Guy in a Cube channel on YouTube really helpful.
https://www.youtube.com/watch?v=iiNDq2VrZPY
- parry2k
Benmorgan86uk Awesome, that's the way do it, glad it worked out. Cheers!!