Connect to Power BI
Connect DataHawk to Power BI using pre-built templates on your Snowflake database; get up and running in under 5 minutes.
Power BI is DataHawk's recommended dashboarding tool. DataHawk provides ready-to-use Power BI templates built on top of your Snowflake database.
You can be up and running in under 5 minutes.
Prerequisites
Before connecting Power BI, make sure you have:
- Data sources connected: Your Amazon and/or Walmart accounts are connected and collecting data. If not yet, see Set up data first.
- A DataHawk Snowflake database: Activated and showing Enabled in your DataHawk App. Provisioning can take up to 4 hours. See Send data to your tool if you haven't set one up.
- Your Snowflake credentials: Available from Settings → Destinations → Snowflake → See Credentials in the DataHawk App.
Option 1 — Use a DataHawk template
DataHawk provides pre-built Power BI templates in .pbix format. See Download Power BI Templates for the full catalog and download link.
| Template | What it covers |
|---|---|
| Seller Finances & Supply Chain | SKU-level profit, orders, unit economics, replenishment |
| Product | Ratings, BSR, price, LQS, sales, estimates, buy box |
| Search | Share of voice, search ranks, keyword research |
| Advertising | Account, campaign, product, and keyword ads |
| Market Intelligence | Top-selling products, category analysis, market size and share |
| Master Vendor | Revenue, COGS, inventory, ads, share of voice |
| DSP Ads | Advertiser, order, line item, and creative ads |
Set up on Power BI Desktop
Estimated time: under 5 minutes.
Open the template
Open the .pbix template file in Power BI Desktop.
Open the Power Query Editor
In the Home tab, click Transform data.
Open Manage Parameters
Click Manage Parameters.
Paste your Snowflake credentials
Replace the values for Database, Server, and Warehouse with your DataHawk Snowflake credentials.
Apply
Click Close & Apply.
Sign in to Snowflake
Enter your Snowflake username and password when prompted.
Wait for the refresh
Data will begin refreshing. This can take up to 30 minutes depending on your data volume.
If you run into a refresh error, try closing and re-applying the parameters once or twice, then contact the DataHawk team if the issue persists.
Publish to Power BI Online (for sharing and scheduled refresh)
Estimated time: under 5 minutes.
One-time admin step required: Before publishing templates to Power BI Online, a Power BI administrator must enable Snowflake SSO in your tenant.
- Go to app.powerbi.com/admin-portal
- Navigate to Tenant Settings
- Find Snowflake SSO, expand it, and enable the toggle
- Allow a few hours for the change to propagate across your organization
Once SSO is enabled:
Open a Power BI workspace
Go to app.powerbi.com and navigate to a workspace (or create one).
Upload the template
Click Upload → Browse and select your .pbix template file.
Open the dataset settings
Hover over the newly uploaded dataset, click the ⋯ menu, and select Settings.
Paste your Snowflake credentials
Under Parameters, replace Database, Server, and Warehouse with your DataHawk Snowflake credentials.
Sign in to Snowflake
Under Data source credentials, click Edit credentials and enter your Snowflake username and password.
Enable scheduled refresh
Under Refresh, enable the auto-refresh toggle and set it to run daily.
Wait for the first refresh
Data will begin refreshing. This can take up to 30 minutes.
Open the report
Once refreshed, navigate back to your workspace to open the report.
Option 2 — Build your own reports
If you prefer to build from scratch or connect an existing Power BI file to your DataHawk data, follow the steps below.
DataHawk's Power BI templates use DirectQuery mode. If you plan to build your own reports, the same mode is recommended to ensure your data stays live.
Connect via Power BI Desktop
Find the Snowflake connector
Click Get Data → More, search for Snowflake, and click Connect.
Enter Server and Warehouse
Paste the Server and Warehouse values from your DataHawk Snowflake credentials page.
Select authentication mode
Choose Database as the authentication mode.
Sign in to Snowflake
Enter your Snowflake username and password.
Pick your data
Browse the schemas and tables, or write a custom SQL query.
Load
Click Load (or Transform Data to filter before loading).
Connect via Power BI Online
Before connecting via Power BI Online, you need to enable Snowflake SSO in your Power BI tenant. This is a one-time admin step.
Admin required: You must be an administrator of your Power BI instance to complete this.
- Go to app.powerbi.com/admin-portal.
- Navigate to Tenant Settings.
- Find Snowflake SSO, expand it, and enable the toggle.
- Allow a few hours for the change to propagate across your organization.
Once SSO is enabled, upload your .pbix file and point the parameters (Database, Server, Warehouse) to your DataHawk Snowflake credentials.
Going deeper
Once connected, head to the dashboard guides for help using and interpreting what you see.
Seller Analytics Dashboard
SKU-level sales, traffic, profit, and unit economics for Seller accounts.
Advertising Dashboard
Account, campaign, product, and keyword performance for Amazon Ads.
Vendor Analytics Dashboard
Revenue, COGS, inventory, and ads for Vendor accounts.
Market Intelligence Dashboard
Top-selling products, category analysis, market size and share.
Product Dashboard
Ratings, BSR, price, listing quality, sales estimates, and Buy Box per product.
Ads DSP Dashboard
Advertiser, order, line item, and creative performance for DSP.