Forum Discussion

sakamotothais's avatar
sakamotothais
Icon for Helper III rankHelper III
9 years ago

Enter data directly into Power BI Desktop

Hi      Is there a limit to enter my direct data? Can anyone tell me if there really is this limit of entering the direct data?     It's only letting you load less than 500 lines Than...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
benmoulam's avatar
benmoulam
New Member
7 years ago

I also hit this limit (12cols, 909 rows). 

 

My data source was originally an Excel table, but we didn't want an Excel file to be the source when setting up the Gateway to our Data Warehouse. 

 

My solution was to cut and paste 5 separate tables (~200 rows each) and Append them into one table in the model.