Forum

Hi Shannon, I suspect the data is present elsewhere in your file as it's unlikely that it's not refreshing part of the query...just my guess based ...

Hi Cheryl, Sorry for my slow reply. I've been on vacation. Thanks for providing the sample file. It helps a lot. I can see how most of the colum...

I imagine so. You'd have to write some VBA code to refresh the query via a button.

Hi Steve, Great to see you're giving Power Query a go. There is something quirky with the colons in that data. If you change the Quote Style to ...

Hi Shannon, Do you mean you have removed a table/worksheet in this file: "Jan 21 Fcast Wrkbook_2018-19 - NEW.xlsx", but the data is still being bro...

Hi Yan, I suspect there is something wrong with your model structure; maybe the relationship directions or the fields used in the PivotTable and Sl...

Hi Alison, This isn't really a data validation issue. I'd use Power query to create the 'desired table' and then compare that to the finished ta...

Hi Denise, Great to see you're implementing Power Query into your work. To answer your questions: 1. Load the data the Data Model as connection ...

Hi Linda, Irrespective of that setting, which is just the preview setting, the Pivot Chart should still reconcile. In other words, these are unrela...

Hi Alison, There isn't a workbook attached. Mynda

Hi Adrienne, I actually have a blog post on how to do this coming out next week. Please see the attached file. Mynda

Hi Gary, You can 'Add Column' > Custom Column: = if [First Date] > [Second Date] then 0 else Duration.Days([First Date] - [Second Date]) ...

Hi Cheryl, I don't need to see the confidential data. The example file is fine, the only part missing is how you want those two sheets to look in t...

Hi Mark, I've never had to install OLAP extensions with Office 365 ProPlus, so I don't imagine you will either. Hopefully it was just an Excel 2013...

Hi Linda, I'm not aware of it being a limitation. Do the 1000 rows add up to the value in the PivotTable? If yes, then there's no limitation, inste...