Forum Discussion

RossS's avatar
RossS
Helper II
10 months ago
Solved

Refreshing Data in Service

I am trying to setup incremental refresh, I have followed the neccessary steps and published my report to Service (this just contains 1 day of data). When I refresh the model, I get the following err...
Need Help
  • v-sgandrathi's avatar
    v-sgandrathi
    9 months ago

    Hi RossS,

     

    To do this, open your report in Power BI Desktop and go to Transform Data -- Manage Parameters. Create two parameters -- StartDate and EndDate (or RangeStart and RangeEnd) -- with the data type set to Date or Date/Time. Apply a filter to your main data table using these parameters, so only rows within the chosen date range are loaded. For example, filter the date column by [Date] >= StartDate and [Date] <= EndDate.

    After making these changes, publish the report to Power BI Service. In your workspace settings, find your dataset and look for the Parameters section under Dataset Settings. Here, you can update StartDate and EndDate whenever you want to refresh data for a certain period. Click Refresh Now after updating the parameters to load the filtered data.

     

    Thakn you.

v-sgandrathi's avatar
v-sgandrathi
Community Support
10 months ago

Hi RossS,

 

We wanted to check if you had a chance to review our last reply. Let us know if it helped or if you need more guidance, we're always happy to help further.
Thank you.

v-sgandrathi's avatar
v-sgandrathi
Community Support
9 months ago

Hi RossS,

 

As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?

 

Thankyou.