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.

 

 

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Yes, I verified this as well.

 

This should definitely be added to the documentation as it is not obvious this is how the Gateway works.

 

 

Also, be aware - the gateway uses its credentials to connect to the data source, ignoring whatever you've got set in your desktop file, so if you have any sort of row-level security / dynamic view this might become an issue. This is expected behavior of course, but stlil something to take note of.