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
Hi All,
I am trying to get all my team mates tickets information to be fetched in the Power BI Desktop Application through Sharepoint where the tickets are showing right in the Power BI Desktop.
When I try to publish the same Report into the Power BI Web its not working properly with respect to the Filters.
Currently I am making the report to refresh for 3 times a day.
Tried Troubleshooting:
Tried to publish the report once again from my Power BI Desktop where the Slicer have the Engineers name to filter the 30 days aged tickets.
The tickets are not getting filters for the Engineers whom i am selecting but if I refresh the data in the Power BI Desktop its working perfectly but not working as expected in the Power BI Web Visual.Anyone faced the same issue ?
Solved! Go to Solution.
Hi, @Lakshmana01
Thanks for the reply from @audreygerred , please allow me to provide another insight:
Because you've set your report to refresh 3 times a day, make sure that the refresh schedule is configured correctly in the Power BI service. Sometimes, discrepancies in data refresh can cause unexpected behavior in filters. For more information about setting up scheduled refresh, visit Configure scheduled refresh:
Configure scheduled refresh - Power BI | Microsoft Learn
Make sure that filters and slicers are configured correctly in the report. Keep in mind that slicers behave differently in Power BI Desktop and the Power BI service. For detailed guidance on adding and configuring filters, see Add filters to a report:
Add a filter to a report in Power BI - Power BI | Microsoft Learn
If you're using the Publish to Web feature, note that it doesn't display the Filters pane. Instead, consider adding a slicer for filtering, as described in Publish to the web from Power BI:
Format filters in Power BI reports - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Lakshmana01
Thanks for the reply from @audreygerred , please allow me to provide another insight:
Because you've set your report to refresh 3 times a day, make sure that the refresh schedule is configured correctly in the Power BI service. Sometimes, discrepancies in data refresh can cause unexpected behavior in filters. For more information about setting up scheduled refresh, visit Configure scheduled refresh:
Configure scheduled refresh - Power BI | Microsoft Learn
Make sure that filters and slicers are configured correctly in the report. Keep in mind that slicers behave differently in Power BI Desktop and the Power BI service. For detailed guidance on adding and configuring filters, see Add filters to a report:
Add a filter to a report in Power BI - Power BI | Microsoft Learn
If you're using the Publish to Web feature, note that it doesn't display the Filters pane. Instead, consider adding a slicer for filtering, as described in Publish to the web from Power BI:
Format filters in Power BI reports - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi! What error are you seeing in service? Is the semantic model successfully refreshing in service?
Proud to be a Super User! | |
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 |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
124 | |
111 | |
78 | |
78 |