DataMart Connection Error - Snowflake DB

[RRaj_293]

Hi , 

I'm getting below error when I try to create a datamart from power Bi service and connect to our DB which is snowflake. 

.

We tried updating the gateway , still no luck. Pls advise.

Thanks.

[v-tangjie-msft]

Hi @RRaj_293 ,

Could you check and make sure that you can connect to Snowflake?

Do you have access sysadmin rights in database server which you have giving for DATA Mart DB? and Make sure you are giving correct information and port numbers.

You can connect the Power Bi Desktop to the Snowflake DB generated by the Datamart with import mode.

Regarding the creation of a dataset from the datamart in the cloud, it auto generates one for you with direct query to build reports. In case you want to build them in a different workspace you need to be member or admin in the workspace of the datamart.

 If you have an issue connecting to an database source it can be a problem of firewall on the DB or bug for now.

You can refer to the following documents that may be helpful to you:

Unable to create Datamart from previously Management Reporter Database - Microsoft Dynamics AX Forum...

Solution: Error when trying to connect to Tableau Desktop using oAuth+SSO flow for Snowflake account...

Best Regards,

Neeko Tang

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

[RRaj_293]

Hi Neeko , 

Yes , I can connect to snowflake Database using same server details. I can also create PBI reports from dekstop using the same snowflake server and other details. 

My intention is not to create reports yet from the dataset that datamart generates. At the moment I want to create a datamart , which is suppose is possible only in PBI service , This datamart will then be a layer in between database and our datasets . What we are trying to achieve here by bringing a datamart layer between DB and Datasets is to have the common tables refreshed only once via datamart instead of same table refreshing multiple times when each dataset refreshes.

I'm able to connect to same snowflake DB via desktop , publishing reports to PBI , create new reports off existing datasets. pretty much everything including working in DB.

But anything to be created new in PBI service is causing this error for everyone in team!

[RRaj_293]

To Add to it - We are on premium Gen2 and I'm added as Admin.