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 ,

 

Your version is not the latest one,pls update to the version below:

Version: 2.84.282.0 64-bit (August 2020)

As your result needs to be updated due to every refresh, so measure is the best choice,and when you put the measures in a table visual,it will be added as 1 row in table.

 

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Burningsuit's avatar
Burningsuit
Resident Rockstar
6 years ago

Hi v-kelly-msft 

It's 3rd August 2020,  Version: 2.84.282.0 64-bit (August 2020) has not been released yet and is not available for public download. Most people still have the Version: 2.83.5894.961 64-bit (July 2020), only MVP's, Advisors and Microsoft staff have access to the August version at this time.

Even with that issue, I'm sure your solution will not do what was requested.

When you refresh the report, the measure  DATE/time will get updated and overwritten with the value in NOW(). The measure Count will get updated and overwritten with the value from COUNT('Table'[Column1]).

Then you will see..

DATE/time                               Count

03/08/2020 09:35:17                        2

In the Table visualisation

 

What you will NOT see is what was requested which would be...

DATE/time                               Count

31/07/2020 01:42:43 AM                 2

03/08/2020 09:35:17 AM                 2

 

As I explained, I don't think there is a way for Power BI to WRITE the data required to generate a Trending Table as requested, you'll have to use SQL or a PowerApp, or Flow.

I hope this clears things up

Stuart

 

 

  • 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).