Forum Discussion
Refreshing Data in Service
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.
Thank you for the reply.
I have a pro license. What I am trying to do is setup incremental refreshes so whenever a user wants to update the data, usually it will be for the current day only, a refresh is performed only for that day. Is there no way of doing this with a pro license?
Hi RossS
Thank you for confirming. Since you’re on a Pro license, incremental refresh isn’t available because it requires partition management, which is only in Premium or Fabric-enabled workspaces. You can still get similar results by using a parameter-based manual refresh. In Power BI Desktop, set up two parameters like RangeStart and RangeEnd and use them to filter your date column in Power Query. Before publishing, adjust these parameters to select the data you want, such as for the current day. After publishing, users can update the parameters in the dataset settings and refresh to update just that range. If you upgrade to Premium later, you can enable incremental refresh without needing to rebuild your model.
Thank you.
Thank you. Are you able to provide step by step instructions for the paramater-based manual refresh?
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.
Hi RossS,
Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.Thank you.