Forum Discussion
Connecting to multiple live datasets?
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?
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.
2 Replies
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!
darentengmfsPost Prodigy
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.