Importing XML file in Power BI

[Praveengkumarer]

Hi Experts

am able to open the XML in Excel, but when am importing this file in Power BI, am getting the schemas, and styles are showing but not the direct data,

Could you please help in importing the XML data to Power BI

Regards

Praveen G

[Anonymous]

I am experiencing the same issue as the original poster. Has anyone found a way to resolve it? I would appreciate any help or guidance on this matter. Thank you.

[pradeep_kare12]

Ensure that the XML file is well-formed and adheres to a schema that Power BI can understand. While importing XML data into power bi, you should use the XML data source option.Make sure you select the correct xml file and set up the import option correctly. Also, you may need to configure that data import settings for your XML file. Ensure that the columns you want to import are selected. After importing data check in the power query editor, use the preview option to see a sample of the data that will be imported. This can help you verify that the data is being read correctly. Also, check the data privacy settings in power bi, sometimes overly strict privacy settings can prevent data from being imported.

[Praveengkumarer]

Hi Pradeep, 

The system generates from the system and is placed in a  folder.

Power BI needs to pick the file and process it, But when I try to pick the XML file am get the error.

Could you please help,

[Sandhya1234]

@Praveengkumarer Power Bi Desktop >  Get data > XML > Connect

Select file > Open

Select & Load

[Praveengkumarer]

Thanks for the detailed step, but the probelm in my XML file is loading multiple options to check.