Forum Discussion

EBWorkingItOut's avatar
EBWorkingItOut
Frequent Visitor
2 years ago
Solved

Using Graph API in Power BI and coping with pagination

Hi    We've been using an Azure Permissioned app to utilise Graph API within Power bi to track and monitor user login activity, we've been able to return a CSV file with the first 200 records using...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

aegalan's avatar
aegalan
Frequent Visitor
2 years ago

Hi! what type of connection you do in power bi to make this to work? im using the same code to get the access token and i receive this error:

DataSource.Error:Web.Contents with the Content option is only supported when connecting anonymously.

But when i try to use anonymously connection, there is another error. It seem like the connection must be windows authentication?

 

Thanks for your advice,