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
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors