beyphy

If you use Excel or Power BI to work with data, you’ve likely encountered Power Query - and may already rely on it regularly across desktop and web. It pulls data together, cleans it up, and prepares it for analysis. But beyond those familiar tasks, Power Query includes several capabilities that can make solutions more flexible, scalable, and easier to maintain.

Get more from Power Query in Excel with these little-known capabilities

After trying 10+ times for a month, I was finally able to get through on the phone today. And after waiting for like an hour and a half, I was finally able to speak to someone.

Just last week, I went through the process on id.me to get myself verified. I don't think that was a coincidence. While they don't explicitly say to do it, after all the fraud with Covid, I wouldn't be surprised if they require verification before you can get on the phone. So if you're struggling to get through to someone and haven't done id.me verification, I would recommend doing that as soon as possible.

We’re excited to share the latest addition to Excel for the web: The ability to import and edit data using Power Query!

We’ve reached yet another milestone in Excel for the web: The full Power Query user experience is now generally available, including the import wizard and Power Query Editor.

After we released the ability to refresh Power Query data from authenticated data sources, we were able to unlock the ability to complete the full user journey of importing data and editing it using Power Query.

New in Excel for the web: The full Power Query experience

Bring data into Excel with the new Import Functions

Bringing data into Excel is a core part of so many workflows, yet it can often feel more complex than it needs to be. Many of you shared that while Power Query is powerful, its UI can feel heavy for simple import tasks — especially when all you want is to pull a .csv or .txt file directly into the grid.

With Import Functions you now have two faster, more intuitive ways to bring text-based data directly into Excel. These new functions — including IMPORTTEXT and IMPORTCSV — let you load your data into a refreshable dynamic array with a single formula.

[Bring data into Excel with the new Import Functions](https://techcommunity.microso