Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone!
I am coming across a couple of issues with making the reports visible to our customers.
So the first issue I am facing, is when I embed the report on our website, it is asking for a sign-in. I understand that publishing it to web would resolve that issue, but that's not an option since we are dealing with sensitive data. Is there a way to disable that, or at least automatically sign user into an account in the backgroud?
The 2nd issue that I am facing is to do with passing filters in the URL. As suggested in Microsoft Docs, I am using
URL?filter=Table/Field eq 'value'
So my URL would look like URL?filter=store_master/customer_id eq 11
However when I do that, I do see a field added in the filters section, but it has a yellow exclamation mark and says that "This filter came from a query string parameter that was added to a report URL." and the value assigned to it is (All) instead of the 11 specified in the URL.
Am I missing something very obvious?
Thank you for any assistance.
Solved! Go to Solution.
Refer to this https://powerbi.microsoft.com/en-us/blog/easily-embed-secure-power-bi-reports-in-your-internal-porta...
As per the below blog, field type should be a string. So can you create a calculated column to convert the whole number to text and see if it is working?
https://powerbi.microsoft.com/en-us/blog/filter-a-report-with-a-url-query-string-parameter/
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Since you are using secure embed, it will ask sign-in.
You can explore the Power BI embedded. https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedding
Regarding your 2nd question
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Thank you for your reply @nandukrishnavs . Is there no way to bypass the sign-in screen without Power BI Embedded? Are there no APIs that I can use to perform a Sign-In in the background?
With my filters issue, I understand that table and field names are case sensitive. I am assuming that Power BI is recognizing the field that I am looking for, as it does appear in the Filters pane on the right hand side. The problem seems to be that the value is not getting assigned to it. The type of customer_id is whole number, so the way I have in my URL, without single quotes, should work fine.
Refer to this https://powerbi.microsoft.com/en-us/blog/easily-embed-secure-power-bi-reports-in-your-internal-porta...
As per the below blog, field type should be a string. So can you create a calculated column to convert the whole number to text and see if it is working?
https://powerbi.microsoft.com/en-us/blog/filter-a-report-with-a-url-query-string-parameter/
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
@nandukrishnavs still no luck with the filters.
Now, in the fields section, the table name is godigitally_easycoun_st store_master. I pressume that I use the whole name in the string query, which is godigitally_easycoun_st store_master, rather than just store_master? I've tried both ways though and every time I am ending with a field with a yellow exclamation mark set to (All).
@artlemaks Try to remove the special characters from the tables and columns and try again with sample dataset.
@nandukrishnavs special characters being white spaces? I can't think of any other special characters that I might have in the dataset.
@artlemaks For example
godigitally_easycoun_st store_master ==> godigitallyeasycounststoremaster
Special characters and spaces in table and column names require some additional formatting.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
@nandukrishnavs okay, so that worked! I can use the query string in the URL and adjust the filters that way when working on the Power BI dashboard online.
Now, when it comes to implementing it into the iFrame. Is it just a matter of doing the following
&filter=storemaster%2Fcustomer_id_str%20eq%20%27<? echo $customer_id; ?>%27 ? I have copied the string from my browser and pasted into the embeded URL in the iFrame. So all I have done was replaced this filter=storemaster%2Fcustomer_id_str%20eq%20%2715%27 with the code above, because $customer_id in the example that I am testing is 15. However, that shows me no results. Am I being too optimistic with trying to do it that way?
@artlemaks Copy your iframe URL and test it before embedding the report. Go through this https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters and make sure you are not doing any manual errors.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.