Forum Discussion
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
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/guided-learning/modeling
Hope these links help!
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
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.
This will create a relationship that will look like this following.
You can now see muliple data sets in one view like below.
