power query, sorces are missing

Question

&nbsp;&nbsp;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 · Answer

Hello idoezra&nbsp;&nbsp;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.&nbsp;If this post helps or solves your problem, please mark it as solution.Kudos are nice to - thanksHave funJimmy

edhans · Answer

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.

jimmy801 · Answer

Helloare 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

Forum Discussion

Related content

Missing Query Pane Options in Power Query

missing data

missing data

Best Practices for Handling Missing Data in Power Query

Generating Missing Data