无法使用Excel的Power查询从共享的OneDrive Excel文件中获取数据 [英] Can't get data from a shared OneDrive Excel file with Excel's Power query

问题描述

我无法从Excel 2016中的Power查询获取OneDrive共享Excel文件中的数据。而不是Excel文件数据我得到HTML。这是文件链接：
https://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: https://1drv.ms/x/s!AsAdTBvimEwBgQDOyDID-yyf1Ljf

我尝试了这里的建议
https://www.sqlchick.com/entries/2014 / 8/17 / using-power-query-to-get-data-from-excel-file-in-onedrive-via-url

I tried what is suggested here https://www.sqlchick.com/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: 

https://msdn.microsoft.com/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:

https://social.technet.microsoft .com /论坛/ en-US / home？论坛= powerquery

https://social.technet.microsoft.com/Forums/en-US/home?forum=powerquery

这篇关于无法使用Excel的Power查询从共享的OneDrive Excel文件中获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！