This guide will walk you through setting up the Power BI Desktop Custom Connector with StreamBIM. Enhance your project management and data analysis in just a few steps. Let’s dive in and make your data work for you!
Note: Power BI queries created earlier than September 20th 2024 will cease to function after December 6th 2024.
To ensure your existing queries continue to work without interruption, refer to our guide on importing and re-exporting existing queries.
1. Enable PowerBI on Your Project
To enable Power BI on your project, please send an email to support@rendra.io and we’ll get you set up.
2. PowerBI Data Extention File
Download the extension file from this link.
Place the folder in %USERPROFILE%\Documents\
Create a folder named “Power BI Desktop” and a sub-folder within it called “Custom Connectors.”
Place the extension file in the “Custom Connectors” sub-folder.
3. Open PowerBI Desktop and Click on Options and settings
The few next steps, you’ll need to modify settings to allow the loading of the extension file, ensuring that your custom connector is recognized and functional.
4. Choose Options
5. Navigate to security settings and select the option to allow Data Extension loading
6. Restart of PowerBI is required after changes
7. Copy the StreamBIM query to your clipboard
StreamBIM offers multiple sources from which to copy queries, including the search function, capture table, checklist table, document overview table, and user list. This flexibility allows you to efficiently gather the data you need from various points within the platform.
8. Overview of all your PowerBI Export within StreamBIM
Overview of all your PowerBI Exports within StreamBIM, including details on who exported, the timestamp, and the content—whether it's search, checklist, document, user, or project information queries, along with descriptions for personal reference.
9. Reopen PowerBI Desktop and select Data Source "Blank Query.”
10. Navigate to the advanced editor
11. Paste the query you copied in step 7
First, delete all the content in the window, then paste in your query and click 'Done'.
12. Click "Edit Credentials."
13. Select "Anonymous" to access the web content, then click "Connect."
14. Click "Sign In"
15. Enter Your Username and Password.
Log in using the same username and password you use for StreamBIM.
16. Click "Connect"
17. Click "Continue"
18. Choose to Ignore Privacy Level and Click "Save"
We are skipping this because the credentials, including the access token, are part of the query, and we'll be connecting to the data differently by entering our username and password in step 15.
19. Your Data should Apear Like The Screenshot Below, Click "Close & Apply"
20. Future Exports to PowerBI
For future data exports to Power BI, you only need to follow steps 7, 9, 10, and 11 of this guide. For detailed guidance on these steps, please refer to the Project Exports guide.