some columns not shown up in "Transform Data"

bergen288 · ‎10-23-2024

There is a "key" column after "iidb.company.riskindicator.desc" in my fact table (screenshot 1) that is used to establish 1:1 or 1:many relationship with my descriptive tables. All fact and descriptive tables are in SQL DB and a Power BI report is published in Web Service site. There are a few times report refresh failed due to duplicate keys. I would like to remove duplicate keys from "Transform Data" tab. However, not all columns are shown up. As you can see in screenshot 2, there is no "key" column after "iidb.company.riskindicator.desc" in "Transform Data". In fact, all columns after "key" are not shown up. How to address it?

Thanks in advance.

Anonymous · ‎10-28-2024

Hi @bergen288 ,

It sounds like your problem has been solved? If it is resolved, please mark your reply as resolved, this will help more users with the same problem, if not please point it out.

Best Regards,

Neeko Tang

KNP · ‎10-23-2024

Not enough info to answer.

Can you post a screenshot of the steps in the query?

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.