Named ranges in Excel are not recognised by PowerBI

[Anonymous]

Am I doing something wrong?

[IHPQ]

I've just had something similar and I wasn't using dynamic named ranges.

The issue I had was that the worksheet was called "IS&KPI'20" - once I replaced the apostrophe with an underscore my problem was sorted. I'd imagine this kind of issue will happen with other restricted characters too.

[MarcelBeug]

Probably.

At least you forget to specify your issue.

So just a wild guess: are you trying to import a dynamic range?

[Anonymous]

Sorry. Yes range with offsets

[MarcelBeug · Accepted solution]

Dynamic ranges can only be used with Power Query in the current workbook, not when importing data from an external workbook.

[AlexGBA]

A functionally identical solution appears to be to spill the dynamic range within a new excel sheet, then have the query pull data from that sheet, rather than a named range. This has been the best work around for me