Forum Discussion

scsi050's avatar
scsi050
Regular Visitor
6 years ago

create trending table

I am trying to find a way to create trending data within PowerBI.   I have table2 that gets updated with each refresh and upon each refresh, I would like a new row to be appended to an existing table...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi  scsi050 ,

 

Yes, sorry,as corrected by Burningsuit ,we can only write the current data after refresh,but once you did it,it will overwrite the previous one, a Trending Table is not available as you requested in power bi .

Sorry again.

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
 
scsi050's avatar
scsi050
Regular Visitor
6 years ago

thanks for the responses.

  • scsi050's avatar
    scsi050
    Regular Visitor
    6 years ago

    One more related question. If the data cannot be generated within powerbi, I could do it external to powerbi.

    1) is there an API  endpoint to download a table from powerbi? I see that there are but from what I can see, they all require PowerBI Premium (I just have Pro). Is that true?

     

    2) If #1 is possible, is there an API endpoint to update a table? (And again, same question about powerbi licensing).