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