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,

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

  • timsalch's avatar
    timsalch
    Regular Visitor
    9 years ago

    Thank you for your help Anonymous.

     

    It looks liek after i removed the query using the excel data source and re-uplaoded the data set, i now have an option for which gateway i want to use.  The old personal offline gateway is still there but i also have the on prem as an option to refresh the data soruce.  I switched it over and applied it it looks like refreshing is successful.  I put my schedule bakc on so hopefully the scheduled refresh goes through in the morning.

     

    EDIT:

    It works without the excel data source.  As soon as I add an Excel data source back and re-publish, it defaults to the personal gateway and i no longer ahve a choice to use the data gateway. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi timsalch,

    Where do you store the Excel file? If you store it in onedrive, you will be forced to use personal gateway when combining the Excel data source and SQL Server data source in a single dataset. Beacuse the on-premises gateway doesn't work with online data sources currently.

    Thanks,
    Lydia Zhang

  • timsalch's avatar
    timsalch
    Regular Visitor
    9 years ago

    Hello Anonymous,

     

    The excel file is on the same machine that is hosting the on prem gateway.   

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi timsalch,


    How do you add the Excel data source under on-premises gateway?

    Thanks,
    Lydia Zhang

  • timsalch's avatar
    timsalch
    Regular Visitor
    9 years ago

    Thank you once again Anonymous.  I had not added the file as a data source in the service yet.  I have added it, reuploaded and refresh is working now. I still cannot remove the gateway from the machine that no longer exists, however it shouldnt cause me any issues now either.

     

    Thank you for all of your help!