Forum Discussion

jland47's avatar
jland47
Frequent Visitor
1 year ago
Solved

SQL Sever Connection

I have a report that already has a connection to one SQL server (cloud based), I have this report saved on one drive and also published it, everythign is good.  Now I am trying to add another SQL con...
Dataflow
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi jland47 -Install the Power BI Gateway on a single, reliable machine within your local network that is always available. It does not need to be on all machines, only on one central or dedicated PC that has network access to your on-premises data sources and a stable connection to Power BI’s cloud services.

     

    Hope this helps 

jland47's avatar
jland47
Frequent Visitor
1 year ago

I thought it worked, the reports will allow me to publish with no errors now, but when I went to app.powerbi.com to view the reports I get an "Invalid connection creditianals error" with "An exception occured due to on premise service issue".  The visuals will not load now with the new SQL data I I connected too.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi jland47 

 

After you install an on-premises data gateway, you need add data sources(SQL Server) to use with the gateway.

In Power BI Services, open Settings and select "Manage connections and gateways", then click New Connection.

Please refer to the following link to learn how to add a SQL Server data source to your on-premises data gateway.

Manage a SQL Server data source - Power BI | Microsoft Learn

 

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.