cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wilson_smyth Helper V
Helper V

PowerBI imports additional data not in table as expandable "table" column

Im importing data via sql database.

I select  2 tables, a dimension table and a fact table.

 

Each table is imported, but each table inlucdes a "table" column that i can expand that looks like it contains the data from the related tables.

 

the fact table even has a table column containing data from other related tables i did not import, which means its importing all data related to the fact table.

 

Is this the data actually imported multiple times or is it just represnting a relationship?

If so, it seems very wasteful.

 

1 REPLY 1
Community Support
Community Support

Re: PowerBI imports additional data not in table as expandable "table" column

 Hi @wilson_smyth

 

As referred, the dataset shows a set of columns that contain oddly colored values called Table and Value in Query Editor ,Query Editor provides this information to point you to data related in other tables in the source data. However, this information does not show up in your final dataset.

If you don’t want to get related information, you can cancel selection of option “Include relationship columns” which is selected by default.

 

56.png

 

Best Regards

Maggie

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors