Forum

Hi @AG For a short Excel test, they typically want to see that you can: Spot data quality issues (nulls, wrong types, outliers, duplicates). U...

Hi Alberto, When you say 'best practice' I imagine you are asking about what to do with such problems, but that is dependent on your situation to so...

Hi David, My original code was designed for numeric data (as you've discovered) so needs a tweak for alphanumeric. In the cmdSearchBadge_Click sub...

@riny Correct. Thx.

@cbird Hi Chris, I don't have access to that Google Docs link. Are you able to just upload the XLSX file here? Phil

Hi Chris, The table is actually called BDloads3 and the string has a space in it. You're trying to match "SubReceipts" when it should be "Sub Recei...

@cipow Sorry, the anti spam settings were blocking XLSX files. I've fixed that now

@kellyferg Sorry, the anti spam settings were blocking XLSX files. I've fixed that now

@magickrhythm Sorry if you can't reproduce the problem then neither can I and I do not know what would be the cause of this issue. Regards Phil

Can't you ask your work IT Dept to fix this, as they will have access to the Registry?

Hi Amanda, No I can't say I know why this happens. What exactly did you do in your correction to Group By? How long did you wait for Power Query t...

Hi Ayal, So you are trying to load a table from a file, have you tried the steps listed here: Get Data from OneDrive or SharePoint with Power Quer...

Hi Tom, Beyond Copilot which is built in? What exactly do you want other AI add-ins to do? Regards Phil

Change Type Using Locale

Hi Ayal, Your initial qs implied that you were trying to embed a workbook? Is that not the case? #7 on the blog I linked to works for me when em...