无法使用Excel的Power查询从共享的OneDrive Excel文件中获取数据

本文介绍了无法使用Excel的Power查询从共享的OneDrive Excel文件中获取数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我无法从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