Forum

Hi Tony, There's no way to disable a query refresh, other than to close the query editor with the 'x' in the top right of the window and choose 'Di...

Hi Oleg, Thanks for the file. Did you update Power BI between the first CSV which contains the forecast data and the second download which doesn't?...

Hi Dennis, It shouldn't take that long. Please provide more details about the queries. What are the sources of the data. What are the queries doing...

Like this?

Hi Adele, Sorry, Power Query is case sensitive, full stop. So, you'll need to fix the case in the tables before merging. It's easy, select the colu...

Hi Cheryl, If the old method works then this means you're still running the old version of Power Query. With the old version you can't just click o...

Hi Oleg, I downloaded the latest version of Power BI Desktop and it still doens't download the forecast data. Mynda

Hi Oleg, I'm not aware of a way to download the forecast data in the CSV. Although my version of Power BI Desktop is due for an uptate so you may h...

Hi Cheryl, There is an updated video for tutorial 2.05 From Folder. Please review the tutorial again. The old tutorial is also on that lesson page ...

Hi Rene, I'm with Frans. I would do this calculation in the source data, not in a PivotTable calculated field. There's more transparency this wa...

Hi Moavu, The trick when you have nested headers is to Transpose the data first. Then you can promote headers and unpivot, before pivoting the Net ...

Glad you got yourself a Stephen Few book. I recommend his books in one of the first tutorials in the Dashboard course. I'm confident you'll find them...

Hi Alasdair, You can download and install the Power Query add-in for Excel 2010 here: It's availble for all versions of Excel 2010. Take no not...

Hi Rene, Can you please upload a sample file so we can see your question in context. Thanks, Mynda

Hi Alasdair, I'd use Power Query to get your data and then split the chargeable and non chargeable into their own columns using an if statement. Th...