本文介绍了在有或没有ApiaryIO的情况下,无法通过API更新Power BI表架构的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在使用Power BI API。
我有一个包含一些表和行的数据集。

I am using Power BI API.I've got a dataset with some tables and rows.

来自检索数据集或表时我没有任何问题。

From Power BI API Console I don't have any issue when retrieving datasets or tables.

但是表资源上的PUT动词始终更新其架构返回504-代理请求超时

However the PUT verb on a table resource to update its schema always returns a 504 - Proxy request timed out

这是我第一次使用Apiary IO,因此可能是它的问题,并且不是Power BI更新,但这使我提出一些问题:

It's the first time I use Apiary IO so it might be its problem and not Power BI update, but that leads me to some questions:


  1. 是否有任何变通办法来测试Power BI,例如Fiddler?我可以输入网址和正文,但是如果我没有记错的话,我将需要带有OAuth2令牌的Authorization标头。我该怎么办? ApiaryIO似乎将其隐藏。

  2. 根据包含资源的URL为 https://api.powerbi.com/v1.0/myorg/datasets/ {myDatasetId} /表/ {myTableName}
    ,动词为 PUT 。 JSON正文中的 name: ??? 参数的含义是什么?是桌子的名字还是其他?我假设它是表名,但是似乎很多余,因为我已经按照给定的URL访问资源 {myTableName}

  3. 最后一个相关的问题是如何在不修改其表数据的情况下重命名该表的列?这是我试图通过更新架构来实现的目标,但是我不明白Power BI如何知道我要重命名的列。

  1. Is there any workaround to test Power BI with, for example, Fiddler? I can type the url and body but I will need an Authorization header with the OAuth2 token if I'm not mistaken. How can I get that? ApiaryIO seems to hide it.
  2. As per Update Schema Documentation the URL with the resource is https://api.powerbi.com/v1.0/myorg/datasets/{myDatasetId}/tables/{myTableName}and the verb is a PUT. What is then the meaning of the "name": "???" parameter that goes in the JSON body? Is it the table's name or something else? I am assuming it's the table name but it seems redundant as I am already accessing the resource {myTableName} as per the given URL.
  3. And my last related question is how to rename a specific table's column without modifying its data? This is what I'm trying to achieve by updating the schema but I don't understand how does Power BI know what column I am trying to rename.

谢谢!

推荐答案

对不起,您遇到了麻烦。您可以通过两种方式获得令牌-正确的方法是在AAD中创建应用程序()。错误的方法;)是打开Power BI.com服务,在浏览器中然后打开提琴手,然后按F5重新加载。您应该能够在各种请求中看到访问令牌。如果您注册了一个应用程序,则可以在我们提供的示例之一中插入您的应用程序信息,请参阅客户端应用程序或Web应用程序。

Sorry that you're having trouble. You can get a token in two ways -the right way is to create an app in AAD (here's how). The wrong way ;) is to open the Power BI.com service, in a browser then open fiddler, then press F5 to reload. You should be able to see the Access Token in various requests. If you register an app, you can plug in your App's information in one of the samples we have https://powerbi.microsoft.com/developers, see client app or web app.

您在表格中提供的名称是用户界面中友好的可读名称,您正在建立报告。没有它,该系统将无法被人使用:)。

The name you provide in the table is the friendly human readable name that appears in the UI when you're building a report. Without it the system is unusable by humans :).

让我在#3上与您联系。

Let me get back to you on #3.

这篇关于在有或没有ApiaryIO的情况下,无法通过API更新Power BI表架构的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-24 03:45