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.

     

     

ricamiller's avatar
ricamiller
Frequent Visitor
10 years ago

Hi there,

 

I also tried this and it does NOT work.

 

I am on my Azure VM with my MS SQL Server in Power BI Desktop.

 

I connected to my SQL Server on my Azure VM.

 

I saved the report.

 

I published to my Power BI account.

 

I get an error message that says this:

 

 

I have the enterprise gateway setup on my Azure VM.

 

SSAS works as expected and is easy.

 

All I do is click on Get Data, "Import of Connect to Data" Databases, SQL Server Analysis Services, and select my SSAS tabular models that are defined on my Enterprise Gateway - easy.

 

Why doesn't it work the same for SQL Server? For me it doesn't work at all.

 

Thanks,

Ric

sdrevik's avatar
sdrevik
Frequent Visitor
7 years ago

Just updating this- I have the same issue.   The connection string to SQL seems "locked in" at step 1 in the designer ("Get Data"), and there doesn't seem to be anyway to re-key the connection string to a gateway other than on the SAME MACHINE you are running the designer on.   Which seems seriously stupid to me.    How can a consultant design a dashboard for a customer, without saying "oh, hey, you need to give me admin access to your database server, so I can load this design program, and I'm gonna RDT into that server for a few days to build your dashboards.   That's not a problem, is it?"    #WTF