Forum Discussion

GellaiTamas's avatar
GellaiTamas
Helper I
9 years ago
Solved

Data source access fails by a data gateway

Hi everyone,   Before explaining the issue, please let me tell what I'm working on and what is the current system setup looks like.   I'd like to create Power BI reports from an SQL database and ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    GellaiTamas,

    Based on your screenshots, you haven't added the SQL Server database within the gateway. Please follow the instructions in this article to add your SQL data source under the gateway.

    Regards,

    Lydia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

GellaiTamas First check, make sure the connection strings match exactly. Second, you can check the gateway log files to see if there is a more specific error in them. Here is a link to the troubleshooting guide.

 

Installer logs

%localappdata%\Temp\On-premises_data_gateway_*.log

Configuration logs

%localappdata%\Microsoft\on-premises data gateway\GatewayConfigurator*.log

On-premises data gateway service logs

C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log
GellaiTamas's avatar
GellaiTamas
Helper I
9 years ago

Thanks, Anonymous, very useful info!