Forum Discussion
Problem with data type from an excel file
Thank you - I have managed to solve the problem by myself :). It was a very stupid error, but if you don't know it, you can be stuck like I was. In fact, I have used click & double click on the table to import, but this kept the load & edit blanked out. There is actually a little square in front of the table name (i haven't even noticed before...) - you need to click that tick box in order to enable the options to load/edit.
Have you tried to pull the data into PowerQuery and PowerPivot? They are 'twins' to PowerBI and would give you an idea if the file itself is the issue. the difference is that they live in native Excel.
If you can access it in Power Query (or what ever they call it in Excel 2016) then I would send a ticket and ask v-qiuyu-msft for some advice.
Thank you - I have managed to solve the problem by myself :). It was a very stupid error, but if you don't know it, you can be stuck like I was. In fact, I have used click & double click on the table to import, but this kept the load & edit blanked out. There is actually a little square in front of the table name (i haven't even noticed before...) - you need to click that tick box in order to enable the options to load/edit.