如何在Powerbi中存储除活动本地存储api之外的自定义可视化数据

Question

我想将用户输入存储到外部云服务器。但是我将api请求称为api请求，它将被visual的sandbox ()阻止。我不解决这个问题。请帮帮我。谢谢。

​

setData = async (data: string): Promise<void> => {
        let url = "https://myitanalyticsdiag.blob.core.windows.net/bootdiagnostics-eusvm01-5fe205b2-e051-435a-b406-12efdd05a96a?sp=racwdli&st=2022-07-18T02:50:01Z&se=2022-07-30T10:50:01Z&spr=https&sv=2021-06-08&sr=c&sig=i0xaDxZ2jA5WA68Vh89B5tIlYJaDS4WWlgKQ%2F9kUUrs%3D"; // URL with SAS token
        if (url) {
            try {
                let resp = await fetch(url, {
                    referrer: "https://app.powerbi.com",
                    headers: {
                        "x-ms-version": "2017-11-09",
                        "x-ms-date": new Date().toISOString().split('T')[0],
                        "Content-Type": "text/plain; charset=UTF-8",
                        "x-ms-blob-content-disposition": "attachment; filename=\"mydata.txt\"",
                        "x-ms-blob-type": "BlockBlob",
                        "x-ms-meta-m1": "v1",
                        "x-ms-meta-m2": "v2",
                        "Authorization": "sp=racwdli&st=2022-07-18T02:50:01Z&se=2022-07-30T10:50:01Z&spr=https&sv=2021-06-08&sr=c&sig=i0xaDxZ2jA5WA68Vh89B5tIlYJaDS4WWlgKQ%2F9kUUrs%3D" // not needed with sas token
                    },
                    method: "PUT",
                    body: data
                });
                return Promise.resolve();
            } catch (err) {
                return Promise.reject("Request failed.");
            }
        }
        return Promise.reject("No save url defined.");
    }

​

问题截图

Answer 1

您需要使用v4.7.0：https://learn.microsoft.com/en-us/power-bi/developer/visuals/permissions-api中可用的新权限API

基本上，您需要提供URL，这样Power将为可视的capabilities.json添加一个异常：

"privileges": [
    {
        "name": "WebAccess",
        "essential": true,
        "parameters": [
            "https://myitanalyticsdiag.blob.core.windows.net/"
        ]
    }
]