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
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Do you have access to a database?  eg, SQL, Azure or even Access?

 

Flat files should have no limit, but a bit of a pain to edit.

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

Yes, I work with SQL, however for this type I put in temporary tables, and power BI is not letting me load in. The idea was to let power BI work with history and connect to the bank only the daily update. thanks