Change data source - PowerBI

Help
1

Hi everybody !

Does anyone know how to change the data source in power bi ?

image
image877×710 25.9 KB

I created a report with one stream. I duplicated it. I would like to change the data stream to link my report to the data of a new model…

Thanks !!

1 Like
2

As the Speckle data connector is different to a typical DB connection, you can change the source manually in PowerQuery

  1. Open Power BI Desktop and load your report.

  2. Navigate to the Home tab in the ribbon.

  3. Click on “Transform data” to open the Power Query Editor.

  4. In the Power Query Editor, locate your existing query in the Queries pane on the left side.

  5. Select the query that is connected to your Speckle data source.

  6. In the formula bar at the top, you will see something similar to what you’ve shown in the image:

    = Speckle.GetByUrl("https://app.speckle.systems/projects/e0e2367c47")

  7. Edit the URL to point to your new data stream. For example:

    = Speckle.GetByUrl("https://app.speckle.systems/projects/new_project_id")

  8. Press Enter to apply the changes.

  9. Refresh the data in the Power Query Editor to ensure the changes take effect.

  10. Close the Power Query Editor and apply the changes when prompted.

This method directly changes the source URL for your Speckle data connector, and your report should be updated to use the new data stream.

3 Likes
3

In addition to @jonathon 's reply, you can create a Power BI parameter and use it in the Speckle.GetByUrl() function. Here’s a tutorial that shows how to use Power BI parameters: