Visuals exceeded power bi resources

Hi Anonymous 

For Direct Query, the number of rows returned by single query cannot exceed 1 million rows. If the calculation is too complicated or the amount of data to be queried is large, the query time will be relatively long and it possibly fail. If you change the connection mode from Direct Query to Import, what you need to pay attention to is the limitation on the size of the uploaded dataset. For P1 capacity, the publish limitation is less than 3 GB. Normally, the file size is close to the size of the dataset, you can judge the size of the dataset by the file size.

When the amount of data is very large, we strongly recommend that you do some aggregation calculations in the data source in advance, delete unnecessary data and simplify the calculations in the model and the relationships between tables. This can not only shorten the response time of the interaction, but also speed up the refresh of the dataset.

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!