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.
Dear community,
I am getting the below error while loading apply the query to the newly loaded file.
how do i fix this?
Solved! Go to Solution.
i figured it out, its because of the change in the sheet name in 2nd file.
its strange that Power BI is not pushing this
i figured it out, its because of the change in the sheet name in 2nd file.
its strange that Power BI is not pushing this
@vjnvinod,
Would you mind sharing the Folder through Private Message? I will test it in my Desktop.
Regards,
Lydia
i am connected to a folder, where i have 3 excel
i have used edit option to combine that 3 excel together, after combining when i am applying the changes
i am getting this error, i checked the step and noticed that row 2 is coming as error(See below)
[Expression.Error] The key didn't match any rows in the table
@vjnvinod,
What is your data source? Please go to Power BI Desktop query editor to check the APPLIED STEPS and check if which step throws this error.
In addition, please go to Advanced Editor of your current query in Query Editor, then check if the file path is correct.
Regards,
Lydia
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |