Forum Discussion
How many datasources can i create on Power Query
dujos Correct, there is no published limit.
There is no published limit. You are not going to hit any issues with 20 tables. If you are going to run 200-500 tables, then you may start to see real performance degredation, but Power Query is not going to throw up an alert and say "You cannot add anymore data sources"
I know of no practical limit. You also have to define what is a data source. If you mean Server and Database, then that is all the gateway uses. You can connect to 50 tables in Power BI from that same Server/Database combo. For Power BI that may be 50 data sources/tables (though I'd hope you merge them down to a useful Star Schema) but from the service standpoint, it is 1 data source and gateway connection because you don't define tables in the service, just servers and databases.
Hello edhans thank you for your answer. You are right maybe doing that its not practical but i would like to know if there is a limit if there is not a limit so ok thank you!!!!
There is no published limit. You are not going to hit any issues with 20 tables. If you are going to run 200-500 tables, then you may start to see real performance degredation, but Power Query is not going to throw up an alert and say "You cannot add anymore data sources"