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

I've definitely hit that limit too but wondering what the actual number was.

 

You can enter data into a csv file, or excel and then read that into your model if you need more.

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