Using Graph API in Power BI and coping with pagination

Hi EBWorkingItOut ,

It seems that the error you're encountering is due to the Graph API endpoint not supporting JSON format for the specific report you're trying to access. The Graph API has different endpoints, and not all of them support JSON format for all types of reports.

However, if you're working with an endpoint that does support JSON, you need to remove the ?$format=text/csv from your URL and ensure your headers are set to accept JSON. In this case, since you're getting an error that "JSON format is not supported," it's likely that the endpoint doesn't support JSON for the report you're requesting.
So please verify if the endpoint supports JSON format for the data you're trying to retrieve.
If it does, adjust your Power Query to remove ?$format=text/csv and ensure your headers are set to accept JSON.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.