Forum Discussion
BenFransen
Advocate II
Advocate IIExternal table is not in the expected format.
I have a data mutation process which is handled by Pentaho Kettle. Basically it reads several Excel-sheets, tidys up, rearranges, does some formatting, casting and sorting and writes it to an Excel-f...
To fix this :
Select the query in the fields : open "Edit Query" ; This will open power query editor.
Now go the navigation steps of that query in the right hand side.
Step by step - review each steps in the navigation. In one of them you would find an issue (e.g Column change etc ) ; the step where you can open the "Table" click on it and the Table will open.
Then Apply, Refresh in the main Power BI screen. the data will get refreshed.
BINGO !!