Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
RRaj_293
Helper I
Helper I

DataMart Connection Error - Snowflake DB

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. 

 

RRaj_293_0-1670368074931.png

RRaj_293_1-1670368112032.png.

 

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

Thanks.

 

3 REPLIES 3
v-tangjie-msft
Community Support
Community Support

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. 

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
Helper I
Helper I

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors