Forum Discussion
Problem with data type from an excel file
Hi. I am new to BI, although I've already used Power Query. I now try to import a sheet from an Excel file. The file size is 42 MB (I have the free version but that allows you up to 1GB, so this should not be a problem?) and the data in the sheet covers 52 columns and 55871 rows. When I import it, it gives me an error message to say the data was cut because of the size. The upload and modify are blanked out, so I can only choose cancel - and therefore not importing my data into Power BI. Why is this a problem? (the problem, choice options are free translations, my computer is in French)
Also, I could not connect as it does not want to accept my gmail address (and neither my yahoo.fr). I've then used another address that I have that ends .com, even though I don't really want to use this as an option as it is an address I have with a company I do work for from time to time, but MS also does not want to accept this. How on earth am I suppose to connect if they don't accept these addresses? I'm not going to pay for a domain or email address and then afterwards find out they don't even want to accept that! I'm also not sure why I should connect since the screen and functionality of Power BI comes up on my computer, which is why I started to import the data (but perhaps this is the reason for the problem?).
I would very much appreciate assistance!
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.
10 Replies
Hi Joretha. Welcome to Power BI. For the time being, the terms of service require an organizational email for Power BI, though there is a community idea you can vote on to help MS change their mind. It has quite a few votes, so you're not the only one who wants to use their personal email, including me.
I'm not sure why you're hitting the import issue. You mention a data type in the title of your post. Is there an error indicating a data type problem? Maybe a field size? As far as I know, the size of your dataset won't cause an issue just loading into Power BI.
Hi there
Thanks for your response. I have tried with a company .com address but MS does not even accept this. From what I've read this last half an hour, it seems as if I can forget about having any access to Power BI just because they do not accept any of the e-mails, incl a corporate one. I think this is a shame.
I have tried to upload a very small Excel file, just to see what happens. So the connection is the problem - even though it shows the screen for BI, I can't upload any Excel file.
I've gone to post my vote, but it didn't even seem as if it was registered since the total votes remained the same.
Some companies have turned off the ability to use Power BI with their accounts. Not sure if that is the case for you and why you're having issues with the .com address. I also hope we get the ability to user Power BI as personal users, if nothing else to be able to learn the tool.
For what it's worth, you can check if your votes were attributed to the idea. While logged in at the ideas forum, click your username. You'll be able to see all of the topics you've voted for and how many votes you have assigned to them.
