Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Data refresh issue (On demand automatically run right after publish from power bi desktop)

Submitted by Anonymous on ‎03-31-2020 12:46 AM

Right after I publish the powerbi file/dataset from desktop, the On demand schedule run automatically.

Why is this happening?

It happens since last week!

Also, how can I stop the "On demand" data refresh in powerbi web service?

Status: New
See more ideas labeled with:
9 Comments (9 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎04-01-2020 12:53 AM

Hi @Anonymous, 

 

Which data source did the report get data from?

Which connection mode did you use, import, DirectQuery or Connect Live? 

How did you find the dataset is refreshed after publishing to service? 

 

Best Regards,
Qiuyun Yu

 

Anonymous
Not applicable
‎04-02-2020 12:48 AM

Hello @v-qiuyu-msft ,

 

The datasets are getting from multiple datasources, all connection mode are "import".

You can refer to the picture attached, left hand side refresh history are the log of my dataset being published into the power bi web, immediately after the published, the scheduled run will run on demand (automatically). I did not manually trigger it.

pbi.png

v-qiuyu-msft
Community Support
Community Support
‎04-03-2020 01:17 AM

Hi @Anonymous, 

 

Did you put the pbix file in your OneDrive or SharePoint online then connect to this pbix file in Power BI service? If it is, you can turn off OneDrive Refresh in Dataset Settings. 

 

q6.PNG

 

Best Regards,
Qiuyun Yu

Anonymous
Not applicable
‎04-05-2020 06:32 PM

Hello @v-qiuyu-msft , nope. 
I do not put the pbix in the "OneDrive or SharePoint online".

Just publish the pbix from desktop to power bi service.

Moreover, I do not have such option that you mentioned above.

 

Any insight? Bug?

v-qiuyu-msft
Community Support
Community Support
‎04-07-2020 12:18 AM

Hi @Anonymous, 

 

I would suggest you create a support ticket to get help. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu

Anonymous
Not applicable
‎04-09-2020 11:20 AM

@v-qiuyu-msft , I had just filed a support ticket to get help. Hopefully they will be able to resolve this.

 

Thanks.

Anonymous
Not applicable
‎03-17-2021 03:27 AM

I have the same issue, did you get a reply on how to fix it?

MaxDamage
New Member
‎08-21-2021 12:15 AM

Hello everyone,

 

I'm facing the same problem: when a pbix file in mixed storage mode is published from desktop to the Power BI service, an on-demand refresh is triggered right away, even though the refresh is scheduled to run only 1 time daily late at night.

 

This is quite troublesome, as it hammers our DB at undesired times throughout the day.

 

Can this be configured? It this a bug or by design?!

 

Best regards  

alexgor87
Advocate II
Advocate II
‎02-02-2022 10:48 PM

Hi everyone,

 

I'm facing the same problem: I want the data to be published exactly as I see it in the desktop, but Power BI service automatically runs the refresh after I publish the PBIX.

 

Microsoft - please fix this

 

UPDATE: if I switch off the scheduled refresh - then I can publish the pbix and the PBI service doesn't run the refresh again. So try disabling the scheduled refresh while you publishing the datasets from the desktop.

 

Best regards

Idea Statuses