Forum Discussion
Dynamically Change Data Source
Anonymous Dynamic Query parameter should able to solve it, check this post
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- Anonymous5 years agoNot applicable
Hi - parry2k, I will certainly give kudos to someone who can answer this question. I looked at the link and am familiar with setting parameters after the data source has been determined. I am trying to set the datasource - based on passing a token in PowerBi Service - that identifies the database that that all subsequent queries will use. I have not found a way to modify the data source in PowerBi Server - even by passing the parameter on the URL string via ?rp: I did read the SQL Server does not support Direct Query for parameters and I was using SQL Server as my test bed. However I will be using Snowflake and it would be great if the solution showed a method whereby I could dynamically switch (without my users having to interact with PowerBi) the data source and maintain that workspace independent of other users coming in to the same workspace neededing to access another data source. I do believe that it may be impossible for PowerBi to handle this as PowerBi is great for Individual companies for but not for companies which have a product that is used by hundreds of clients. I am hoping to be able to use PowerBi as both a destination and to also use the PowerBi embedded which would be a key portion of our internal product. And in both cases I want to handle the data source switching and connection refresh behind the scene.
- Anonymous5 years agoNot applicable
Hi Anonymous,
Perhaps you can take a look at the power bi premium XMLA endpoint, this function seems to allow you to connect the data sources that host on remote servers.
Dataset connectivity with the XMLA endpoint
Regards,Xiaoxin Sheng