Forum

Hi John, The incremental refresh only gets the data you connect the query to. When you refresh a query it doesn't get that same data again, instead...

Hi Lisa, Please try uploading your file again. You need to click the 'start upload' button after selecting the file. Thanks, Mynda

Hi David, Welcome to our forum! I'm not surprised you're having trouble with this data. The row labels are all stuffed into a single cell while the...

Hi John, Welcome to our forum! Power Query in Excel does not have incremental refresh, but Power BI does. When you move to Power BI you'll be ab...

Hi Santosh, Split the Invoice Date column by delimiter. Then add a Custom Column: =#date([year],[month],1) Replace Year and Month with your c...

Hi Jen, 64-bit Power Pivot should easily be able to handle 400k rows of data. I wonder what else is in the workbook that's causing performance issu...

Hi Keith, Welcome to our forum. GETPIVOTDATA only references value field. You need to move the From and To fields in the Contract Length PivotTable...

Hi Jen, You might be able to load a table of summarised values for 2020 into a Power Pivot model along with your current year's data that will allo...

Hi Rossana, Please complete session 6 of the Power Pivot course. This will set you up to create the relationships. If you're still stuck after that...

Hi and thanks for sharing your file. The reason you are getting duplicates is because you're referencing the output table in the query itself, but ...

Hi Chad, Let's rewind. In Excel you have Power Query which you're wanting to use to create a single table, correct? What I'm trying to point out is...

Hi Kevin, Coincidentally, I have a video on creating your own personal portfolio dashboard coming out next week! Mynda

Ok, no worries. FYI, you can set Power Query to refresh upon opening of your file if that helps. BTW, we didn't remove your link. I'd say it didn't...

Hi Chad, I don't understand why you're preforming these intermediary steps. Why don't you simply get the CSV files with Power BI and import it dire...

Hi Bruno, The #(cr) etc. aren't in my code. That's being imported when you copy and paste it from the forum web page to Power Query. I recommend yo...