Forum Discussion
How many datasources can i create on Power Query
- 4 years ago
dujos Correct, there is no published limit.
- 4 years ago
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"
dujos I have never seen a published hard limit to the number of queries or data sources that can be present in a PBIX file.
Hey hello Greg_Deckler thank you for answer. and Yes maybe there is not an existent situation like that but for example there is an area on my job that is already using about 20 different connections resulting on 20 tables but as i'm thinking this is not practical so i will try to help the area showing that its possible continuing like that there is no limit (if i understood well) but it is no practical. Is that right?
- Greg_Deckler4 years agoCommunity Champion
dujos Correct, there is no published limit.