Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I changed one column name in power query from EMP_TYPE_DESC to "Emp.Type" make my visual table header clean.
But after changing that , when i refreshed, I got error in query saying the "EMP_TYPE_DESC " doesnot found.
So I went to query errors & changed the MP_TYPE_DESC to "Emp.Type" in the formula but now it says "Emp.Type" was not foud.
Pls help.
Solved! Go to Solution.
@ankurbajaj07 great to know! If you think my reply will help other users with the same issue in the future, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
Best regards,
Joao Ribeiro
Hi @ankurbajaj07 , can you provide the PBIX file? If not, I suggest you go back to each transformation step of the "Roster Database" and change all references to the old name of the column (after the step where you change the name of the column) - consider doing that for all tables that are referenced to this one, if there is any. Try to pass step by step and check if you will get error in any.
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
Best regards,
Joao Ribeiro
Thanks fo rthe reply. But I solved using advanced editor , there i found the old name reference. I changed & error vanished.
@ankurbajaj07 great to know! If you think my reply will help other users with the same issue in the future, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
Best regards,
Joao Ribeiro
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |