如何将 URL 筛选器传递给 Power BI 发布到 Web 报表 [英] How to Pass a URL Filter to a Power BI Publish to Web Report

问题描述

我正在尝试将 URL 过滤器传递给已发布的报告，但无法使其正常工作.

报告: https://app.powerbi.com/view?r=eyJrIjoiOGExYjhhYmMtZmU0OS00ZGJjLWE3YmUtNTM5MjM1OWIzZTA5IiwidCI6IjUyM ...

我尝试过使用这里的方法:将参数传递给 Power BI 过滤器以编程方式将 &filter=Table1/ZipKey eq '00001' 添加到 URL 的末尾，但这不起作用.

它适用于这个链接:https://app.powerbi.com/groups/me/reports/8d3cbf1e-3d89-46d3-ac1a-b24d0784b125/ReportSection?filter=...

有什么想法吗?这不可能吗?如果没有，最终目标是能够将其嵌入到另一个页面中，我可以使用其他方法吗?

解决方案

您提供的网址:报告: https://app.powerbi.com/view?r=eyJrIjoiOGExYjhhYmMtZmU0OS00ZGJjLWE3YmUtNTM5MjM1OWIzZTA5IiwidCI6IjUyM [剪辑]

是发布到网络报告.不支持将查询字符串过滤器选项发布到 Web 报表.

如果您想以编程方式过滤报告，您应该使用我们支持的开发者选项之一:

A) https:///powerbi.microsoft.com/en-us/documentation/powerbi-developer-integrate-report-load-report-iframe/

B) https://azure.microsoft.com/en-us/documentation/articles/power-bi-embedded-iframe/

您提供的第二个链接是直接指向 www.powerbi.com 的 URL，其中还支持 URL 过滤器语法.基于该选项，A 可能是您正在寻找的.

I'm trying to pass a URL filter to a published report but am unable to get it to work.

The report: https://app.powerbi.com/view?r=eyJrIjoiOGExYjhhYmMtZmU0OS00ZGJjLWE3YmUtNTM5MjM1OWIzZTA5IiwidCI6IjUyM...

I've tried using the method here: Passing parameters to Power BI filter programmatically by adding &filter=Table1/ZipKey eq '00001' to the end of the URL but that doesn't work.

It works for this link: https://app.powerbi.com/groups/me/reports/8d3cbf1e-3d89-46d3-ac1a-b24d0784b125/ReportSection?filter=...

Any ideas? Is this not possible? If not, the end goal is to be able to embed this within another page, is there a different method I could use?

解决方案

The URL you provided: The report: https://app.powerbi.com/view?r=eyJrIjoiOGExYjhhYmMtZmU0OS00ZGJjLWE3YmUtNTM5MjM1OWIzZTA5IiwidCI6IjUyM [snip]

is a publish to web report. The query string filter option is not supported for publish to web reports.

If you want to do programmatically filter the report you should use one of our supported developer options:

A) https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-integrate-report-load-report-iframe/

B) https://azure.microsoft.com/en-us/documentation/articles/power-bi-embedded-iframe/

The second link you provided is a URL directly to the www.powerbi.com, where the URL filter syntax is also supported. Based on that option A may be what you're looking for.

这篇关于如何将 URL 筛选器传递给 Power BI 发布到 Web 报表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！