cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
system243trd
Frequent Visitor

Power BI Snowflake user access connection issue

We are having issues refreshing Snowflake data in Power BI using different Snowflake logins for each area of the business (e.g. IT login, HR Login).

 

We have a workspace for HR and one for IT that contains a dataset and reports that only relate to the relevant area.  The Snowflake user for HR can only view HR data and IT can only view IT data.

 

When we enter the Data Source credentials for the IT workspace to the refresh this data the HR data stop working, and vice versa.   Even though the datasets are named differently and in different workspaces they seem to be using the same login credentials.  Is there anyway that we can user different Snowflake logins in Power BI online?

1 ACCEPTED SOLUTION
v-caitlyn-mstf
Community Support
Community Support

 

Hi @system243trd,

 

After a report that is based on the Snowflake connector is published to the Power BI service, the dataset creator has to update settings for the appropriate workspace so that it will use SSO.

Because of the way that Power BI works, SSO will only work when no data sources are run through the on-premises data gateway. Limitations are listed below:

  • If you're using only a Snowflake source in your data model, then you can use SSO if you choose not to use the on-premises data gateway.
  • If you're using a Snowflake source and another source, then you can use SSO if none of the sources use the on-premises data gateway.
  • If you're using a Snowflake source through the on-premises data gateway, AAD credentials aren't currently supported. This consideration might be relevant in case you're trying to access a VNet from a single IP with the gateway installed on it, rather than from the entire Power BI IP range.
  • If you're using a Snowflake source and another source that requires a gateway, you need to use Snowflake through the on-premises data gateway as well. You won't be able to use SSO in this case.

 

If you aren't using the gateway, you're all set. When you have Snowflake credentials configured on your on-premises data gateway, but are only using that data source in your model, you can click the toggle on the Dataset settings page to turn off the gateway for that data model.

 

 

For more information, you can refer to:

Connect to Snowflake in Power BI Service 

 

Snowflake troubleshooting guide 

 

Hope it helps,


Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-caitlyn-mstf
Community Support
Community Support

 

Hi @system243trd,

 

After a report that is based on the Snowflake connector is published to the Power BI service, the dataset creator has to update settings for the appropriate workspace so that it will use SSO.

Because of the way that Power BI works, SSO will only work when no data sources are run through the on-premises data gateway. Limitations are listed below:

  • If you're using only a Snowflake source in your data model, then you can use SSO if you choose not to use the on-premises data gateway.
  • If you're using a Snowflake source and another source, then you can use SSO if none of the sources use the on-premises data gateway.
  • If you're using a Snowflake source through the on-premises data gateway, AAD credentials aren't currently supported. This consideration might be relevant in case you're trying to access a VNet from a single IP with the gateway installed on it, rather than from the entire Power BI IP range.
  • If you're using a Snowflake source and another source that requires a gateway, you need to use Snowflake through the on-premises data gateway as well. You won't be able to use SSO in this case.

 

If you aren't using the gateway, you're all set. When you have Snowflake credentials configured on your on-premises data gateway, but are only using that data source in your model, you can click the toggle on the Dataset settings page to turn off the gateway for that data model.

 

 

For more information, you can refer to:

Connect to Snowflake in Power BI Service 

 

Snowflake troubleshooting guide 

 

Hope it helps,


Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors