Forum Discussion
Anonymous
5 years agoNot applicable
Create a model to use with different datasources
Not sure how to deal with this, I have multiple clients each with their own data sources. The data is provided to me in a consistent format (same tables, same columns, etc). What I am trying...
- 5 years ago
You can do what you propose by getting data from an excel sheet, but it might be easier to do the following. Make a table with all the combinations of clients, folder path, etc., along with a function to get the data from each. You can then add a filter step about the step to get the data, you can filter to one or more clients and the folderpath, etc. will be there already. This would allow you to look at data for multiple or all clients at once if needed.
Pat
amitchandak
Super User
5 years agoAnonymous , I doubt a template can solve the purpose.
There is this option in the blog, I doubt will solve your case, but have a look
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters