Forum Discussion
Count number of rows before loading the data
Hi, I am a Power BI pro user. While I was trying to get data in PowerBi, , it throws an error -"Unsuccessful execution due to resource limit" once it reaches around 20 million records". I was won...
Its generally expected that you will know that about your data source prior to attempting to load it into Power BI. If this data source is an SQL data base, you can include SQL statements to cut down the data to only what is relevant to you. It is also considered best practice to make use of Views rather than attempt to access the Tables directly for similar reasons.