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

It is a handy feature and I wish you could add more rows as well as have the ability to enter/edit data for models in the webservice.  Again, this is probably what Excel on a one drive is good for.

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