Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamically Change Data Source

Hi - I have 100 different databases with an identical structure - one for each of my clients.  The data in each are different but the visuals on the report are identical.  For my internal users who w...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

I would get data in different tables from all 100 datasources and keep one extra column for all select query as "Datasource" which will return a constant value like 'ClientrDB1' for query 1, 'ClientDB2' for query 2 and so on.

 

Once I have the all the tables created will use the below function on the PBI desktopto create a new table.
UNION(Query1, Query2, Query3,...)

In this newly created table I will use the column "Datasource" in slicer.

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

 

Hi, that won't work for us as the tables are quiet large and eventually there will be over 500 different databases each.  Additionally there are multiple large tables and they are updated constantly - so maintaining single versions of each of the large tables would be difficult.  Is there any way that anyone knows of to change the source on the fly.  I know most BI tools have this capability and assume that it must be in PowerBi albeit not easy to find.

 

Thanks for your suggestion though.