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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register 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
Employee
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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.