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.
Super UserBenmorgan86uk seems like you are dynamially merging your user id into your query, can you make sure to change the data type of user id column to text before you concatenate it with web query.
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
- parry2k
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.
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
