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.

 

 

FabienLeal's avatar
FabienLeal
New Member
10 years ago

Hi,

 

Thanks for your help, but on my side I'm still facing some troubles and data does not get refreshed.

When you say "local SQL Server", does it mean I need to install the designer on the server?

 

Currently I've installed the Enterprise Gateway on the SQL Server but the designer is installed on my laptop, from where I publish the reports.

 

Regards,

Fabien

  • roedeske's avatar
    roedeske
    Advocate I
    10 years ago

    Dear Fabien,

     

    so I understood and is the way it is working for me. I see the same "problem" to have the designer installed on the source SQL server, but yeah product still in progress and we look forward.

     

    Regards,

    Michael