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.
Thank you for your reply. I did have a look at the video. I've also uninstalled the Power BI Desktop, thinking something went wrong during the installation. I've installed it again, using the MS centre for downloads, this time the English version. Still no luck. The moment I want to import an Excel file, no matter how small, the choice for Load or Edit are blanked out. The only choice I have is cancle. It is an Excel file on my hard drive. I've then reinstalled the Fr version as well - still the same problem. So no matter what - I can't use Power BI Desktop, even though it is suppose to be for free. I honestly don't know what to do & I've wasted a lot of precious time searching for a solution.
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.
