Postgres database and table performance dashboard in Power BI

[Bit2021]

I have a database in PostgreSQL with some tables. Now, I want to create a dashboard for monitoring the below metrics.

• Table size and table size growth rate per day

• Table records count and count growth rate per day

• records calculated rate

What is your suggestion for this solution?

[v-henryk-mstf · Accepted solution]

Hi @Bit2021 ,

According to your needs, my suggestion is:

    1. You can dynamically update the latest data according to day by configuring incremental refresh.

        related document link: Configure incremental refresh for Power BI datasets - Power BI | Microsoft Docs

    2. Then in powerbi, you can create a dax formula to calculate the daily addition according to day Data volume to record daily counts and count growth rates.

        just like:

Col_ =
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER ( 'Table', 'Table'[Data] = EARLIER ( 'Table'[Data] ) )
)

Change_conut = SUMMARIZE('Table','Table'[Data],'Table'[Col_])

    3. Select the corresponding visual to show the result of the change

In additional, you can use Usage Metrics or do it yourself to monitor report.

related document link: 

Usage Metrics or Do It Yourself Power BI Monitoring Report - RADACAD

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Bit2021 , do you have some metadata data of postgresql from where you can read this?

Using those and DAX append you should be able to build that data in power bi

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[Bit2021]

I have a database in Postgresql then this database update every day.

Now, I want to create a dashboard to monitor the table statics on this database.

I can read data directly from the database.