Forum Discussion

magic-powerbi's avatar
magic-powerbi
Frequent Visitor
9 years ago

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 wondering if it is possible to check the number of rows in Edit option in Power BI before loading the data.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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.