Column Overlapping/Data Showing Inaccurate in Power BI – RDL/Paginated Report

Column Overlapping: The issue is pretty common in Power BI service. When we have multiple column and rows in rdl/paginated report then we get this below kind of inaccurate data or overlapping of rows or column.

About Preview Feature:

This is new functionality which is introduced to give better improvement and performance in the Power BI service, but somehow it doesn’t work in some cases. There are many bug/limitations when the “Preview Feature” is enabled.

Note: By default, the “Preview Feature” will be enabled if you have not made any changes in the toggle/menu bar.

For more details refer: https://learn.microsoft.com/en-us/power-bi/consumer/end-user-preview-features

Problem Scope:

As you can see in this below image, I have one paginated report and when I run this report in power bi service and scroll towards right of this report, then I will get this column overlapping issue/text overlapping.

Column Overlapping

Resolution for Column Overlapping:

Workaround 1: Since this is paginated report, I will try to run this report in PBIRS (Power BI Report Server) or SSRS (SQL Server Reporting Services). Also, you can render this report in “MS Report Builder” OR “Power BI Report Builder” if you don’t use PBIRS/SSRS in your machine.

This is to make sure that we don’t have any problem or issue in the report. If you are sure that that rdl/paginated report is completely working fine then you can move to 2nd workaround.

As you can see in my case that when I run this report in Report Builder, it works fine without any problem or issue.

Column Overlapping
Note: Details are hided because of confidentiality, but by seeing both the image you can find the comparison between the column overlapping.

Workaround 2: Now we will disable the “Preview Feature” and check the behaviour in power BI service. To disable the “Preview Feature” please follow the below steps:

Open the report and go to “File” option as shown in the below image, once you click on file you will find “Disable Preview Feature” Click on that to disable the preview feature to make your report work fine without any issue.

Column Overlapping

Once you will “Disable Preview Feature” option and re-render the report it will work without any issue

Column Overlapping

Workaround 3: The other workaround for this issue you can follow the below steps from Power BI Report Builder and publish back to the Power BI Service to check the behaviour.

Step 1: Open the report in report builder and you can see that I have selected the first column to perform the task.

image

Step 2: Click on the column groups drop down arrow to click Advance mode.

image 2

Step 3: Click on the static to show column properties at right side pane and change the FixedData option to False.

image 3

Step 4: Please repeat the step 3 for all the remaining columns(static) which are available at column groups.

Step 5: Save the report and publish back to the Power BI Service and check the behavior and let us know the update.

Remember/Caution:

  1. Once you disable the “Preview Feature” this will create a browser backup in the backend and will be disabled for upcoming 30 days. But after 1 month it will enable automatically so again you have to disable it.
  2. Microsoft is actively working on this “Preview Feature” option and will definitely come up with solutions/fix for this issue.
  3. The “Preview Feature” is not applicable or available for PBIRS (Power BI Report Server).
  4. The  “Preview Feature” is not applicable or available MS Report Builder/ Power BI Report Builder.
  5. This  “Preview Feature” is not dependent on any kind of data source in Power BI Service.

SQL Bi Links:

  1. Port Number For Analysis Services – Find Ports For SSAS? (kingfishertechtips.in)
  2. RS.exe Utility: Migrate RDL Reports To Another SSRS/PBIRS (kingfishertechtips.in)
  3. Direct Query Mode ON In Tabular Model Issue – Visual Studio (kingfishertechtips.in)
  4. SMTP Server In SSRS/PBIRS |Subscribe To Email Problem/Issue (kingfishertechtips.in)
  5. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  6. Creating Tabular Project & Deploy Model To Analysis Service (kingfishertechtips.in)
  7. Deploy Tabular Project To Azure Analysis Service – SSDT Tool (kingfishertechtips.in)
  8. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  9. Could Not Load Folder Contents In Portal URLs – SSRSPBIRS (kingfishertechtips.in)
  10. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  11. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  12. Capture Fiddler Trace for Debugging the Network Traffic (kingfishertechtips.in)
  13. On-Premises Gateway: Configure/Map SQL DB To Power Bi (kingfishertechtips.in)
  14. Fixed Column/Row Header Make Visible In Any Report (kingfishertechtips.in)
  15. Self-Signed Certificate: Configure SSRS/PBIRS With SSL (kingfishertechtips.in)
  16. Create Local User Account/Local Admin User In Windows 10/11 (kingfishertechtips.in)
  17. Login With AAD/Domain/Microsoft Account To Azure VM’s/RDP (kingfishertechtips.in)
Vickey Rajpoot
Vickey Rajpoot

Hello there! I'm dedicated Microsoft Data & AI Engineer at LTIMindtree, where I thrive technology into actionable insights. Dive into my world by visiting my YouTube channel & Webiste, "Kingfisher Tech Tips".

Articles: 112

Leave a Reply

Your email address will not be published. Required fields are marked *