Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Question regarding Gateway

Hi all We build a “Gateway Cluster” (with one Gateway) pointing to a SQL DB in another Azure subscription (the connection is successful!)   We want to connect a PowerBI report “Data Set” to this g...
Gateways
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Yes, I created the Gateway pointing to a MS SQL DB (2014) and the connection was successful (I saw it was ok via the "Managed GateWays" option), but the problem remain as I can't connect the data set to the gateway

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi Anonymous,

 

Please open the report in desktop, go to Data Source Settings, check is there any other data source used in the report except the SQL database. 

 

 

All data sources found in the Data source settings above needs to be created in Manage Gateways section on Power BI service. Ensure the connection information eg: server name, database name are the exact same. See: https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql

 

Best Regards,
Qiuyun Yu 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Yes, done all that, and I followed the steps in the doc, but the problem remain.

     

    locally i can refresh the report/ data set successfuly.

    After uploading it to the PowerBI web site  the refresh failed (I re created all the steps for a new source also)

     

    1.  where are the detailed logs?
    2. the problem is in the Gateway config in the server? or is it in the "Gateway Nanagment" screen?
    3. maybe firewall issue between the gateway and the site?

    thanks

     

     

    Something went wrong

     

    Cannot connect to the server.
    Please try again later or contact support. If you contact support, please provide these details.
    Activity ID71bf6286-44e5-48e9-a711-b41f5f0bf1e1
    Request IDaa44a2f9-0d47-66a3-980a-dc4dc9952a06
    Correlation ID84f4bf1e-e916-d90c-b6bf-4ae12498a108
    TimeTue May 22 2018 16:44:19 GMT+0300 (Jerusalem Daylight Time)
    Version13.0.5391.159
    Cluster URIhttps://wabi-west-europe-redirect.analysis.windows.net