


If an Encryption Support dialog box appears, select OK. Refer to Troubleshooting refresh scenarios and contact your database administrator for additional assistance. In production environments, you typically use Windows authentication. In test environments, you might use Database authentication with an explicit username and password. If you're unable to authenticate, make sure you select the correct authentication method and use an account with database access. Verify your credentials, then select Connect. We're not using Advanced options in this tutorial, but note that you can specify a SQL statement and set other options like using SQL Server Failover. In the SQL Server database dialog box, enter the Server and Database (optional) names, make sure the Data Connectivity mode is Import, and then select OK. In Power BI Desktop, on the Home tab, select Get data > SQL Server. Publish the report to the Power BI service, so that you get a dataset in Power BI, which you can then configure and refresh in subsequent steps. Use the following procedure to create a basic Power BI report using the AdventureWorksDW sample database. Create and publish a Power BI Desktop file If you're planning to use a stored procedure, you should use Import Data connectivity mode. They can create the required data source definition to connect your dataset to your SQL Server database.
#SEQUEL PRO SQL SERVER INSTALL#
If you're not a gateway administrator and don't want to install a gateway yourself, contact a gateway administrator in your organization.
