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

[KarthigaM22]

@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.

Regards,

Karthiga

[KarthigaM22]

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

Am I missing anything? can you please guide me?

Thanks,

Karthiga

[v-zhengdxu-msft]

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.