Last seen: Jun 18, 2026
My pleasure, Henry! Let me know if you don't hear back from Microsoft. Give them a week.
Hi Brent, Sorry, I missed that you said you had Excel 2019. Power BI requires you and those who want to view your reports to have a US$10/mth Pr...
Sometimes the double quotes get copied in a different style when copying from web pages. I would try entering the formula by typing it in yourself to ...
Hi Henry, As you're on the beta channel you should send a frown and let the Excel team look into it. Be sure to share a screenshot as these frowns ...
Hi Marc, The answer to this is in my response to your previous question. In order to avoid two refreshes you need to build your PivotTables from t...
Hi Marc, In later versions of Excel you can Close & Load to PivotTable report. This loads the query data into the Pivot Cache for building Pivo...
Hi Mahbub, As long as you're talking about OneDrive for business/SharePoint then you just need to make sure the other PBI users have permission to ...
Great to hear, Pieter! Yes, PQ can't always tell if an external reference will lead to a privacy breach, so sometimes it's overzealous as a precaut...
Hi Pat, When you connect to the web url with Power Query at the second dialog box you're asked how you want to access the web content and can choos...
Data validation in source data for PivotTables is fine. Of course if anyone makes a change to the selection in the data validation list you'll want to...
Hi Brent, Thanks for sharing your file. If you have Microsoft 365 you could use the FILTER function to return a filtered list based on selections u...
Hi Pieter, If you're referencing the Excel file using your hard drive path, then that should work fine. Sounds like you're making progress. Plea...
Hi Brent, It's possible, but maybe not with a Pivot Chart. It would depend on what you want to filter on. e.g. is it time, categories etc. I rec...
Hi Zohar, Please provide a sample Excel file as it's difficult to picture the problem. Thanks, Mynda
Hi Zohar, Please see this tutorial on how to build a multi-colored line chart. Mynda