power query, sorces are missing

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

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.

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