Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Query
Unanswered

Power query

(0) ShareShare
ReportReport
Posted on by 8

Hello,

 

I'm using a software called 'Measure kill' to clean up my PBI datamodel. 
I have a issue with pasting the Power Query  M code in the query editor of a shared or “golden” dataset on my local machine, which is connected to several live or “thin” reports.

 

The issue is that the system fails to recognize renamed columns, resulting in an error for multiple columns. The error message I receive is as follows:

 

Expression.Error: The column 'Modified On' of the table wasn't found.

Details:

Modified On  

 

When performing the same operation in a single report, I do not encounter this issue, even though there are multiple renamed columns present.

 

Has anyone else experience the same issues ? any suggestions on how to solve this will be greatly appreciated.
Manually adjusting the query isn't an option due to the size of the data model. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Power Query

#1
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

#2
SD-13050734-0 Profile Picture

SD-13050734-0 6

#3
Rhys @ Empower 365 Profile Picture

Rhys @ Empower 365 2

Overall leaderboard

Featured topics