https://community.fabric.microsoft.com/t5/Report-Server/Refresh-fail-Invalid-JSON-data-loads-in-power-query-but-fails-to/m-p/3281217#M30105 <P>The preview window only loads a subset of the data. This possibly means that you have some invalid data later in the data source.</P> Tue, 13 Jun 2023 08:47:35 GMT d_gosbell 2023-06-13T08:47:35Z https://community.fabric.microsoft.com/t5/Report-Server/Refresh-fail-Invalid-JSON-data-loads-in-power-query-but-fails-to/m-p/3275832#M30058 <P>My refresh is failing but my data loads just fine in the Power Query preview section. All I'm doing is appending a query to a table then removing duplicates. any idea why this report refresh is failing? I'm not doing anythign special other than putting two tables together, then removing any duplicates. Any help would be appreciated!</P><P><img /></P><P>&nbsp;</P> Fri, 09 Jun 2023 04:03:38 GMT https://community.fabric.microsoft.com/t5/Report-Server/Refresh-fail-Invalid-JSON-data-loads-in-power-query-but-fails-to/m-p/3275832#M30058 unicorns 2023-06-09T04:03:38Z https://community.fabric.microsoft.com/t5/Report-Server/Refresh-fail-Invalid-JSON-data-loads-in-power-query-but-fails-to/m-p/3281217#M30105 <P>The preview window only loads a subset of the data. This possibly means that you have some invalid data later in the data source.</P> Tue, 13 Jun 2023 08:47:35 GMT https://community.fabric.microsoft.com/t5/Report-Server/Refresh-fail-Invalid-JSON-data-loads-in-power-query-but-fails-to/m-p/3281217#M30105 d_gosbell 2023-06-13T08:47:35Z