cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gangula Regular Visitor
Regular Visitor

XML mapping works different in Power BI and Excel

I have used XML mapping to count the number of issues I have currently. But when I try to do the same process in Power BI, it doesn't work properly. I don't know where I'm going wrong. Can someone help me with this? The following image shows the differences between data imported through XML mapping and Query editor

 

2018-01-01_11-42-08.pngExcel vs Power BI

 

 

 

 

3 REPLIES 3
Moderator v-caliao-msft
Moderator

Re: XML mapping works different in Power BI and Excel

@Gangula,

 

From XML data source, please refer to the links which describes how to get data from XML data source step by step, anc chek if you have anything missed or not.

http://www.sqlservercentral.com/blogs/data-adventures/2017/08/08/data-modeling-in-power-bi-using-xml...
https://www.youtube.com/watch?v=uH-4BpjMWUY

 

Regards,

Charlie Liao

Gangula Regular Visitor
Regular Visitor

Re: XML mapping works different in Power BI and Excel

Hey @v-caliao-msft

 

The webpage link that you've provided seems to be having the solution that I need, but for some reason, I cant see the images embedded into the webpage. I've tried opening it in various browsers but still was unsuccessful in viewing the images. 

 

Is it the same case with you too? If not can you please help me by downloading the webpage into HTML file and sharing. I really need to understand this. The video you've provided doesn't show a similar example as in my case.

Gangula Regular Visitor
Regular Visitor

Re: XML mapping works different in Power BI and Excel

Nevermind, got it