Forum Discussion

DataVitalizer's avatar
DataVitalizer
Icon for Super User rankSuper User
5 years ago
Solved

How to keep published reports updated

Hi Community, I have an on-premise sql server with couple databases which are consumed by many users throught different reports.   Now I am supposed to configure a gateway to allow those users con...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi DataVitalizer 

    In this scenario, please check the service log for Enterprise Gateway under:

     

    C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log

     

    Also check the the On-premises data gateway service  event log under Application and Services Logs in Event Viewer.

     

    If there's still no usefull message in log, please uninstall gateway and install the latest version of Enterprise Gateway. Please see: Troubleshooting the On-Premises Data Gateway

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

DataVitalizer's avatar
DataVitalizer
Icon for Super User rankSuper User
5 years ago

Hi selimovd 

I tried to install the entreprise gateway, when I try connecting I get this error message

One or more errors occurred
System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.ConfiguratorClientExtensions.<GetClusterUri>d__0.MoveNext()

I used an account with pro license, and the installation was on win10

 

Thank you in advance.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi DataVitalizer 

Difference between standard mode and personal mode:

For reference: On-premises data gateway vs. on-premises data gateway (personal mode)

 

Please refer to requirements from this blog before you download gateway.

Please download the latest standard mode gateway by this link: Power BI gateway

For more details about how to download standard mode gateway, you may refer to this blog:

Download and install a standard gateway

For reference about how to manage your data source-SQL.

Once you configure your data source correctly in Service, you can set schedule refresh for your report. Then your report can be auto refreshed. Note: You need to keep the PC which has data source-SQL and installed gateway online, or refresh will fail.

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

 

 

 

 

  • DataVitalizer's avatar
    DataVitalizer
    Icon for Super User rankSuper User
    5 years ago

    Hi selimovd , Anonymous 

    I installed this time the Enterprise Gateway on WS2016 with SSD and .Net Framework 4.8, even though, I am getting this error messages when I try to login

     

    Thank you in advance.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi DataVitalizer 

      In this scenario, please check the service log for Enterprise Gateway under:

       

      C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log

       

      Also check the the On-premises data gateway service  event log under Application and Services Logs in Event Viewer.

       

      If there's still no usefull message in log, please uninstall gateway and install the latest version of Enterprise Gateway. Please see: Troubleshooting the On-Premises Data Gateway

       

      Best Regards,

      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.