无法通过Power Query / Power BI访问项目数据表 [英] Cannot access Project data table through Power Query / Power BI

问题描述

您好，

我目前能够通过OAuth访问电源双功率/电源查询中的数据：

I am currently able to access data in power bi / power query via OAuth:

https://XXXXXX.sharepoint.com/sites/pwa/_api/ProjectData

当我这样做时，它会显示我可以加载的所有可用表。例如，我加载'TimesheetLines'，然后加载表。我必须先使用我的组织凭据登录，这样可以正常工作。

When I do this, it shows me all the available tables I can load. For example, I load 'TimesheetLines', and it loads the table. I have to sign in prior using my Organisation credentials, and this works fine.

（我在我的组织的O365帐户上有完整的管理员权限，包含Project和Power BI许可证）

(I have full admin right on my organisation's O365 account, with Project, and Power BI licenses)

但是，当我尝试加载'Projects'表，它再次询问我的凭据，但后来给我一个错误'用户未被授权'。

However, when I try to load the 'Projects' table, it asks me again for credentials but then gives me an error 'The user was not authorized'.

有人可以帮忙吗？这对我们来说是个大问题

Can anybody help? It's a big issue for us at the moment

非常感谢

Joe

推荐答案

它确实有效，但是有点棘手。我假设有一个默认字段，Power BI可能无法处理。不幸的是，我不知道哪一个。我已经阅读过关于ParentProjectId的内容，但绝对不是只有一个。

it does work, but is a little tricky. I assume there is a default field, which Power BI can just not deal with. Unfortunatley, I don't know which one. I have read about ParentProjectId, but it is definitely not to only one.

选择项目表后，请勿点击"加载"，而是点击"编辑"。将显示查询编辑器。单击选择列，取消选择全部并仅重新选择您真正需要的列。点击关闭并申请，你会看到你的项目
数据。

After selecting Project table, DON'T click on "Load", but on "Edit". Query editor will be displayed. Click on Choose Columns, deselect all and re-select only the ones, you really need. Click on Close and Apply and you will see your project data.

关心

芭芭拉

Regards
Barbara

这篇关于无法通过Power Query / Power BI访问项目数据表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！