Forum Discussion
Refreshing create duplicate (Power bi pro license)
Hi All,
I am stuck in my power bi jouney, tried many video in youtube didnt help me.
I created my Power bi desktop with incremental refresh from sql, manual refresh is perfectly working in this after publishing the report to power bi service did all necessary setting, i encouter two issue, really appreciate some one can help.
1)when i click on refesh on power bi service-work space-click on refresh now on sementic model, it creates duplicate records.
2)when i click on power automate button it shows trigger but data not refreshing.
duplicate issue never happens in power bi desktop, i am eally stuck here.
Thanks
Abdul
Hi abdulncr
For the duplicate records issue, it could be caused by the way you set up your RangeStart and RangeEnd parameters for the incremental refresh. You should make sure that they are not both inclusive, meaning that you should use either 'Date >=RangeStart and Date < RangeEnd' or 'Date >RangeStart and Date <=RangeEnd' as your filter condition. Otherwise, you will get duplicate rows for the boundary dates.For more details and examples, you can check this article:
Solved: Incremental Refresh - Duplicate Rows for Refresh W... - Microsoft Fabric Community
For the power autoamte trigger not refreshing data issue, try the following steps
- Check the Flow Configuration: Ensure that your Power Automate flow is set up correctly. It should be linked to the correct workspace and dataset in Power BI.
- Permissions: Make sure the account used in Power Automate has the necessary permissions to trigger a refresh in the Power BI dataset.
- Flow Actions: Confirm that the flow actions in Power Automate are correctly configured to refresh the dataset and not just trigger an alert or another action.
- Power Automate Logs: Review the run history and logs of the Power Automate flow to see if there are any errors or issues that could be preventing the refresh.
For more details and examples, you can check this article:
Solved: Power BI dataset refresh with power automate butto... - Microsoft Fabric Community
Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi, for the topic of the first problem, my money is on incorrectly written (or set) parameter... Hard to tell more, without knowing more details.
can any one please help on this?
Hi abdulncr
For the duplicate records issue, it could be caused by the way you set up your RangeStart and RangeEnd parameters for the incremental refresh. You should make sure that they are not both inclusive, meaning that you should use either 'Date >=RangeStart and Date < RangeEnd' or 'Date >RangeStart and Date <=RangeEnd' as your filter condition. Otherwise, you will get duplicate rows for the boundary dates.For more details and examples, you can check this article:
Solved: Incremental Refresh - Duplicate Rows for Refresh W... - Microsoft Fabric Community
For the power autoamte trigger not refreshing data issue, try the following steps
- Check the Flow Configuration: Ensure that your Power Automate flow is set up correctly. It should be linked to the correct workspace and dataset in Power BI.
- Permissions: Make sure the account used in Power Automate has the necessary permissions to trigger a refresh in the Power BI dataset.
- Flow Actions: Confirm that the flow actions in Power Automate are correctly configured to refresh the dataset and not just trigger an alert or another action.
- Power Automate Logs: Review the run history and logs of the Power Automate flow to see if there are any errors or issues that could be preventing the refresh.
For more details and examples, you can check this article:
Solved: Power BI dataset refresh with power automate butto... - Microsoft Fabric Community
Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
