Forum Discussion

MattB-Motive's avatar
MattB-Motive
Resolver I
3 months ago
Solved

Connecting to Australian-hosted Smartsheet data

Just wondering if anyone has had experience connecting to Australian-hosted Smartsheet data. The standard/native Power BI connector only allows you to specify either US or EU locations - no AU. If...
Need Help
  • v-karpurapud's avatar
    v-karpurapud
    3 months ago

    Hi MattB-Motive 

    We understand your concern. With AU-hosted Smartsheet, the connection works differently because it’s considered a separate regional instance, so native connectors aren’t applicable.

    You’ll need to use the AU-specific API endpoint and token, since there’s no cross-region connectivity between AU and US/EU environments. Most setups use the REST API instead of the standard connector.

    For Power Automate, the HTTP action works with the AU endpoint, but it’s generally used for simpler cases.

    Here are some community threads where API-based solutions have been implemented:
    Solved: Connecting Multiple Smartsheets - Microsoft Fabric Community
    Solved: Connect Smartsheet Resource Management API to PBI - Microsoft Fabric Community

    I hope this clarifies the situation. If I’ve misunderstood any part of your situation, please let us know.

     Regards,
    Microsoft Fabric Community Support Team.
     



oussamahaimoud's avatar
oussamahaimoud
Memorable Member
3 months ago

Hi MattB-Motive,

Hope you are doing well!

 

Smartsheet REST API via Power Query Web Connector
The AU region API base URL is https://api.smartsheet.au/2.0 (Smartsheet), this is the key piece. Since it's a standard REST API, you can call it directly from Power BI using the Web connector in Power Query:
Generate an API token from your AU Smartsheet account
Use Web.Contents() in Power Query M, passing the AU base URL with Authorization: Bearer <token> in the headers
Call endpoints like /sheets, /sheets/{id}, /reports/{id} etc.
This is the most reliable, no-third-party-dependency solution and is fully supported in both Power BI Desktop and the Service (via On-premises Data Gateway or callable directly from Power BI Service with web credentials).
Note: AU accounts use a separate API token from your Smartsheet.com credentials, you must generate a token specifically within the AU instance. (Smartsheet)

 

Power Automate HTTP Action (for AU Region)

As a workaround for the standard connector's limitations, making direct REST API calls via Power Automate's HTTP step works well, you build each call manually and handle Bearer token auth in the headers. (Smartsheet Community) Point this at https://api.smartsheet.au/2.0/... instead of the standard URL. This is confirmed working for AU.

 

Remember:

For Power BI, go with the REST API via Web connector approach because it's free, maintainable, and gives you full control. For Power Automate, use the HTTP action with the AU base URL and Bearer token. Avoid the native connector entirely for AU-hosted data.

 

For more information :

No cross-region sharing: The AU instance is a completely isolated data island, you cannot share assets between AU and US/EU instances. (Smartsheet)

Gateway requirement: If using the Web connector approach in Power BI Service scheduled refresh, you'll need an On-premises Data Gateway configured with stored credentials (Bearer token), or use Fabric Dataflow Gen2 with the anonymous/API key web source.

Token management: AU API tokens expire/rotate and need to be managed separately from any US Smartsheet credentials your org may also use.

SDKs need reconfiguring: If you use a Smartsheet SDK, you must modify the standard config to point to smartsheet.au. (Smartsheet)

 

Hope this helps! Don't forget to mark as solution and thumbs up, that's motivate me to keep helping 🙂