Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I'm working on building dashboards for the data that is coming from different zones. The data for each zone resides in differents servers. I'm using sql server to connect with power bi. Now, because of some issues, we are only working on 5 out of 7 zones. I've applied some transformations on the current data like reordering the columns, appending and splitting the columns by delimiter. I want the option of automating the process of applying steps on the databases that aren't connected yet. Is there a way to re-use the same applied steps for the new databases as and when they get imported into power bi.
Please help me on this
Thank you!
Hi @Anonymous ,
Please refer to the case.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Edit data source connection details. Same steps should work on new Database
you can copy code from the advanced editor and change the names to suit the different connections you require
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |