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.