Forum Discussion

PremK's avatar
PremK
Resolver I
2 years ago
Solved

EMERGENCY || Unable to connect SQL server with PBI

Kindly could you assist me in connecting SQL Server with PBI. Pioneer Rx ( a pharmacy software ) which uses SQL Server as Data base. i have to connect this with PBI for reporting. I had connected...
Need Help
  • PremK's avatar
    PremK
    2 years ago

    Thanks to everyone who tryied to give solution for this error.
    I resolved this issue through 2 steps > 
    1. Adding / Editing Environment Variable  - the variable name should be Name of the SQL Server.
    2. Updating PBI Desktop Config file in this path
    C:\Users\<YourUsername>\AppData\Local\Microsoft\Power BI Desktop\User.zip
    updating this - <setting name="SqlTrustedServers" serializeAs="String"> <value>NAMES OF YOUR SQL SERVERS </value> </setting>

PremK's avatar
PremK
Resolver I
2 years ago

Thanks to everyone who tryied to give solution for this error.
I resolved this issue through 2 steps > 
1. Adding / Editing Environment Variable  - the variable name should be Name of the SQL Server.
2. Updating PBI Desktop Config file in this path
C:\Users\<YourUsername>\AppData\Local\Microsoft\Power BI Desktop\User.zip
updating this - <setting name="SqlTrustedServers" serializeAs="String"> <value>NAMES OF YOUR SQL SERVERS </value> </setting>