Publishing Power Bi Reports

Speckle Help
1

Hi i had a few queries on publishing Power Bi Reports up to a PowerBi Pro or MS Fabric Service so they can be viewed by others and refreshed on a schedule.

  • Is this possible
  • How can authentication be handled?
  • With MS Fabric it should be possible to access the data from speckle in 2 ways:
    • Dataflow (PowerQuery) → could the speckle PQ functions be available to use in this environment?
    • Python Notebook → could the specklepy sdk be the more robust option here?

Thanks

2

Hi @alex-d-richards,

We tested our product for scheduled refresh on Power BI Web and it works smoothly. You need to set up a data gateway for this.

However we didn’t test it on MS Fabric Service, so I can’t tell anything specific yet.

Could you tell me why MS Fabric Service is required in your workflow? If the goal is to publish report and set a scheduled refresh, it can be done via Power BI Web. If it’s really mandatory, we can make some tests about it.

3

Hi @dogukan sorry it might be me misunderstanding something as fairly green in terms of Power Bi Hosting.

But my assumption is that when im running Power Bi Desktop im authenticated locally through Speckle Desktop Service how does this translate to when i publish the report to a Power BI workspace? Can i use my credentials for this report to access our workspace?

hitting refresh i get the following error:

Data source error: Unable to refresh the model (id=xxxxxxxx) because it references an unsupported data source.
Cluster URI: WABI-xxxx-US-D-xxxxx-redirect.analysis.windows.net
Activity ID: xxxxxxx-xxx-xxxx-xxx-xxxxxx
Request ID: xxxxx-xxxx-xxxxx-xxxx-xxxxxx
Time: 2025-09-01 13:47:38Z

Thanks

4

Hey Alex,

Once you authenticate via Power BI Desktop and load your data, we are generating a special token in the background which enables publishing your report to the web.

To configure your scheduled refresh, you can have a look at the instructions in the following post → Auto-Refresh Data in Power BI - #6 by gokermu

If you have any further issues, reach me out and I’m happy to jump in a quick call.

2 Likes
5

We recently removed dependency for tokens for Data Gateway. You can just use your Speckle account.