Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Help.
I can not refresh the data in Power Bi Desktop.
Here are two screen shot. One of my Excel database. One of PowerBi Desktop with the error message.
It says: "We did not find the column" Mail "of the table".
But, as it can be seen on the screen shot there no
There is no "Mail" column to fill in Power Bi. But rather "Current Email". And as we see on the Excel table of the data it does appear a column "Current Email".
What can I do to refresh my PowerBi ?
Hi @Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi @Anonymous ,
For your issue, I think, you could go to Edit Queries and check the Change type step.
If you find the column name "Mail", please change it to be "Current Emai".
If you still need help, please share the screenshot of your M query so that we could help further on it. Do mask the sensitive data before sharing.
Best Regards,
Cherry
Hi, I am trying to update my data. The new table titled "Remediation" that I get after loading seems correct. However, the old table remains displayed. I have error message: your queries contain pending changes. When I click to apply the changes I get the error message: the key doesn't match any table
Hi,
What do you call the Queries Editor ? Is this the empty field to capture searches, right at the top?
What do you call the Editor Queris ? Is this the empty field to capture searches, right at the top?
@Anonymous, Please copy and paste the M code for the table here.
You can right click the table name in Query Editor and click "Advanced Editor". Copy and paste that here, and we'll have a look.
~ Chris
Hello,
As you can see on the screen shot. The line 2 (Nom usuel / Prenom / Email actuel) should replace the line 1 (Column1 / Column 2 / Column 3). This seems to be the cause. PowerBi can't update the data because it doesn't properly recognize the header line of the source file.
hi @Anonymous
Follow these steps:
1. After retriving excel data, Go Editqueries --> applied steps
2. applied steps you have 3 steps are showing like (Source, Promoted Headers, Change type)
3. remove the change type step
4. close and apply
5. refresh your data set
regards,
Naveen
Hi, Unfortunately, it has not yet worked. But by doing several tests, I understand the problem better. As appears on the attached screenshots the problem is in importing a file needed to make the update. To do the update I import three files actually that are compiled to give a fourth file that needs to be displayed. The problem is only the import of one file out of all three. I show here two screenshots. One of a file that poses no problem. The other one in the file that blocks. In fact, all file content is blocked in the content of the first column instead of being spread across multiple columns. The first screen copy is correct. While on the second we see that PowerBi did not select the first line of the source file to fill the titles of each column.
Hi, Thanks a lot,
By "remove the change type step" what do you mean ? remove le line 3 completely ? from "Change type" to {" ?
Or juste remove "Change type" = Table.transformColumns ?
If you look my screen shot
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |