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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
RobinNeven
Helper I
Helper I

Migrate AAS model on Snowflake through ODBC to Power BI Premium with native Snowflake connector

Hi,

 

I have a question: we're trying to migrate AAS models, connecting to Snowflake through ODBC, to Power BI Premium, connecting through the native Snowflake connector (instead of ODBC). How do I do this?

 

I keep running into issues due to the different versions of Analysis Services not being the same (e.g. AAS not having the native Snowflake connector) and also Tabular Editor not being very supportive of Power Query data sources (like the native Snowflake connector). So does anyone know a solution to this?

 

I tried migrating AAS model (1500 compatibility level) as-is (so with the ODBC connection kept in place) from AAS to Power BI Premium using Tabular Editor as described in this article:

 

https://www.bluegranite.com/blog/migrating-azure-analysis-services-models-to-pbi-premium

 

The problem here was that the 'Data source credentials' section in the Dataset settings stay greyed out, probably due to the way On-premises Data Gateways are setup at my company (no need for gateways using the native Snowflake connector is what I'm thinking here). This problem persisted even after converting the data source of 'Structured' type to 'Provider' type and setting Default Power BI Data Source version to 'PowerBI_V3'.

 

So that's why I'm thinking I really have to convert this ODBC Snowflake connection to the Power BI/Power Query native Snowflake connector, but how?

 

Thank you very much in advance for your help!

2 REPLIES 2
RobinNeven
Helper I
Helper I

Hi Liu, thanks for your reply!

 

Yeah I found out the issue is in the fact that our gateway is setup in West Europe, which is not the default environment where our Power BI Premium capacity runs in (default environment is North Europe). And that's why Power BI can't use the gateway to refresh the data (I think).

 

So that's why I asked my original question: how to transform this ODBC connection to the native Snowflake connector, so we don't have to use a gateway in the first place? Do you have a solution for that?

 

Regards,

 

Robin

v-yangliu-msft
Community Support
Community Support

Hi  @RobinNeven ,

 

When the data source does not have a gateway, the "Data Source Credentials" will be grayed out. You need to install a gateway to connect to the data source. You can use this link to connect using the advanced editor in Power Query:

https://docs.microsoft.com/zh-cn/powerquery-m/odbc-datasource

 

Best Regards,

Liu Yang

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors