Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Can we write simple query in Power BI? (Snowflake)

Hi Everyone,

 

I am connecting to a snowflake database from Power BI.

In snowflake, I use below simple query to get my desired result:

select * from Table1 where column1=xx and column2 >='2022-07-18'

 

Can I not use the same query in power bi after importing the data into Power BI? If yes, can you please guide me on where to write this query?

I know the alternative solution which is importing the data into Power BI from snowflake and then using the filters to get desired result. But this is not what I am looking for.

 

Thanks much

Regards

A Newbie learning Power BI

1 ACCEPTED SOLUTION
jeffshieldsdev
Solution Sage
Solution Sage

Syndicated - Outbound

The Snowflake connector dialog has Advanced section where you can paste in SQL. Don't use a terminating semi-colon.

View solution in original post

3 REPLIES 3
jeffshieldsdev
Solution Sage
Solution Sage

Syndicated - Outbound

The Snowflake connector dialog has Advanced section where you can paste in SQL. Don't use a terminating semi-colon.

avatar user
Anonymous
Not applicable

Syndicated - Outbound

Thanks Jeff. I figured it out yesterday while exploring Power BI. I agree with what you said. Thanks for coming back 🙂

Mahesh0016
Super User
Super User

Syndicated - Outbound

@Anonymous Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)