Forum Discussion
Issue Importing All Data from an Excel Column
Welcome to the forum.
Can you post a picture of the power query screen please OR the actual code from the Advanced Editor in Power Query?
Also, do you see errors for the fields that are letters and numbers?
Hi there, I've posted a few screenshots, ranging from a sample of the original Excel file, to Power Query Editor & Advanced Editor. What I'm seeing is that the IDs that are letters+numbers aren't making it into Power BI at all. I'm wondering if the issue has to do with the way the 2 different ID types are formatted in Excel, but I haven't found a way around it yet. Thanks for any insights you or anyone else can provide
A Sample of the Original Excel FileViewing in Power Query EditorWhen trying to filter view for Letters+Numbers IDsAdvanced Editor