Forum Discussion
Building a URL with a Parameter and Column
My goal is create a template that can be shared, where some less-skilled users can enter information upfront in parameters and have the template work from that point forward. I'm quite new and am learning/working as I go.
One piece of this is a dynamic url, that uses a parameter field and a data column to create a weburl.
This is what it looks like current:
TenantName is the parameter; [UniqueId] is the column in the table
It works fine for me when I use it, and try it in a pbit on my local machine; however, when I save it as a pbit and share it, it prevents the data refresh occurring properly, until the tester goes in and edits this column formula to remove the parameter value and just recreate the static part of the URL with the TenantName. I've prefer having these users avoid touching the query screen, and just fill out in the style below upfront:
Any assistance/thoughts that would be simple? Or explain why when shared in a pbit with a new person, it no longer works properly as it does for me?
2 Replies
hutchbrett , Please make sure you have provided the values in the setting of dataset (Using three dots)
Also check
I'm not sure what your first comment means sorry...I have linked in the parameter into the statement.
This is what the string comes out looking like:
Thank you for the link; I'll play around with that to see if I can make it work for me using that approach. I know it's likely my inexperience.
