cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AnandRanga Member
Member

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

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:

a.jpg

and then i am clicking on the arrow icon:

c.jpg

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

2.jpg

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.

3 REPLIES 3
AnandRanga Member
Member

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

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:

a.jpg

and then i am clicking on the arrow icon:

c.jpg

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

2.jpg

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.

Community Support Team
Community Support Team

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

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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Steve_Wheeler Established Member
Established Member

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

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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)