cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lfaltran Frequent Visitor
Frequent Visitor

Feature - URL Filter on "Publish to Web Report"

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.

1 ACCEPTED SOLUTION

Accepted Solutions
lfaltran Frequent Visitor
Frequent Visitor

Re: Feature - URL Filter on "Publish to Web Report"

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

View solution in original post

4 REPLIES 4
Microsoft v-jiascu-msft
Microsoft

Re: Feature - URL Filter on "Publish to Web Report"

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.Feature - URL Filter on Publish to Web Report.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lfaltran Frequent Visitor
Frequent Visitor

Re: Feature - URL Filter on "Publish to Web Report"

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

Microsoft v-jiascu-msft
Microsoft

Re: Feature - URL Filter on "Publish to Web Report"

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lfaltran Frequent Visitor
Frequent Visitor

Re: Feature - URL Filter on "Publish to Web Report"

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

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors