Forum Discussion

RKM's avatar
RKM
Icon for Helper IV rankHelper IV
5 years ago
Solved

Refresh Power BI Report On-Demand

Apologies I'm novice and really getting a big pain to get around the topic of On-Demand Refresh in Power BI Report.   We use On-premises SQL Server and we have Power BI Pro and we got a WorkSpace w...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi RKM ,

     

    48 times refers to the upper limit of the number of scheduled refreshe that can be performed per day, and there is no limit on the number of manual refreshe (on-demand refresh).

    Data refresh 

     

    Best regards,
    Lionel Chen

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

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

RKM , Direct query will only pull required data, not full. In this case that is a more suitable option.

Or you can create a hybrid model. where few tables can be direct and a few are in import mode.

  • RKM's avatar
    RKM
    Icon for Helper IV rankHelper IV
    5 years ago

    My Users made it clear - They need on demand 'Refresh' i.e. they want to make a Button Click and refresh, as and when they need to. So let's stick to that.... i.e. I want to have a button and allow users (overall) to be able to refresh Dataset much more than just 48times.

     

    But out of that topic, I'd also like to understand this line... "Direct query will only pull required data, not full"

    this is something I would like to understand, so, are you saying, DirectQuery Means, it will compare what it fetched last time and then will pull only changed records to build the latest view or something else?