Forum Discussion

roedeske's avatar
roedeske
Advocate I
10 years ago
Solved

How to use Enterprise Gateway (SQL) Datasource within Designer?

Hi there,   I installed the latest Enterprise Gateway for SQL on-prem, I create a Gateway and setup a Datasource. Copnnection is telling status ok, and now the big question, how do I connect to tha...
Need Help
  • roedeske's avatar
    roedeske
    10 years ago

    Hi together,

     

    I tried as you were telling and had success. It's just so simple.

     

    1. Install Enterprise Gateway

    2. Setup Gateway

    3. Connect within local Designer to local SQL Server source

    4. Choose DirectConnect

    5. Create report

    6. Publish report

    7. Open Report in PowerBI ... the Gateway just got used, no configuration needed, it seems that just all gets routed by teh gateway.

     

     

roedeske's avatar
roedeske
Advocate I
10 years ago

Hi together,

 

I tried as you were telling and had success. It's just so simple.

 

1. Install Enterprise Gateway

2. Setup Gateway

3. Connect within local Designer to local SQL Server source

4. Choose DirectConnect

5. Create report

6. Publish report

7. Open Report in PowerBI ... the Gateway just got used, no configuration needed, it seems that just all gets routed by teh gateway.

 

 

Lourens's avatar
Lourens
New Member
10 years ago

Where do you reference the Gateway and/or Datasource you create under the Gateway?

 

For Step 3 is the "local SQL Server source" the actual name of the SQL Server?

 

For Step 4 did you meant to type DirectQuery versus DirectConnect?