Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
In a report in Power BI Desktop, I am using the visual "Filter By List By" to search a database, the result of the query is displayed in a table, from this table I am using a drill trhouh button to link with other tables the result of the query. However, when the search does not return results, the table preloads approximately the first 500 records available in the database. I need to hide and/or restrict that data preload:
I appreciate your help!
February 2023
Select the table visual that is showing the preloaded data and in the Visualizations pane, go to the "Format" section. You need to expand the "Table" option and scroll down to find the "Data" section.
Under the "Data" section, turn off the "Allow Previews" option.
Thanks AmiraBedh for you answer!, however for my visual, in the Format section I don't see the "Table" option, I don't see any option "Allow previews" either, I share you the menu that appears:
I appreciate any help you can give me on this.
Which version of PBI you are using ?
February 2023