Working with database

Hi All,

I am working on large tables with millions of rows. i have tried to use Direct query but its seems to have lot of constraints. now i have imported some data based on a filter and did my data model. now after publishing it to service, how do i remove the filter i used so that it get all the data from the data base. please can i get some help around this.


You would have to remove the filter within your Power BI Desktop file.

You will find that the constraints won’t go away though, so I’m not sure this will achieve what you’re looking for.