Forum Discussion
TomasGazsi
1 year agoAdvocate I
How to connect GraphApi with PBi to get complete data?
Hi, can anybody give me advice how to use MS GraphApi as datasource in PowerBi? What is the purpose of my report? - I need get all tasks of Planner. Plan ID is SbuxRYX9cUuekCEIBEiv05gAAlg8. Wh...
- 1 year ago
Hi TomasGazsi
You're absolutely right in identifying the current limitations when connecting Power BI directly to Microsoft Graph API.- Power BI doesn’t have a native Graph API connector, so an intermediate storage layer (like Dataverse, SharePoint, or Azure Data Lake) is required, depending on the tool (Power Automate, Logic Apps, etc.).
- Microsoft Graph Data Connect (MGDC) needs a Microsoft Fabric or ADF license—Power BI Premium alone isn’t enough. MGDC is built for large-scale, governed data extraction into Azure storage, not direct Power BI use.
- If upgrading licenses isn’t an option, the best workaround is automation: use Power Automate or Logic Apps to pull Graph data and store it where Power BI can access it.
- For small, non-real-time needs, exporting to CSV in SharePoint or OneDrive works well with scheduled refresh.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.
lbendlin
1 year agoSuper User
There is no official connector, and the documentation also states that only the /groups endpoint is semi-supported.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com