Forum Discussion

Raaz's avatar
Raaz
Icon for Helper II rankHelper II
6 years ago

Add row to a custome table after each refresh

Hi Community Experts,   I have a calculated measure. I want to write this measure to Power BI table(New Custome table)  with current system time hour after each refresh as a new row. i.e. when quer...
Need Help
Raaz's avatar
Raaz
Icon for Helper II rankHelper II
6 years ago

Very nice post!!!

 

I tried to edit this for my requirement which is incremental refresh by hour instaed of each day. But in the incremental refresh options, refresh rows gives choice for only days,month, quarter and year not hour. Is there any way to specify refresh row by hour ?( i am not talking about scheduling in powerbi.com but incremental refreh in power bi Desktop)

 

Thanks,

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional
    6 years ago

    Hi Raaz ,

     

    incremental refresh in Power Bi Desktop is not possible.

     

    In the Power BI service, you must specify each execution time individually.

     

    You can perform multiple dataset refreshes daily, which might be necessary if the underlying source data changes frequently. Power BI limits datasets on shared capacity (Power BI Pro) to eight daily refreshes. If the dataset resides on a Premium capacity, you can schedule up to 48 refreshes per day in the dataset settings.

    https://docs.microsoft.com/en-us/power-bi/refresh-data#data-refresh