I am experiencing a strange phenomenon recently with PowerBI Service which did not happen before.
Once I publish from Power BI Desktop and the publishing has finished, it triggers a dataset refresh in Power BI Service as "On Demand" from the SQL Server database which is something I do not want. I have a daily scheduled refresh every day at 09:30 AM and that's all I need.
I just want it to be like before where the Power BI service dataset gets overwritten by my published PowerBI Desktop dataset.
What is wrong and why is it happening? I've been searching all around but could not find any information.
Maybe you could turn off the schedule refresh, after re-publishing report to service, turn on the scheduled scresh again.