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.
     



Shai_Karmani's avatar
Shai_Karmani
Super User
3 months ago
 

Hey, the native Power BI and Power Automate Smartsheet connectors are US/EU only and the regions are fully separate islands with their own tokens.

 

A few options that should work:

Power Query against the AU API (https://api.smartsheet.au/2.0) with a PAT from inside the AU instance:

e.g.
Web.Contents("https://api.smartsheet.au", [    RelativePath = "/2.0/sheets/" & SheetId,    Headers = [ Authorization = "Bearer " & Token ]])

Use BaseUrl + RelativePath (not string concat) or Service refresh breaks. Set creds to Anonymous + Skip test connection.

Past a few sheets, I'd skip Power Query and load to a Lakehouse via a Fabric notebook (smartsheet-python-sdk

takes an api_base override), then go Direct Lake. Cleaner and you get proper backoff for the 300 req/min limit.

Power Automate: HTTP action (premium) with a Bearer token. You lose the native triggers, so pair with a Smartsheet webhook into a Logic App if you need push.

Third-party: CData and ZappySys let you set the base URL, just verify they officially support AU before paying.

Gotchas: AU PAT only sees AU data, multi-contact and formula columns are painful to flatten, Direct Query over the API isn't realistic so plan on Import or land-to-warehouse.

Worth raising a Fabric Ideas post for an AU toggle. The EU one has been sitting there forever, but more noise can't hurt.


If this helped, a thumbs up and accepting the solution would be appreciated.

 

Best,
Shai Karmani

Let's connect in LinkedIn