Welcome to the guide for connecting to your OneFile BI Database. This guide is designed to ensure a smooth and secure connection process. To begin, you will need the specific credentials and database name that will be provided to you by our support team, once your organisation had purchased the Data Export (database tables). These credentials are essential for authenticating and providing read-only access to your database.
You have the flexibility to use various tools or applications to establish the connection, such as Power BI, SQL Server Management Studio (SSMS), Azure Data Studio, or any other database client that you prefer. Each of these tools offers a user-friendly interface to help you view and analyse your data effectively.
The details required to connect are:
- Server Type: Database Engine (if required)
- Server Name: onefilebi.database.windows.net
- Database Name:provided by the support team
- Username: provided by the support team
- Password:provided securely by the support team
Important
To connect to the database, please make sure access to onefilebi.database.windows.net has been granted on port 1433.
To test whether the port is open, run the following command in Windows PowerShell
Test-NetConnection -ComputerName onefilebi.database.windows.net -Port 1433
See below for step by step guidance for the examples provided:
- In PowerBI, click Get Data
- Click Azure
- Click Azure SQL Database
- Enter the Server Name and Database Name
Click OK
Click Database
Enter the provided Username and Password
Click Connect
You will now be able to see the available database tables to import, on the PowerBI Navigator screen:
Table Relationships in PowerBI:
- In SSMS Object Explorer, click Connect > Database Enginge
- Enter the Server Name
- Change the Authentication option to SQL Server Authentication
- Enter your Login (username) and Password
- Click Options
- Click Connection Properties
- Enter the Database Name
- Click Connect
You will now be able to see the available database tables in the object explorer:
Please click the following external link for guidance on Creating a Linked Server from SQL Server to Azure SQL Database.
Make sure to use the "Microsoft OLE DB Driver for SQL Server" (MSOLEDBSQL) or "Microsoft OLEDB Provider for ODBC Drivers" (MSDASQL) — not the default SQL Server provider (SQLNCLI or SQLNCLI11), which doesn't work with Azure SQL in linked servers.