Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I need to display a table in a text box in my paginated report. I mean, the field I'm pulling from the dataset (rich text type) is a table like this:
I used the placeholder property "HTMl - Interpret HTML tags as styles", it keeps some HTML format but doesn't create the table.
Is there any way to make this possible in Power BI Builder? I saw that it is using Power BI Desktop with HTML content visuals, but I don't see anything like that in Power BI Builder.
Thank you!
Solved! Go to Solution.
Hi mcantos,
1. Create a Report Builder (rdl) file with table as per your requirement
and publish it to the server with a name, for instance, "Requirement".
2. In a new report builder file add a table.
3. Select a cell of the table, right click on it. Then select Insert>> subreport.
4. Right click on <subreport> in the cell>> select sub report properties>> Under "Use this report as sub report" - Browse and select "Requirement">>Click on OK.
5. Again, select the requirement sub report in the cell>>select subreport properties>>If you need any parameters then set parameters, else skip this step.
6. If not required delete other cells of the table. A textbox with a table inserted is available for you.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much @KVRKarthik It worked!
Now I have a problem while creating the table in the subreport, but I think that would be another topic.
Cheers!
Hi mcantos,
1. Create a Report Builder (rdl) file with table as per your requirement
and publish it to the server with a name, for instance, "Requirement".
2. In a new report builder file add a table.
3. Select a cell of the table, right click on it. Then select Insert>> subreport.
4. Right click on <subreport> in the cell>> select sub report properties>> Under "Use this report as sub report" - Browse and select "Requirement">>Click on OK.
5. Again, select the requirement sub report in the cell>>select subreport properties>>If you need any parameters then set parameters, else skip this step.
6. If not required delete other cells of the table. A textbox with a table inserted is available for you.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@KVRKarthik ,
I'm also facing the same issue. But, The proposed solution is not working.
Hello @Sairam_V , please create a new post with your question instead of replying to a post almost a year old and already has an Accepted Solution.
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you. Proud to be a Super User!
Ok Sure
User | Count |
---|---|
3 | |
3 | |
2 | |
2 | |
1 |
User | Count |
---|---|
9 | |
4 | |
4 | |
3 | |
3 |