How many data sources can the Query Editor support?

[TakedaBill]

How many data sources can the Query Editor support?  My use case requires that once a month I add another data source and append new data to the existing data.  Snippet below shows I have 5 updates that have been appended to Data.  At what point will I no longer be able to add another datasource?

[v-eachen-msft]

Hi @TakedaBill ,

As far as I know, there are no limits. However, too many data sources can cause slower refresh times.

[judspud · Accepted solution]

Hi @TakedaBill 

Are all the datasources the same format? i.e. do they all have the same columns

Are they all from the same location? same folder in documents or shared drive

If so, you could use the get data from folder option which then allows you to combine all files within a folder together to get one table.

Hope this help

Thanks,

George