Forum

Hi Shawn, It's difficult to hold a picture of your workbook in my head in order to answer your question. Please upload an example Excel file with s...

Hi Alison, The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the f...

Hi Kabil, The data/business isn't something I'm familiar with. It uses acronyms I don't recognise, so it's difficult to help without further explan...

Hi Jim, That's not incremental refresh in the true sense. The purpose of incremental refresh is to prevent Power Query getting all the data every t...

"In both these cases there should be no problem to autorefresh all the copies of Pivot Table / Power Pivot with a single click on the "Refresh All" bu...

Hi Libor, The answer partly depends on which version of Excel you have and partly on whether you need Power Pivot and DAX function capabilities. ...

Hi Kabil, Welcome to our forum. The purpose of the forum isn't to do this work for you. You would need to make an attempt at it and then if you get...

Hi Katrina, Excel currently can't work with multiple values in a cell and compare them to cells with individual values. Therefore, I would load the...

Hi Kasey, Posting in multiple forums is against all forum rules, including ours. You must declare cross posting so we know not to waste time on que...

Good question, however I'm not aware of any way to do this, Pieter.

If you're using Power Pivot in Excel or Power BI you can change the data type in the modelling side. Otherwise, you can format the values in the visua...

Great! In that case suspect you weren't using Direct Query

I'll ask Microsoft, but I suspect you can't turn this off. I'll let you know what they say. Mynda

Hi Yuan, After the source step you can apply a filter to the file name column that only imports files that meet the criteria you specify. Mynda

Hi Yuan, If you're using Direct Query then you cannot connect to any other datasets in the same model. Mynda