Forum Discussion

eppe2000's avatar
eppe2000
Frequent Visitor
7 years ago
Solved

Schedule Refresh doesn't work because of port issues

Hi,   I created a report using a SQL Server data source with a SQL Statement (just a normal SQL query on one table, set in the advaced settings under 'SQL Statement') in Power BI Desktop. To connec...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    eppe2000,

    We should use servername,port as server in Power BI Desktop to connect to SQL database, I can successfully connect to SQL using this format with SQL statement.



    How about you open a new PBIX file, delete the existing SQL permissions and reconnect to SQL Server ?


    Regards,

    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

eppe2000,

We should use servername,port as server in Power BI Desktop to connect to SQL database, I can successfully connect to SQL using this format with SQL statement.



How about you open a new PBIX file, delete the existing SQL permissions and reconnect to SQL Server ?


Regards,

Lydia

  • eppe2000's avatar
    eppe2000
    Frequent Visitor
    7 years ago

     Deleting the existing permissions and reconnect to the SQL Server using a comma worked. Thanks! 

  • omersorhun's avatar
    omersorhun
    Frequent Visitor
    3 years ago

    Hello,
    I have the exact same issue but the solution you provided does not work for me. I simply can not use the format "servername,port" to connect to an SQL Server Database in Power BI Desktop. And I can not use semicolon while creating the gateway, so I can not use the gateway to refresh the dataset of my report. Does your solution not work in new Power BI versions?

     

    • omersorhun's avatar
      omersorhun
      Frequent Visitor
      3 years ago

      I was able to resolve the issue by assigning an alias to my "server,port" in SQL Server Management Studio on the same machine where I designed the report and created the gateway. This allowed me to use the alias as the server name in both Power BI Desktop and when creating the gateway connection, thus ensuring consistency and avoiding the previous issues with differing formats.