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) ?
Burningsuit
Resident Rockstar
Resident RockstarI 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