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.

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.