Forum Discussion

amsrivas's avatar
amsrivas
Helper IV
5 years ago
Solved

Power BI Dataset refresh option disabled

Hi FOlks!!

 

I have created report for which source is web URL - Azure status

Once i have published the report to POwer BI Services, and refreshed the dataset manually it throws below error

Also, Data Source Credentials and Schedule Refresh are disabled.

 

Please suggest Why Data Source Credentials and Schedule Refresh are disabled and how to refresh the dataset and schedule the refesh.

 

Thanks

Amit

  • aj1973's avatar
    aj1973
    5 years ago

    No problem,

    To make it simple to understand : in Power Bi desktop you connect to the URL via Web connector "API" that comes with Power Bi package. Once you publish the report to the service, the service itself will need a way to connect and refresh the datat. The Gateway is here for that purpose : connect and refresh the report in the service.

    Take a look here it might help you understand better

    https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem

     

6 Replies

  • amsrivas , First of all, open the gateway and check for any error. If you need a gateway, make sure there is no error there.

  • aj1973's avatar
    aj1973
    Community Champion

    Hi amsrivas 

    I tried the URL and the refresh is working fine using my personal Gateway installed in my computer.

    Use ananymous as credential in the desktop and the service.

     

    • amsrivas's avatar
      amsrivas
      Helper IV

      Hi aj1973 ,

      I am newbie to the Power BI and might be question did sound funny.

      Why do we need to install Gateway, whay would we need that.

       

      Thanks

      Amit Srivastava

      • aj1973's avatar
        aj1973
        Community Champion

        No problem,

        To make it simple to understand : in Power Bi desktop you connect to the URL via Web connector "API" that comes with Power Bi package. Once you publish the report to the service, the service itself will need a way to connect and refresh the datat. The Gateway is here for that purpose : connect and refresh the report in the service.

        Take a look here it might help you understand better

        https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem