Forum Discussion

timsalch's avatar
timsalch
Regular Visitor
9 years ago
Solved

unable to remove offline gateway

I had a system set up as my gateway, however it encountered a failure and is no longer bootable.  A gateway was installed on a replacement machine as a new gateway instead of migrating.    Now my d...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi timsalch,

    In Power BI Desktop, please delete the Excel data source in your PBIX file, then republish it to Power BI Service. Then you should be able to use on-premises gateway to set schedule refresh for this dataset.

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi timsalch，

What is the data source in your dataset? Does your dataset contain other type of data sources except SQL Server data source?

Thanks,
Lydia Zhang

timsalch's avatar
timsalch
Regular Visitor
9 years ago

It does include a single excel file data source, however it is broken right now as the file was overwritten so I have disabled it in the refresh.  Anonymous

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi timsalch,

    In Power BI Desktop, please delete the Excel data source in your PBIX file, then republish it to Power BI Service. Then you should be able to use on-premises gateway to set schedule refresh for this dataset.

    Thanks,
    Lydia Zhang

    • timsalch's avatar
      timsalch
      Regular Visitor
      9 years ago

      Hello Anonymous,

       

      I did delete the Excel data source and deleted the query based off of it.  I then removed all data sets from PowerBI Service and reuploaded using Power BI Desktop.  The on-prem gateway shows online, however if I refresh the data set is still attempting to use the personal gateway.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi timsalch,

        Could you please post the screenshot that  you successfully set schedule refresh for the dataset using on-premises gateway? Do you get the above error when clicking "Refresh now"?

        Thanks,
        Lydia Zhang