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...
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.

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.