Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
We have several databases consist of tables with the same schemas on a server. I have read that it's possible to switch between databases as sources for a report using parameters. However when I tried to use the parameter in the source --> applied step (power query) it does not catch the new database.
In the advance editor, I can see it is adding the parameter behind let Source = Sql.Databases("SERVER"),database (parameter)....
Could this be correct??!!
How to correctly dynamically change database????
Solved! Go to Solution.
@Anonymous , refer if this blog can help
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
@Anonymous , refer if this blog can help
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |