Re: power query, sorces are missing

idoezra · ‎12-15-2019

Hi,

I installed power query for excel 2013,

i have a problem that in "other sorces" missing some sorces.

do you know something about that?

kind regards,

ido

Jimmy801 · ‎12-20-2019

Hello
are there any news on this topic? Did solve or help any reply your problem?
If this is the case, please mark it as solution.

Jimmy

edhans · ‎12-15-2019

It may be the version of 2013 you are using. Home, Business, Pro, and Enterprise licenses for Excel all have different sources they can access. For example, 2013 with Home office 2013 cannot access Azure Data Lake, Active Directory, etc. as data sources. Business, Pro, and Enterprise all add additional sources with Enterprise licensing having the most.

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

Jimmy801 · ‎12-15-2019

Hello @idoezra

most probably Excels 2013 Power Query version will no longer updated and therefore newer functions will not be availible. This also because of backwards compatibility.

You can use Power BI to the transformation for you and then export it.

If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun

Jimmy