Forum Discussion

AnaG's avatar
AnaG
Frequent Visitor
3 years ago

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:

 

 

I appreciate your help!

Need Help

5 Replies

  • AmiraBedh's avatar
    AmiraBedh
    Icon for Super User rankSuper User
    3 years ago

    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.

    • AnaG's avatar
      AnaG
      Frequent Visitor
      3 years ago

      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.