Forum Discussion

Dgasld77's avatar
Dgasld77
Regular Visitor
4 years ago
Solved

Add manual data to duplicated table? Or use powerapp?

Hi all, Newbie here. 1.  I have pulled in and merged data from a "folder" that contains hundreds of csv files in same format.  2.  I have duplicated this table/query so that I can delete all colum...
Need Help
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    4 years ago

    "enter manual data"

     

    Are you asking for yourself as a developer, or are you expecting this to be available to a Power BI report viewer?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Yes, what you describe is possible with Power Query. But it is not very elegant, and not designed for frequent interaction.

 

 

Dgasld77's avatar
Dgasld77
Regular Visitor
4 years ago

Anyone with any tips as to how?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Once you have clicked "Enter Data" and selected a table/Query name you would then need to press the cog wheel icon next to the "Source" step to get back to the data entry/modification screen.

    • Dgasld77's avatar
      Dgasld77
      Regular Visitor
      4 years ago

      Thanks Ibendlin.  Yes I know about using the manual data but it's the adding manual data to an existing query.  Anyway, it sounds like it can't be done.  Thanks anyway 🙂

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        4 years ago

        You can append queries in Power Query, doesn't matter where they come from. So you can append your manually entered data to data from a database table, for example.