Datasource is too large.

[Anonymous]

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, but there are over 26 million rows.
There are also some restrictions on the tables from dataflow. 
I'm querying them all on the Oracle database.
If it's worth saying I'm a Pro user.

My question is, below is just a table with arreas by week number, and how come it won't load?
What should I do to have a dataset where I can have historical data? I've seen sales reports showing data from 2017 to date.

Many thanks in advance!

[Anonymous]

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

Enable large datasets

Best Regards