Forum Discussion

toms20's avatar
toms20
New Member
6 years ago
Solved

Executive Reports for Microsoft Planner

I would like to use the Executive Reports for Microsoft Planner app within Power BI to produce reporting for Microsoft Planner.  After installating the app it states " You're viewing this app with sample data. To view your own data, connect and wait for the refresh to complete, then reload the page." Selecting Connect produces a dialog box requesting the URL to Planner's data with OData interface with the following example https://<datamart.site.com>/@<tenant_name>/_odata/Planner.  I know the teanant name but not sure why I need <datamart.site.com>.  I've tried several differnent way but with no success.  

 

Any assistance would be appreciated.  

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi toms20 ,

     

    After you have created a new plan,open it,then you will fine the URL in the address bar,just copy it.

    See what I've marked in red line below:

     

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

7 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi toms20 ，

     

    No need,just fill in with the parameters it requires, where I highlighted in red line,no matter whether it has a default  value,you need to re-write in again.

    Then sign in with your account and password.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

    • toms20's avatar
      toms20
      New Member
      6 years ago

      Thank you for the reply.  I am still having issues.  Can you tell me where to find the URL to Planner's data with OData interface which is needed for the first entry box.

      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi toms20 ,

         

        After you have created a new plan,open it,then you will fine the URL in the address bar,just copy it.

        See what I've marked in red line below:

         

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!
  • diegoadum's avatar
    diegoadum
    Icon for Helper I rankHelper I
    5 years ago

    Hi there! Did you be able to connect to it? I'm having the same problem,but I'm getting this error: 

    Failed to update data source credentials: OData: The given URL neither points to an OData service or a feed: 

  • motogrrl's avatar
    motogrrl
    Regular Visitor
    2 years ago

    If you are connecting to an environment that is managed and they have not registered or allowed for Odata connections to the Planner data, you will need to ask your administrator to set it up for you.  In addition, it will likely not support Anonymous connections - you will need to at least choose Basic and enter in your company user id and password and then choose "Organization" for the Privacy level. If that does not work it is likely that the data is not accessible to you - either based on license or due to restrictions within the company.