Here are some tips and tricks to help you get the most out of this incredibly useful and easy tool. If you haven’t heard of power query and the awesome things it can do, or you want to fully understand it better, then check out my Complete Guide to Power Query beforehand. It’s also the same technology that’s used in Power BI, so you’re learning two in demand data skills at the same time! The best part is, it’s built right into Excel 2016 or later. It’s going to save you time and effort if you put in the small amount of time to learn it. Or, if you’d prefer a printed copy, it will be released on Amazon, starting November 1, 2021.Power query is amazing data transformation tool! It allows you to import and transform data with ease and helps to create repeatable and robust procedures for your data. Master Your Data with Excel and Power BI.Get the digital version of the new edition right now, on Ken and Miguel’s website: You can choose between the digital version of the new edition, or a printed copy. I’ve got an autographed copy of that edition on my bookshelf. This is the second edition of their popular book, M is for Data Monkey. Now, I’m ready to go through the Power Query book, Master Your Data with Excel and Power BI, and can’t wait to learn new things! Then, I changed the second monitor display settings back to 125%, so things are easier for me to see. Maybe I’ll leave it there for now, so the same problem doesn’t happen again! I was also able to double-click the pane’s title bar, so it docked at the right side of the Excel window. I was able to drag the pane down a couple of inches, so it wasn’t right at the top of the second monitor any longer. Changed the Scale and layout size from 125% to 100% (recommended setting)Īs soon as I did that, the Queries & Connections pane shifted a bit, and its title bar appeared.Right-click on an empty spot in the monitor.Here’s what I did to temporarily change the monitor settings, to see if that would help: Maybe the second monitor display settings were affecting the Queries & Connections pane too. Second Monitor Problemsįinally, I remembered a similar situation, when Excel UserForms suddenly looked strange on my second monitor. In fact, I didn’t find anyone else reporting the same problem. Unfortunately, a Google search didn’t turn up any solutions. It’s easy to just ignore a problem like that, instead of trying to fix it.īut, with Power Query experiments to try, I decided to tackle the problem. Most of the time, I’m using existing queries, and don’t need to do anything with the Queries & Connections pane. I couldn’t move the pane though, because there was no title bar to double-click or drag. At the top, only the two tabs are showing – Queries, and Connections.įortunately, I was able to resize the pane, by dragging the sides or corners. It’s about 1 inch wide and tall, with no title bar showing. This is what the Queries & Connections pane looked like, every time I used it. Then I remembered the problem I’ve had for a few months – the Excel Queries & Connections pane is stuck at the top of my second monitor. I bought a digital copy, downloaded the sample files, and eagerly dove into the book. Ken Puls and Miguel Escobar just released their new Power Query book – Master Your Data with Excel and Power BI.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |