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 columns except 1st column.
Is it possible to add a few columns to the right of this remaining (1st column) and enter manual data?
Then when you hit refresh, more cvs data is added to the original table/query from the "folder" which then is added in the single Column 1 in the duplicated table/query but the previously manually entered data remains unchanged but then you can enter more data to those columns where data is missing?
If not, can you do this in powerapps?
Hope that makes sense
Solved! Go to Solution.
I'm definitely no developer. I'm just teaching myself and just didn't know if this was even an option. If not, that's fine but if so, perhaps you or someone could point me in the direction of a youtube video explanation or give me some kind of general instruction.
Power BI is a reporting tool. It has no memory, everything is reloaded each time you run a refresh (ignoring the whole incremental refresh topic here as it doesn't apply to your scenario). You would need to do what you describe in a system further upstream (like in your folder structure).
I guess I shouldn't really be referring to Power BI but Power Query. There is a manual data entry table and I'm wondering if you can attach it to an existing query/table that has been pulled in and "cleaned" from a folder on OneDrive?
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.
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 🙂
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.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
At the monthly call, connect with other leaders and find out how community makes your experience even better.
Click here to read more about the May 2022 updates!