Help resolving "Error fetching data for this visual"

Hi ERing ,

DirectQuery defines a limit of 1 million rows for data returned from cloud data sources that are not local to any data source. Local sources are limited to a defined payload of approximately 4 MB per row (depending on the proprietary compression algorithm) or 16 MB (for the entire visual object).

Premium capacity allows you to set a different maximum row limit, and Power BI Premium capacity settings are provided in the portal, preloaded with default values. Administrators can view and override the defaults based on their preferences to better protect their capacity from issues and avoid problems before they arise.

More detailed information can be found at the link:
Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn
Power BI Premium new capacity settings allow for more control over datasets | Microsoft Power BI Blog | Microsoft Power BI

Here is another solution to a problem similar to yours:

Solved: The resultset of a query to external data source h... - Microsoft Fabric Community

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.