Creating a new Table for Attributes

[AaronGlenn10]

Power BI All Stars:

I have a dataset that I sync monthly through a government provided ODATA feed - the data is comprised of all restaurants in the state and how much they pay in sales taxes.  I would like to add some attributes to the data - speciifcally square feet of each restaurant and the type of each restaurant [e.g., Italian].  Each restaurant has a unique id ... how would I create the new attribute table and form a relationship with the existing restaurant table?

Thank you!

~AGS

[amitchandak]

@AaronGlenn10 , Not very clear.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

refer 4 ways to copy data from one table to another

https://www.youtube.com/watch?v=Wu1mWxR23jU

https://www.youtube.com/watch?v=czNHt7UXIe8

[AaronGlenn10]

Here's a screen shot of the data provided by the state ... just trying to add attributes/descriptions to each restaurant.

[Anonymous · Accepted solution]

HI @AaronGlenn10,

How many fields this fact table stored? If they already include a few fields, you can consider extract the unique field value and expanded with attribute and value. Then you can use that unique field to link raw table records.

Notice: do not attach sensitive data in your sample data or snapshots.
Regards,

Xiaoxin Sheng