Knowledge base

Power BI

Getting your data into Power BI is nice and easy with SyncHub. First, you'll need to get your database credentials from SyncHub: 1. Log in to SyncHub and head to the **Connections** page 2. Click the **Dashboard** for any of your connections (it doesn’t matter which one) 3. Click **Start Reporting** 4. Click **View Credentials** 5. Enter your password Those are your database credentials. Now, go ahead and enter them into Power BI: 1. Launch Power PI and click on the **Get Data** dropdown, then click **More…** 2. Select **Azure** from the left hand panel, then **Azure SQL Database**, then **Connect** 3. Copy and paste the relevant credentials into the Server and Database fields, and select **Import** for the Data Connectivity mode, then click **OK** 4. Select **Database** from the left hand panel and enter the username and password from your credentials, then hit **Connect** All done! Now you can build custom reports and dashboards using data from across all your connections – without the need for manual importing. #### Troubleshooting If you're receiving an error message when trying to get your data into Power BI, it may be because the database credentials were entered incorrectly. Before trying again, please clear the data source credentials saved by Power BI: Go to **File** > **Options & Settings** > **Data Source Settings**. From the **Global permissions** list, select any references that include "synchub" and click **Clear permissions**. Now try re-entering your database credentials following the steps above.