Forum Discussion
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...
That's unfortunate. If I process the trending calculations externally from PowerBI, does it have an API endpoint that would allow me to get a table's data, I can count that, and then POST to a Power BI API endpoint to add a new row to a table (add a new row, not overwrite one) ?
I don't think so. Again Power BI has no tools for writing data. I'd be looking at Power Auomate and an SQL query to do this sort of thing.
Stuart