Anonymous's avatar
Anonymous
Not applicable
6 years ago
Status:
New

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

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?

9 Comments

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support

    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's avatar
    Anonymous
    Not applicable

    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.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support

    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. 

     

     

    Best Regards,
    Qiuyun Yu

  • Anonymous's avatar
    Anonymous
    Not applicable

    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?

  • Anonymous's avatar
    Anonymous
    Not applicable

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

     

    Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable

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

  • 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  

  • 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