How can I pull reports data from Resource Management connect to Power BI?

I'm not a developer and my knowledge of APIs are limited.

I'm working on getting data from the resource management tool to power bi. I was able to pull all data, except for reports. I know I have to do a POST request, which I'm trying for the first time. I did run this query and I'm still getting errors.

I'm getting this message "We couldn't authenticate with the credentials provided." my credentials are set anonymous.

What am I doing wrong?

Answers

  • Aseel Hawi
    Aseel Hawi ✭✭✭

    another attempt, another error

    let

        apiUrl = "https://api.rm.smartsheet.com/api/v1/reports/rows",

      apiToken = "XXXXXX", // Replace with your Smartsheet API token

      headers = [

        #"Content-Type"="application/json",

        #"auth"=apiToken

      ],

      queryParams = [

        view = "time_fees_hours",

        time_frame = "this_week",

        group_by = {"project_id"},

        today = DateTime.ToText(DateTime.LocalNow(), "yyyy-MM-dd"),

        calc_incurred_using = "confirmed-unconfirmed"

      ],

      response = Json.Document(Web.Contents(apiUrl, [Headers=headers, Query=queryParams])),

      data = response

    in

      data


  • Hamza1
    Hamza1 Moderator

    Hi @Aseel Hawi,

    I see that you’ve opened a Support ticket. The integration between Power BI and Resource Management by Smartsheet is currently not supported in Smartsheet. When you have a moment, please submit your feature request to the Product team by creating an Idea post in the Smartsheet Product Feedback and Ideas topic.

    Cheers,

    Hamza