Auto-Refresh Data in Power BI

Speckle Help
1

Hi, may I check if there is way to enable auto-refresh of the data query in Power BI?

I have tried scheduling refresh on the Power BI but there is currently this error:

image
image1273×469 28.6 KB

This feature would be helpful since we do not have to always open up Power BI to ensure the data is always updated (as per the versions in Speckle)

2

Hey @type0user1,

We’re currently investigating, and hoping to add this feature to our connector. Will ping you via this channel if there is any updates.

3

Hey @type0user1 ,

Have you installed Data Gateway for Power BI and made sure Speckle connector is in the location that Data Gateway is looking to?

I can’t seem to reproduce your issue.

4

Hi @gokermu,

I am actually not quite sure what I am supposed to do using the Data Gateway for Power BI. Do you mind going through the few steps I need to take?

I have installed and set up the Data Gateway for Power BI and also made sure the Speckle Connector is in the location its looking to but it still does not seem to be working.

image
image1818×768 50.2 KB

image
image1812×722 46.1 KB

5

Same results for the Data Gateway (Standard Mode).

image
image1463×681 46.1 KB

6

Hey @type0user1 ,

Initial Setup

  1. Install and configure Data Gateway - Sign in and verify that Speckle appears under the Connectors tab
  2. Publish your report from Power BI Desktop to the Power BI Service

Troubleshooting Gateway Connectivity

First, let’s verify the data gateway is working properly:

  1. Navigate to your semantic model in the Power BI web app

  2. Check the data gateway status

  3. If the status shows “not reachable,” this indicates a gateway connectivity issue (not Speckle-specific) → Refer to Microsoft’s documentation for gateway troubleshooting: Troubleshoot gateways - Power BI | Microsoft Learn

    image
    image840×438 14.6 KB

Configure Data Source Credentials

Since our Power BI connector currently doesn’t support OAuth2 authentication with data gateway refresh, you’ll need to use token authentication instead:

  1. In your semantic model, go to Data source credentials
  2. Switch the authentication method to Key
  3. Go to Speckle web app > Profile > Settings > Developer
  4. Create a new token with these required scopes:

Note: Additional scopes may be required depending on your specific data needs. If you encounter permissions errors, you may need to add streams:write or other relevant scopes.

Treat your API tokens like passwords - never share them publicly

  1. Copy the generated token
  2. Paste it into the Key field in the Power BI data source credentials
  3. Complete the authentication process

Your scheduled refreshes should now work properly.

7

Hi @gokermu,

I can’t seem to even access the ‘Gateway and cloud connections’ tab in the first place. May I clarify what 's going on here? Thank you!

image
image1844×514 26.1 KB