Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

inserting parameter in M language 's error in column name

Hi Power Bi -ers, 

I am hoping to find a better solution to this problem.

The issue : when i am inserting parameter in M language native query, it returns a column name in the form of "tablename.columnname" after we installing the april PowerBi version. Before version upgrade, we have never have this issue.ErrorPowerBI.PNG

How to solve this: We adding this to solve this problem: """ parameter """ in the WHERE clause query

However, we re concerned about changing manually all WHERE clause for all our report. It is huge!!!

Therefore, we having these questions to ask:

1. Why it is happing? Before we have never have this problem of wrong column name in our report

2. What is the optimal solution to solve our problem? 

 

Thank you so much and looking forward to hearing soon from all of you

ChangeWhereClause.PNG

2 REPLIES 2
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous ,

 

Which desktop version do you use now? Is it the latest one?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi, 

we re using the lastest version.  Do you think this problem can come from the ODBC driver cause we installed new version of ODBC driver and PowerBI desktop? 

Version:

2.68.5432.841

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.