Advocate IHi v-qiuyu-msft, if I interpret your answer correctly, there are limits in both Power BI Desktop and Power BI Service when querying data. When it comes to tables, could you say anything about the number or rows and columns that are within the limits?
I noticed though that when I click refresh in Power BI Desktop, visuals that produced this error might get loaded on the second try. This indicates that there is more at play than just the amount of data returned (maybe some form of caching is involved). Do you know to what the limits apply? E.g. the server hosting SSAS, the laptop running Power BI Desktop (or the laptop with a browser going to Power BI Service), or something at Microsofts side?
I'm investigating whether I could upgrade resources to prevent this error message, I would appreciate any information about this topic.