cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
d0__ob Frequent Visitor
Frequent Visitor

Trying to format web queries into table

Hi there, I just started trying out power BI.

 

My aim is to try and create a dashboard of sorts to monitor the review scores and rank of a list of 5 restaurants from different websites (facebook, tripadvisor etc).

 

I've managed to pull out the individual datapoints via web query (going through all the divs and spans and so on.

 

However, I am not sure how to arrange the data nicely into a table in Power BI. For excel, I just have to "put" the data into a particular cell. I tried apending data, but I can only make a column at a time, say, Restaurant Name, or Facebook Review Score. However, if I try to append the two tables, it would look something like this.

 

Name                  FB Score

Restaurant 1        (Null)

Restaurant 2        (Null)

                             4.5

                             4.6

 

As opposed to

 

Name                  FB Score

Restaurant 1        4.5

Restaurant 2        4.6

 

I would like to add multiple columns with different matrics. Could someone guide me to a tutorial to show me how to manually place these data points in place? Thank you very much!

3 REPLIES 3

Re: Trying to format web queries into table

Hi @d0__ob,

 

You should create a relationship between the data this will help you achieve what you are trying to accomplish.

 

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships#create-a-relations...

 

https://docs.microsoft.com/en-us/power-bi/guided-learning/modeling

 

Hope these links help!

v-jiascu-msft Super Contributor
Super Contributor

Re: Trying to format web queries into table

Hi @d0__ob,

 

How about the function Merge? Do you mean one column a table? How can they be connected? For example, Restaurant 1 could be a pair of 4.5 or 4.6. Can you share a sample?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Trying to format web queries into table

If you want to join data from 2 sources then as described you can create a relation between the objects.

 

From the Relationship view you will drag the field who's relationship you are creating from Table1 with the matching field in the Table2.

Relation1.png
This will create a relationship that will look like this following.

 

Relation2.png
You can now see muliple data sets in one view like below.
Relation3.png

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 5 members 2,188 guests
Please welcome our newest community members: