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
sakamotothais's avatar
sakamotothais
Icon for Helper III rankHelper III
9 years ago

Hi

 

Actually, I was working with excel, but it hit the line limit as well.

I found is strange to insert direct to be so little.

 

Thank You

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