Forum Discussion

FunDeckHermit's avatar
FunDeckHermit
Helper I
8 years ago
Solved

Direct Query, SQL-server 2012 publishing error

Hello everyone, I have a local machine running SQL-server 2012, Power-BI Desktop and the On-premises data gateway. They are all running under my personal user-account with local admin rights.   ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    FunDeckHermit,

    Go to Settings->Manage Gateways, add SQL Server data source within gateway following the guide in the article.


    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

FunDeckHermit,

What server name and database name do you use when adding the SQL data source within your gateway? Please make sure that the server name and database name are same as that you use in Power BI Desktop.

In addition, do you use "."  as server name in Power BI Desktop? Do you install gateway and SQL Server in a same machine?

Regards,
Lydia

FunDeckHermit's avatar
FunDeckHermit
Helper I
8 years ago

Hello Lydia, Anonymous

 

I use ServerName: .

And databasename: CompanyProduct nx Datalogger

 

These settings were used everywhere, power BI desktop, query builder and even the gateway.

With regards,

Roy

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    FunDeckHermit,

    Do you install gateway on the same machine that installing SQL Server? If not, please change your ServerName to machine name or IP address in your PBIX file and gateway.

    Regards,
    Lydia

    • FunDeckHermit's avatar
      FunDeckHermit
      Helper I
      8 years ago

      Anonymous

       

      Hello Lydia,

       

      I have changed the "." to the actual server-name. The error is still the same. 


      Everything is running on the same machine with name: BEE-LT-0400

      Everything is running on my user-account (local admin):

       

       

       

       

       

       

       

       

       

       

       

       

       

      The network might be restricted, is port 443 the only port needed?

      I am running in HTTPS-mode. 

       

      With regards,

      FunDeckHermit

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        FunDeckHermit,

        Could you please post the connection string you use to connect to SQL Server in gateway and Power BI Desktop?

        Regards,
        Lydia