The Data Warehouse is on a Microsoft Azure SQL Server hosted in Microsoft's secure cloud infrastructure. You can only access the database if you register with Integro as an approved Data Warehouse user.
There are four pieces of information you will need to access the database
- Your Office 365 username (usually your email address)
- Your Office 365 password.
- The URL of the SQL Server
- The name of your warehouse database
Connecting to the warehouse from Microsoft Power BI Desktop
Click Home -> Get Data - SQL Server, e.g. sql-integro-production.database.windows.net
Enter the Server URL and the database name: e.g. MyCompanyName_Warehouse
Click OK
Select the tables you want to load into your model
Click Load
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article