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?


  • Aseel Hawi
    Aseel Hawi ✭✭✭

    another attempt, another error


        apiUrl = "",

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

      headers = [




      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



  • 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.