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 ...
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!