Feature - URL Filter on "Publish to Web Report"

[lfaltran]

Hi,

I'm using Power BI integrated with my azure database over "azure sql data warehouse" option on PowerBI datasets.

After build some reports and use the "Publish to Web Report" option I've faced a problem and need help for a workaround 🙂

Two users access the same URL (over and IFRAME), but, I want to set different filters, after search on PowerBI forums and other websites, it seems to be impossible (as link bellow), only on dashboard share to others PowerBI Pro users.

http://community.powerbi.com/t5/Service/How-to-Pass-a-URL-Filter-to-Publish-to-Web-Report/td-p/46376

What do you think about this?

Any suggestions how to solve this problem in my company?

Thank you.

[v-jiascu-msft]

Hi @lfaltran,

"Publish to web" publishes the report to the whole Internet without authentication, so filter seems unnecessary. Maybe there is a workaround. 

1. Create measures with the filter conditions. For instance:

Measure =
CALCULATE (
    MIN ( Table1[Value] ),
    FILTER ( 'Table1', 'Table1'[Week] = "week1" )
)

2. Create different reports for different purposes. Then publish to web.

Best Regards!

Dale

[lfaltran]

Hey Dale, thank you for your answer... I've tried to use this option "measure" that you said but on Power BI Web it doesn't exists.

Probably I'll create different reports for each client with filters applied, not sure if a better aproach will be released in short time.

By the way, I use exclusive Power BI Web, cause my environment is exclusive Linux platform and Power BI Desktop is not compatible.

Thank you

Luiz Fernando Altran

[v-jiascu-msft]

Hi @lfaltran,

Maybe you missed a powerful tool. We can't create a measure in the Power BI Service by now. There may be a workaround in your scenario. Maybe you could create several views in the database. One person has a report from a special view. But this would be a lot of work to do. 

Best Regards!

Dale

[lfaltran · Accepted solution]

I've finished report creation for each company, this workaround works like a charm 🙂

By the way, I've used the same view and aplied REPORT LEVEL FILTERS for Company ID.

Best regards

Luiz Fernando Altran