Forum Discussion
Connect Smartsheet Resource Management API to PBI
Hi RKK , Smartsheet support has confirmed through multiple threads and tickets that there is no officially supported connector for RM to Power BI. Even with a valid API key, authentication fails or endpoints return 404/500 errors when accessed via Power BI.
Currently, the only workaround is to manually export data from RM (CSV/Excel) and import it into Power BI. Smartsheet has introduced Advanced Reports in RM, which can export data to Smartsheet core. If your organization uses this, you can then use the Smartsheet (Beta) or SmartsheetGlobal connector in Power BI to access that data.
If you must use the API, you will need to build a custom connector using Power Query SDK or use an intermediate service (like Azure Functions or Power Automate) to fetch RM data and store it in a format Power BI can consume.
For reference: How can I pull reports data from Resource Management connect to Power BI? — Smartsheet Community
If you found this useful, Please mark it “Accept as Solution” to help others and give a ‘Kudos’.
Community SupportHi RKK , Thank you for reaching out to the Microsoft Community Forum.
First, make sure your API key is from Resource Management, not Smartsheet. To get one, log into Resource Management, go to My Profile -> API Access and generate a key. If you don't have access, ask your admin. Then to test it, In Power BI, go to Get Data -> Blank Query, Open Advanced Editor and paste:
let
url = "https://api.10000ft.com/api/v1/users/me",
response = Web.Contents(
url,
[
Headers = [
#"Authorization" = "Bearer YOUR_API_KEY",
#"Content-Type" = "application/json"
]
]
),
json = Json.Document(response)
in
json
If this loads your user info, the key is valid. Now pull your project data:
let
url = "https://api.10000ft.com/api/v1/projects",
response = Web.Contents(
url,
[
Headers = [
#"Authorization" = "Bearer YOUR_API_KEY",
#"Content-Type" = "application/json"
]
]
),
json = Json.Document(response)
in
json
Once it loads, click To Table, then expand the columns to see your project details.
If this helped solve the issue, please consider marking it “Accept as Solution” and giving a ‘Kudos’ so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
Hi v-hashadapu
Thank you for your guidance.
I followed your instructions and used the following query:
let
url = "https://api.10000ft.com/api/v1/users/me",
response = Web.Contents(
url,
[
Headers = [
#"Authorization" = "Bearer YOUR_API_KEY",
#"Content-Type" = "application/json"
]
]
),
json = Json.Document(response)
in
json
When prompted with "Edit Credentials," I selected Anonymous, but encountered the following error.
Error in loading the Project as well:
My Admin confirms that, API key is from Resource Management not for Smartsheet.