Forum Discussion
Power Pivot in Excel 2019 - From other Sources button wont work
Interesting. I just checked this on two builds.
Insider build 1902 b1132820008 - the button works. I never ever use it though as I always always bring data in via Power Query then load to the data model, even if I don't edit it. It allows me to edit/filter it in the future if I want.
Monthly Targeted build 1901 b11231.20130. The button is not grayed out, but when I click it it just flickers as if it is going to do something, but then nothing happens.
It honestly wouldn't surprise me if this feature is depreciated at some point. In Power BI, you must get data through Power Query. I think the only reason this button and any other import functions exist in Power Pivot is it came out for Excel before Power Query did. Had the release order been reversed, I doubt PP would have any import capability.
But it definitely seems to be glitchy and inconsistent in what is and isn't supported. The good news is using Power Query isn't really a work around, it is really the way it should be used going forward.