Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm having some issues connecting a column of my table in Power Query.
I have made sure that that all the sources and sample files are connected. I have tried refreshing but still unable to find the column in my table. Have had no issues connecting the previous column.
Any tips on how to resolve this issue would be greatly appreciated.
Solved! Go to Solution.
See if this is being caused due to case sensitivity i.e. whether your column name is "salary" not "Salary". Also check if column name in table is having some whitespace character at the end or beginning.
For more details on the issue here is the advanced editor of the Additional Information query. When viewing the sample file that it is linked to I can see the Salary and previous columns with the rest of the table.
See if this is being caused due to case sensitivity i.e. whether your column name is "salary" not "Salary". Also check if column name in table is having some whitespace character at the end or beginning.
Hi @Vijay_A_Verma
Just checked and it turns out the Column's text was aligned centrally rather than to the left so there was spaces either side which explains why i wasn't able to find the Column 'Salary'
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |