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.
Hi there,
Back from holiday but still stuck with my problem. I can import csv files into Desktop, but i can't import Excel (2016). I've created some small files to check but it either blanks out the choice to load/edit (ie I can only cancel my request to upload an Excel table) or if I can click load, it throws out an error message, saying that the file does not contain requests or a model (rough translation from French). I have tried with Excel data in a table format and without table format, neither works.
I've installed Desktop on another laptop and have the same problem.
I'll be grateful for any suggestions as to what I should do, as I can't find any solution on internet. My files are saved as xlsx
Many thanks
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.
