how to get data from app rather than home, element, table tag?

[AnandRanga]

I am tryingh to get data from this  api:

http://api.twitter.com/1/users/show.xml?screen_name=geekygirldawn

I am using get data> web option but i am getting this as data:

and then i am clicking on the arrow icon:

then also it's not showing  the data and showing this:

It's not showing the data and showing html tags!! Where i am doing mistake ? 

I also read somewhere that go to Transform tab in edit query and use convert to table option but I am not getting that option where this option is in transform?

Thanks for your time.

[v-shex-msft]

Hi @AnandRanga,

>>I also read somewhere that go to Transform tab in edit query and use convert to table option but I am not getting that option 

I think the tables which stored in "Children" column contain other tables in its columns. Maybe you can expand these tables again.

Regards,

Xiaoxin Sheng

[Anonymous]

@AnandRanga,

You may also have problems with the API you are using.  In my tests in a browser, I get this error "The Twitter REST API v1 is no longer active. Please migrate to API v1.1. https://dev.twitter.com/docs/api/1.1/overview."

There is a good example of Power BI access to Twitter using v1.1 of their Search API at http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/

[AnandRanga]

I am tryingh to get data from this  api:

http://api.twitter.com/1/users/show.xml?screen_name=geekygirldawn

I am using get data> web option but i am getting this as data:

and then i am clicking on the arrow icon:

then also it's not showing  the data and showing this:

It's not showing the data and showing html tags!! Where i am doing mistake ? 

I also read somewhere that go to Transform tab in edit query and use convert to table option but I am not getting that option where this option is in transform?

Thanks for your time.