Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Dynamic ranges can only be used with Power Query in the current workbook, not when importing data from an external workbook.
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.
Probably.
At least you forget to specify your issue.
So just a wild guess: are you trying to import a dynamic range?
Dynamic ranges can only be used with Power Query in the current workbook, not when importing data from an external workbook.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |