Forum Discussion
Creating a new Table for Attributes
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
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
3 Replies
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
Here's a screen shot of the data provided by the state ... just trying to add attributes/descriptions to each restaurant.
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
