Forum Discussion
How to connect GraphApi with PBi to get complete data?
- 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.
Thanks v-csrikanth lbendlin for response.
I added a voting ticket: MS GraphApi connector for communication with Plann... - Microsoft Fabric Community.
I'm going to try to create some workaround solution based on knowledge.
And I'm going to try to create some workaround solution based on v-csrikanth recommendations and MS documentation/knowledge from the community.
v-csrikanth please, do you have any experience or recommendations for documentation that would lead me to at least some degree of success?