Forum Discussion

TomasGazsi's avatar
TomasGazsi
Advocate I
1 year ago
Solved

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...
Need Help
  • v-csrikanth's avatar
    v-csrikanth
    1 year ago

    Hi TomasGazsi 
    You're absolutely right in identifying the current limitations when connecting Power BI directly to Microsoft Graph API.

    1. 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.).
    2. 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.
    3. 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.
    4. 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.



TomasGazsi's avatar
TomasGazsi
Advocate I
1 year ago

Hi v-csrikanth, 
thanks for links. 

While searching for answers, I have already gone through these links. I came across a limiting factor for us at the moment, which is the type of PBi license.
We are currently using PBi premium licenses.
If I have the right knowledge, then to start Microsoft Graph Data Connect you need a license for Azure Data Factory or Microsoft Fabric.

From the materials I have studied so far, it seems to me that in order to be able to connect PBi and GraphApi, some kind of intermediate storage is needed.

For example, when using PowerAutomate and calling GraphApi (where it returns complete results), save them to Dataverse or SharePoint.
When using LogicApps and calling GraphApi, save them to, for example, Azure Data Lake Storage.

Currently, if we do not plan to change licenses and MS does not make a direct connection, the only option is to use automation and some cloud storage.

Thanks.