Forum Discussion

flem81's avatar
flem81
Frequent Visitor
2 years ago
Solved

Issues regarding power bi report server

Hi We have two issues regarding power bi report server. 1st. After updating to the latest version (Maj update), our reports using direct query does not work. Error messages “we could not conn...
Paginated Report
Power BI Report Server
Sunburst
Petebro's avatar
Petebro
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

I'll confirm the details and update the respected docs but I think any value works (the presense of the environment var is all that it cares about). Running the command from a cmd prompt with admin rights will work:

 

setx PBI_SQL_TRUSTED_SERVERS 1

Giuseppe_Aino's avatar
Giuseppe_Aino
Icon for Advocate II rankAdvocate II
1 year ago

I've solved using a tips from medium.com .

My connection string use:

serverName\Instance,1234

I've used the "*" as a jolly to trust every server... it's not a beatiful idea, especially for safety, but it works .... (for the moment)

 

So the setup was:

setx PBI_SQL_TRUSTED_SERVERS * /M