Forum Discussion

CPL_HK's avatar
CPL_HK
Frequent Visitor
6 years ago
Solved

Scheduled refresh - Select for which data source

Dear Team,

 

I have been running a scheduled refresh in PowerBI Service of a SQL database via gateway and it worked perfectly fine. I then added an additional data source (an Excel file) in PowerBI Desktop and after publishing the file, I received a scheduled refresh error:  the credentials for the (locally saved) Excel file are wrong. However, I don't even want to refresh the Excel file in PowerBI service (it's some data which doesn't change), I just want to refresh the SQL part. There is no way to activate scheduled refresh tough, as all credentials of all data sources need to be correct. 

 

How can I either only do a scheduled refresh for one of the two data sources, or alternatively configure the Excel file in a way that PowerBI does not think of it as a source it has to refresh in PowerBI service?

 

The problem is also described in the video here (at around 4:30). 

https://www.youtube.com/watch?v=uxsQUArF2Ts

 

Thank you,

Christian 

 

 

Need Help
  • GilbertQ's avatar
    GilbertQ
    6 years ago

    Hi there


    Go into Power Query and remove the "Include in report refresh"

     

     

    If that does not work, copy the contents of your Excel file.

    Go into the Query Editor.

    Then click on "Enter Data"

    Press CTRL + V and click Ok

     

    Now you have got your data, which does not have any data sources associated to it.

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago

    Hi there


    Go into Power Query and remove the "Include in report refresh"

     

     

    If that does not work, copy the contents of your Excel file.

    Go into the Query Editor.

    Then click on "Enter Data"

    Press CTRL + V and click Ok

     

    Now you have got your data, which does not have any data sources associated to it.

    • CPL_HK's avatar
      CPL_HK
      Frequent Visitor
      6 years ago

      Thank you - I hardcopied it. Doesn't really make sense for me that I PowerBI service doesn't deactivate the refresh although this is done in PowerBI desktop, not sure if this is a bug. 

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi CPL_HK ,

    If your excel file is located locally, you must configure the gateway for it.

    In other words, you must configure the gateway for the local data source.

    So you can upload your excel file to the cloud, such as OneDrive / SharePoint.

    use-onedrive-business-links 

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.