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.
I understand you CANT connect to multiple live sources of data at once. However, you CAN connect to multiple data sources at once, such as Excel files. Isn't it possible then, to have those individual Excel files connect directly to the live datasources, then connect to those multiple sources through PowerBI?
While I don't think you can establish an automated refresh in Excel to get the data, I may need to go into each file to retreive it, but isn't this a workaround?
Solved! Go to Solution.
Hi @Anonymous
You can have multiple excel files connected to those data sources, and connect your Power BI to those excel files.
You may use PowerShell to prompt refreshes on your Excel files for it to refresh, and use Task Scheduler to run the PowerShell script at any given schedule you want.
Hi @Anonymous
You can have multiple excel files connected to those data sources, and connect your Power BI to those excel files.
You may use PowerShell to prompt refreshes on your Excel files for it to refresh, and use Task Scheduler to run the PowerShell script at any given schedule you want.
hi @Anonymous - you can deifnitely connect to multiple excel or source flat files and clean up and combine the data in Power BI.
Please refer the video for reference.
https://www.youtube.com/watch?v=RAmSdxt863s
or
https://www.youtube.com/watch?v=9sfCDCpWTfc
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |