Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
KarthigaM22
Frequent Visitor

Report Builder - XSLT DataTransform is not working to tranform XML into desired format during export

@PowerBI @DataInsights @ReportBuilder07 

I have requirement where I need to generate XML output in a desired format from Power BI paginated report. 

I have place tablix on the report and then yes, I can export as xml but this xml doesnt match the tags / schema what I needed.

I can do this using DataElement properties but same not working using XSLT file in DataTransform property.

If anyone has any suggestions on this, it will be big help.

 

KarthigaM22_0-1715940596587.png

KarthigaM22_1-1715940615735.png

KarthigaM22_2-1715940662516.png

 

Regards,

Karthiga

2 REPLIES 2
KarthigaM22
Frequent Visitor

Thanks for you response @v-zhengdxu-msft !

 

Is deviceinfo settings mandatory? I am not getting where exactly settings related to this has to be specified in .rdl file. I have looked at all the properties in rdl but no luck.

is it something to do with report server config file?

 

I have figured it out that we should be specifying with prefix rdl:<properties>, I have been trying with rs: as prefix

But still no luck, I am getting same even with specified namespace in XSLT file. I have tested with XSLT translator, it is working fine..

 

https://app.powerbig/groups/<>/rdlreports/<>?rp:CD=03&rdl:format=XML&rdl:UseFormattedValues=true&rdl:Indented=true&rdl:OmitNamespace=false&rdl:OmitSchema=false&rdl:Encoding=UTF-8&rdl:FileExtension=XML

 

 

KarthigaM22_0-1716207071099.png

KarthigaM22_2-1716207101648.png

KarthigaM22_3-1716207262823.png

 

Am I missing anything? can you please guide me?

 

 


Thanks,

Karthiga

v-zhengdxu-msft
Community Support
Community Support

Hi @KarthigaM22 

 

Here are a few steps and considerations to ensure your XSLT transformation is set up correctly:

 

Ensure that your XSLT file is correctly formatted and capable of transforming your XML output into the desired format. It might be helpful to test your XSLT file with a simple XML editor or an online tool to confirm it works as expected.

Double-check that the DataTransform property in your report definition file (.rdl) is correctly pointing to your XSLT file.

Export Power BI paginated report to XML (Power BI Report Builder) - Power BI | Microsoft Learn

When specifying an XSLT file through the DeviceInfo settings, remember that the transformation specified in the DataTransform property occurs first, followed by the transformation set by the DeviceInfo settings. Ensure there's no conflict between these two that might cause the output to deviate from your expected schema.

XML device information settings for Power BI paginated reports - Power BI | Microsoft Learn

 

Best Regards

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.