The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
How do you concatenate URLs that list object IDs and types in the string?
For example (test sample URL)
https://safe&secure.com/safeharbor/objectFiles.php?object_id=3227922&object_type=customer
I used the following to try to concatenate this URL and it didn't link to the website:
Solved! Go to Solution.
That's more of a question for your data source / URL target. Maybe they require the type to always be specified.
NOTE: Instead of CONCATENATE() you can use & .
Files = "https://safe&secure.com/safeharbor/objectFiles.php?object_id=" & [CustomerID_txt]
That's more of a question for your data source / URL target. Maybe they require the type to always be specified.
NOTE: Instead of CONCATENATE() you can use & .
Files = "https://safe&secure.com/safeharbor/objectFiles.php?object_id=" & [CustomerID_txt]