Forum Discussion
Dynamically Change Data Source
Hi - Ideally I would want to maintain a Direct Connect versus an Import - but that might be OK. I can get this to work on the Desktop Version by changing the Parameter - however I am not having any success by add a parameter at the end of my URL string ?rp:Database_Name where Database_Name is the actual name of the Database and not the parameter.
When you say "update the stored connections in your config file." where is this config file located and how would I change it from the PowerBi Service?
HI Anonymous,
You are working with a huge amount of data sources. So if you want to fully parameterize the query tables, you need to create a lot of query parameters and they were troubles to be managed.
Use OneDrive for Business links in Power BI Desktop
Data refresh in Power BI
For this scenario, I recommend you to save continues into the file. These configurations are stored in the file, you can modify the file contents to update the connection. (you can upload to SharePoint or put it on the local drive and install the gateway to handle and manage this data source)
Then these query tables will be changed based on the new connection strings and you will get the different data source records.
Regards,
Xiaoxin Sheng
Hi - thanks again for your reply. However, in the end, I will have well over 500 individual databases and 10-20 tables per source - and some of these tables will be very large. I don't think the option of exporting the data to OneDrive would work. I also have concerns if more than one person is working on same Power Service location at the same time - as these databases must be kept independent of each other as they contain sensitive data specific to each client. I also don't want the clients or our internal business analysts having to modify data sources or having to hit a refresh button as that could be recipe for disaster. I'm looking for an automatic way of handling this. It appears that the best solution would be able to alter the M code that sets the source and transformations and somehow trigger that source for a refresh - although the refresh must always be Direct Query as I don't want to import the data for every client or schedule automatic refreshes as I don't know which client data will need to be accessed at any specific time. Plus I will attaching to Snowflake which should easily handle all of my queries and aggregations. I'm beginning to think that 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.