Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

PowerBI RS / SSRS 2016 Rendering issue

In migrating reports from SSRS 2014 to SSRS 2016 / PowerBI RS, we have some reports with text that renders fine in SSRS 2014 but is hidden in SSRS 2016.  However when downloaded to Excel, the text ap...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

FYI - I upgrade my reporting enviroment to SP2 CU5 and this still persists to be a problem.  

rpatkar's avatar
rpatkar
Power BI Team
8 years ago

hi,

 

For the reports attached, they are still using "shared data sources" and so I cannot render them locally. You can repro this by uploading those reports to your server and trying to render them without making any other changes. Can you please attach the ones with the local data source you mentioned earlier that can be rendered without any changes? Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Edit the report and change the data source "DataSource1" to point to your own SQL Server. 

    The SQL in DataSet1 doesn't require a table on your server.  But you do have to have a SQL Server to execute the statement.  

     

    • rpatkar's avatar
      rpatkar
      Power BI Team
      8 years ago

      Thanks, I can repro and can see the cause of the issue now. We'll need to do a bit more investigation however on the desired behavior. Do you have a link to the bug you opened at https://connect.microsoft.com/SQLServer?

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi, here is the link 3142881.   

         

        I tried several times to upload these files to that site but they never appeared as part of this ticket.  But at least you have the files here.  

         

        The desired behavior is that the text in the second column displays (see the other file "ARenderWorks.rdl" for the proper behavior).  

        Also, as I stated the problem appears when there is a mixed state of "can grow" properties on a single row.  If all "can grow" properties are the same (true or false) then the rendering works.