Forum Discussion
SVG Calculated Columns in Power BI Table Visual β Export Shows Raw SVG URL Instead of Data Value
Hi subu_das,
This is a core design limitations of Power BI. While in Power BI it renders and generates the SVG image but while you download it's downloaded text hence images are conerted to text instead of images.
What you can do it by instead of providing the download option (Disable header Icons) on the main table (Which is using SVG images), you can provide a toggle or a button which can change the visual to a downloadable version (Using Bookmarks). in this downloadable table replce the column (SVG images) with some other column (Status) which has text, and then user can downlaod it from there with correct statuses.
π I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
π‘ Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
π As a proud SuperUser and Microsoft Partner, weβre here to empower your data journey and the Power BI Community at large.
π Curious to explore more? [Discover here].
Letβs keep building smarter solutions together!Thanks i have submitted an idea to Power BI.
Hello grazitti_sapna,
Thanks for your response.
If we create a bookmark for export then a user needs to click on the bookmark (Export) and then on ... dots and click export option. Are you suggesting to use this option or is there a way where if click export bookmark the file gets exported to excel?
Hi subu_das,
One way is doing that once the user hits the toggle the other table gets unhidden and user can download the table by clicking on ... option.
Another way is that you can create an export button, as soon as the user hits it the file is downloaded either to sharepoint/onedrive or any other shared location using Power automate, also you can automate in such a way that the user recieves the table on their email as .csv/excel attachment.
Refer this video
Hello grazitti_sapna,
I have worked on Power Automate flow the issue with PA is that when a user click on the export button (PA) a file is created and saved on sharepoint/ one drive and later sent via email. Ok for CSV but issue with excel is every row is considered as an action and for 2000 rows it takes 1 hours to just update the file.
I was looking for user convenience which is not possible currently and they are used to default export data which they use in other reports.Hi subu_das,
That's true, 1 row = 1 api call, so you only have the option to save/send that on a sharepoint location or over email as .csv
Or the other Option where they can download using ... from table menu by clicking download button.
alternatively add both column in your original table SVG and status column in the same table and ask users to ignore SVG column.