The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I'm using Power BI with the web-based report editor, to show Azure Audit Logs.
I managed to use query string filters for my other reports (app.powerbi.com/groups/me/reports/guid/reportsection?filter=table/column eq 'value'), but when I try to use it for the Azure Audit Logs dataset, it doesn't work.
I read somewhere that table names cannot have spaces, unfortunatelly, the name I get when I add the service has spaces in it.
I tried renaming the dataset, but the table name that shows in the report editor doesn't change, and still has spaces.
What is the correct way to use query string filters in this case?
Thanks,
Ido.
God bless you! 🙂
Thank you!! This was a big sticking point for me and really helped!
I'm also stuck on the values filtering by a whole number (it works if its text, but the number... ) Any ideas on how to solve that?
Organization/Organization_x0020_ID eq '12345'
Hi. You showed an example of column name with spaces in column name but does it work with spaces in table name?
eg:
my table name is "Cliente Storico Segmentazione"
my column name is "Segmentazione"
but Cliente_x0020_Storico_x0020_Segmentazione/Segmentazione doesn't seem to work .
😞
I had extra spaces..removing them now it works with _x0020_ also in table name!!!
Thanks a lot!
Fixed. Just drop the '
Organization/Organization_x0020_ID eq 12345
The space does stop the filter from working based on my test. Per my experience, appending a filter querystring is very limited. You can the same thing by applying a report-level filter. May I know why filter in url is prefered?
I want to create something like this:
1. Create an alert for a value
2. Use Microsoft FLOW to send an email when this value reached a threshold
3. In the email, include a URL to a different report, with a filter in the URL that matches the threshold value (greater than)
Is there an alternative on how to pass dynamic parameters to reports? without needing to manually filtering it?
I'm afraid there's no way then. By the way, in your original post, you said that renaming a table doesn't work, what is the exactly scenario?
I clicked the ellipsis next to the dataset and renamed it. However, when I click it to create a report, the name of the table remains with spaces. It seems the rename is only for display purposes.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
12 | |
3 | |
3 | |
2 |