Forum Discussion

SeanMoody's avatar
SeanMoody
Icon for Helper I rankHelper I
2 years ago

Connection String Window Greyed out and wont' let me edit it.

may 2024 report server version sets connection screen window to disabled.

Looking at the underlying SQL it shows that it is disabled:

<textarea autocomplete="off" name="datasource-connectionstring-input" class="form-control multiline-form-control ng-untouched ng-pristine ng-valid" id="datasource-connectionstring-input-0" placeholder="" disabled="true" style="height: 230px;"></textarea>

I could edit it in the January Version.  Is there a Fix for this?

"Power BI Report Server "

5 Replies

  • SeanMoody's avatar
    SeanMoody
    Icon for Helper I rankHelper I
    2 years ago

    Does this have anything to do with setting the Environment variable on the server to deal with the sql server encrypted connection and trusted server?

    PBI_SQL_TRUSTED_SERVERS

    <setting name="SqlTrustedServers" serializeAs="String">
    <value>udw*<value />
    </setting>

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, SeanMoody 

    In different connection modes, we may get the ability to edit the connection string or not:

     

    According to my tests, in the January version of Report Server, when we use SQL as the data source, we are not able to edit the connection string of the report, as you can see from the following image:

    We also saw in the May release that we can't edit the connection string:

    Currently, you can update the connection string for SQL using PowerShell via the official documentation:

    Change data source connection strings with PowerShell - Power BI | Microsoft Learn

    This method requires you to be proficient in using Power shell commands and then practice it.

    In addition, you can republish a PBIX file with a new connection string to Report Server through the Power BI desktop RS release.

     

     

    Best Regards

    Jianpeng Li

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

    • SeanMoody's avatar
      SeanMoody
      Icon for Helper I rankHelper I
      2 years ago

      Thanks, but the Powershell doesn't seem to work either as the WARNING: No XSRF Token detected! This might be due to XSRF token disabled. on the first line you try.  The only place you can edit connection strings is in a shared data source.  Its crazy to think you have to go into Power BI and then the datasource and then save it back to the server for each report.  This is very time consumming expecially with 3 environments.

       

      Get-RsRestItemDataModelParameters '/Finance/Financial Reporting/Power BI/FIFR-1200 - Yearly Salary and FTE'.