Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AnaG
Frequent Visitor

Need help Preload data in a table Power BI Desktop

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:

 

Error.PNG

 

I appreciate your help!

5 REPLIES 5
AnaG
Frequent Visitor

February 2023

AmiraBedh
Resident Rockstar
Resident Rockstar

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.


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

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:

Captura.PNG

I appreciate any help you can give me on this.

AmiraBedh
Resident Rockstar
Resident Rockstar

Which version of PBI you are using ?

 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

February 2023

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.