Forum Discussion
Inserting streaming data into a static table
I have already used dataflow approach, what it does is it truncates the streaming table data and insert the new data which then i append it to another historical table.
The api that i am using is not streaming ,it just gives me 1 record each day of that particular day,I just need to keep appending everyday records in 1 table to create an historical table
It's a difficult scenario to work in a direct connection API->PowerBi. You probably need a layer in between to store this data in a database and then read all the rows in PBI.
Remember that PBI works (typically) in "full load" everytime. You can't have "here is a piece of the new data, keep the old and add this". I've never used them but maybe dataflows might help you.
I have already used dataflow approach, what it does is it truncates the streaming table data and insert the new data which then i append it to another historical table.
- amitchandak
Super User
Anonymous ,
Is the last solution you have provided resolved your issue. Or you are still looking for a solution
