Forum Discussion
Power Query Editor - What column and Data Type is it?
Good morning
I have few notions for reporting with Power BI.
I am doing a report in power bi and I am comparing it with another report that is already done.
The problem is that there is a field, which I do not know where it gets it because in the table it does not exist.
I'm with the Power Query editor and I don't know how it got that column (REF_Delegación) because it doesn't exist in the table.
The field that I would like to know how he has achieved it is REF_Delegación and I do not know what the icon next to the
REF_Delegación. What kind of field is it and how can I get it to add it to the query?
Thank you for your help.
Best regards.
It looks to me like you're connecting to a relational database.
Power Bi is detecting that a related table exists and puts that in a column. If you click the icon at the top you can expand the table and select columns from the related table.
2 Replies
Clicking on the icon, it shows me which is the table that is being related.
That was my doubt.
Thank you very much for the quick response.
Greetings.
It looks to me like you're connecting to a relational database.
Power Bi is detecting that a related table exists and puts that in a column. If you click the icon at the top you can expand the table and select columns from the related table.
