How to get data from snowflake to Power BI

-

Supported capabilities

  • Import
  • DirectQuery (Power BI semantic models)
  • Advanced options
    • Specify a text value to use as Role name
    • Relationship columns
    • Connection timeout in seconds
    • Command timeout in seconds
    • Database
    • Native SQL statement

Connect from Power Query Desktop

To make the connection to a Snowflake computing warehouse, take the following steps:

  1. Select Get Data from the Home ribbon in Power BI Desktop, select Database from the categories on the left, select Snowflake, and then select Connect.

Screenshot of the Get Data dialog, showing the Snowflake database selection.

  1. In the Snowflake window that appears, enter the name of your Snowflake server in Server and the name of your Snowflake computing warehouse in Warehouse.

  1. Optionally, enter values in any advanced options that you want to use to modify the connection query, such as a text value to use as a Role name or a command timeout.
  2. Select OK.
  3. To sign in to your Snowflake computing warehouse, enter your username and password, and then select Connect.

Screenshot of the Snowflake credential prompt, showing the Username and Password fields.

Note

Once you enter your username and password for a particular Snowflake server, Power BI Desktop uses those same credentials in subsequent connection attempts. You can modify those credentials by going to File > Options and settings > Data source settings.

If you want to use the Microsoft account option, the Snowflake Microsoft Entra ID integration must be configured on the Snowflake side. In Navigator, select one or multiple elements to import and use in Power BI Desktop. Then select either Load to load the table in Power BI Desktop, or Transform Data to open the Power Query editor where you can filter and refine the set of data you want to use, and then load that refined set of data into Power BI Desktop.

Screenshot of the Navigator with the test schema database open and the DimProduct table selected.

  1. Select Import to import data directly into Power BI, or select DirectQuery, then select OK.

Note

Microsoft Entra ID single sign-on (SSO) only supports DirectQuery.

Screenshot of Connection settings, which contains the Import and DirectQuery selections.

Connect from Power Query Online

To make the connection, take the following steps:

  1. Select the Snowflake option in the connector selection.
  2. In the Snowflake dialog that appears, enter the name of the server and warehouse.

Screenshot of the Snowflake connection builder in Power Query Online.

  1. Enter any values in the advanced options you want to use. If there are any advanced options not represented in the UI, you can edit them in the Advanced Editor in Power Query later.
  2. Enter your connection credentials, including selecting or creating a new connection, which gateway you would like to use, and a username and password.
  3. Select Next to connect to the database.
  4. In Navigator, select the data you require, then select Transform data to transform the data in Power Query Editor.

Screenshot of the online Navigator with the test schema database open and the DimProduct table selected.

 

Comments

  1. Siva NagaMon Oct 26, 05:51:00 pm

    Nice Blog. Thanks for sharing this post

    Power BI with AI Training
    AI With Power BI Course
    Power BI Training with AIe
    Power BI Classes Online
    Power BI Training Course
    Power BI Training with AI

    ReplyDelete
    Replies
    1. Balu ChallaMon Oct 26, 09:02:00 pm

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete
  2. DeviTue Oct 27, 11:23:00 am

    “This article provides a clear understanding of the topic. I especially appreciate how the concepts are explained in a practical and easy-to-follow manner.” ms azure data factory online training

    ReplyDelete
    Replies
    1. Balu ChallaTue Oct 27, 07:12:00 pm

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete

Post a Comment

Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You

Popular posts from this blog

Exception deserializing the package "The process cannot access the file because it is being used by another process."

-
TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got...
Read more

Failed to execute the package or element. Build errors were encountered

-
Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package
Read more

Temporary enable and disable SSRS subscriptions

-
--Code Snippet --To Check Subscription Status. USE ReportServer GO SELECT dbo . Subscriptions . Description ,        dbo . [Catalog] . Name ,        dbo . Users . UserName ,        InactiveFlags FROM dbo . Subscriptions      INNER JOIN dbo . [Catalog]      ON dbo . Subscriptions . Report_OID = dbo . [Catalog] . ItemID      INNER JOIN dbo . Users      ON dbo . Subscriptions . OwnerID = dbo . Users . UserID --Temporary disables subscriptions while data warehouse is unavailable UPDATE dbo . Subscriptions SET InactiveFlags = 1 GO --After this you can find, all the subscription where disabled until you again enable it. --Again enable subscriptions. UPDATE dbo . Subscriptions SET InactiveFlags = 0 GO
Read more