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 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.