我无法从Excel 2016中的Power查询获取OneDrive共享Excel文件中的数据。而不是Excel文件数据我得到HTML。这是文件链接: 1drv.ms/x/s!AsAdTBvimEwBgQDOyDID-yyf1Ljf
I cannot get data from a OneDrive shared Excel file with Power query in Excel 2016. Instead of an Excel file data I get html. Here's the file link: 1drv.ms/x/s!AsAdTBvimEwBgQDOyDID-yyf1Ljf
我尝试了这里的建议 www.sqlchick/entries/2014 / 8/17 / using-power-query-to-get-data-from-excel-file-in-onedrive-via-url
I tried what is suggested here www.sqlchick/entries/2014/8/17/using-power-query-to-get-data-from-an-excel-file-in-onedrive-via-url
但我仍然在Power查询中得到html。用我的文件自己试试吧。见
but I still get html in Power query. Try it for yourself with my file and see.
推荐答案
你好Omot,
Hi Omot,
此论坛的目的是讨论可在此处找到的开放规范文档:
The purpose of this forum is to discuss the Open Specifications documentation that can be found here:
msdn.microsoft/en- us / library / dd208104.aspx
由于Power Query的主题不是本文档集的一部分,我建议您将查询引导到以下论坛:
Since the topic of Power Query is not part of this documentation set, I would recommend that you direct your query to the following forum:
social.technet.microsoft /论坛/ en-US / home?论坛= powerquery
social.technet.microsoft/Forums/en-US/home?forum=powerquery
更多推荐
无法使用Excel的Power查询从共享的OneDrive Excel文件中获取数据
发布评论