Forum Discussion
Pass parameter into Web Source URL based on another parameter
I have a Projects table that contains the project's ID and Name that's imported as a Web Source. The URL and contents imported are generated from the site's REST APIs. (URL.com/projects.xml). Each p...
You have two ways you could go on this:
1. Make queries that have parameters for ID and project as inputs, save it as a template file (pbit). When each user opens the pbit, they will be prompted to select project and/or ID and then the data will load.
2. Recommended - load all the data into your model. Starting with a table of projects and ID values, you can concatenate each into web calls, and then expand that column of tables for the fields you want to append all the data. Then have a slicer for the use to filter to the desired projects and/or IDs.
Regards,
Pat