Forum Discussion
Datasource is too large.
Hello guys, My dataset is a mixed storage mode, where 6 tables come from Dataflow and one table is the direct query. The DQ table is restricted by the data column bringing data from 2020 onwards, ...
Hi Anonymous ,
According to the error message, the result set returned by your visual query exceeds the maximum limit of 100,0000. Could you please provide the fields referenced by your table visual and the amount of data in the table where the fields are located? If the amount of table is too large, can we add some filter on the visual? Before that, is it possible to refer to the following document for some optimization of your report?
Optimization guide for Power BI
Power BI Performance Tips and Techniques
In additon, please review the following links and check whether they can give you any other insight or clue.
Considerations and limitations to using DirectQuery
Direct Query 1 million row limitation in Power BI Premium workspace
Best Regards