Last seen: Jun 30, 2026
Hi Mary, Moving columns in the query editor does not feed through to the data view/table view in Power BI. The field list in the report view is sor...
Hi Suzanne, Yes, you can import Excel workbooks containing Power Query queries and Power Pivot models. From Power BI desktop File tab (to the le...
Hi Paul, There are two parts to Power BI: 1. The Power BI Desktop app that you download an install on your PC 2. A Power BI Service account. ...
No, there isn't the same 'Treat consecutive delimiters as one' feature that we have in Excel, but you can first split by a fixed width to get rid of t...
Hi Bill, I've had that before. I needed to clear my cache/cookies and it loaded again. Mynda
Hi Scott, There are lots of missing details regarding what you've tried so far. Here are some things to consider: 1. If the data you're loading ...
Hi Rachael, You can add a column for Median by first selecting the columns for Wendy, Jim, Mary and Tom and then on the Add Column tab > Statist...
Hi Tim, In session 4.14 I cover map visualisations in more detail and explain the intricacies of removing ambiguity from your data. Might be worth ...
Hi Ahmad, You can create a nested axis by referencing two columns for the horizontal axis range. See example attached. Note: I don't recommend u...
Hi Daniel, It's great to hear you're success story. Congratulations. Your hard work has paid off. Your file wasn't attached. I suspect you didn'...
Hi Bill, The difficulty with selecting multiple items in a Slicer and then using those items in a formula is handling the different numbers of item...
Hi Rita, In Power Query null is an empty cell, whereas a zero is a number. You can load your data as is into Power Pivot and the cells containing n...
Hi Oleg, I think you mean February 🙂 It'll be next week! Keep your eye out for an email about Power BI on Tuesday February 14. Mynda
Hi Oleg, No, you can't connect to Google Analytics with Power Query in Excel, only from Power BI. Mynda
Hi Lisa, The Power Query method is covered here: Then for the holiday dates, create another query for your holiday dates table. Then join the n...