how to join info about 30 excel files on onedrive? (same structure)

[jamiguel77]

how to join info about 30 excel files on onedrive? (same structure)

Dudes

1) have any sample with similar structure?
2) is possible when Vendor5 update any information, automatically update the info on power bi?
3) Similar to 1, but any sample of creating gateway?

Thanks

 

[severynm]

1) have any sample with similar structure?
2) is possible when Vendor5 update any information, automatically update the info on power bi?
3) Similar to 1, but any sample of creating gateway?

1. If the files are all contained in the same folder, you can follow the instructions here to get data using the Folder connection. Otherwise, I think you will need 31 queries: one for each data source and then one combining them all together.
2. You can either a) have the report refresh on a specified schedule (e.g. once per day or once every x hours), or b) you can put together a Flow in Microsoft's Power Automate to watch an excel file and update a Power BI dataset when that file has changed. The latter is probably more what you are looking for.
3. Cannot help you there.