Forum Discussion
How to insert external data into local table in Power BI
Dears,
I have a data source, which gives daily records. Yet I need to store all these data and analyze it. How could I perform that? I planned to set up a local table in Power BI, and then set up a query to get the daily data, and then append the daily data to the local table. But it doesn't work since the "append" function in power BI does not really write the data the target table.
Is there any solution for it?
Thank you so much!
4 Replies
Hello Anonymous
in Power BI/Power Query is no technical solution to this. What you could think of is to Implement your query into Excel and with an automatism to launch a makro that
a) updates your query
b) copies the output of the query into another table
You could use this Excel-sheet for imput in your Power BI
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy- Hi Jimmy, Thanks for your help and deeply sorry for my late reply. Yes, currently we download the report to excel file everyday and put it into a folder, it is just too boring. I'm trying Power BI's "Incremental refresh" function, will share if it is the way to go after get it done. Again, thanks for your help!
Hi, Anonymous
I'd like to suggest you try using folder connector to combine data in each excel. Please make sure each table in each excel has the same name and column names. Then you need to select the object to be extract from each file.
When you add new file with new data in the folder, you only need to click refresh button to get the new data.
Result:
For further information, please refer to the document .
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Hi Allen, Thanks for your help and deeply sorry for my late reply. Yes, currently we download the report to excel file everyday and put it into a folder, it is just too boring. I'm trying Power BI's "Incremental refresh" function, will share if it is the way to go after get it done. Again, thanks for your help!
