Forum Discussion
create trending table
Hi scsi050 ,
The response from v-kelly-msft will only show the last date and time the data was updated and the row count at that time. It will only ever show 1 set of data.
As you suspected it does not build a list of times and row counts that you can use as a trending table.
This sort of thing is difficult in Power BI as it is primarilly a reporting system, and there is no easy way to write back the data it reads. DAX has no "update table" function as such. You would be better looking at doing this with another tool, maybe a PowerApp, or SQL query.
Oh, and by the way, I get the same error message trying to load the pbix file they provided, I too am on the July release.
Hope this helps
Stuart
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