如何将 URL 筛选器传递给 Power BI 发布到 Web 报表

本文介绍了如何将 URL 筛选器传递给 Power BI 发布到 Web 报表的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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

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

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

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

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

解决方案

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

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

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

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

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

您提供的第二个链接是直接指向 www.powerbi 的 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: app.powerbi/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: app.powerbi/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: app.powerbi/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) powerbi.microsoft/en-us/documentation/powerbi-developer-integrate-report-load-report-iframe/

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

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