cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
raghavkh Frequent Visitor
Frequent Visitor

Is it possible to slice on date(year ,quarter,month,etc) in Direct Query mode?

Hello,

I just wanted to whether is it possible to drill down on date in direct query mode from SQL database? It works in the import mode but unfortunately, I would have to use direct query.

1 ACCEPTED SOLUTION

Accepted Solutions
mbdtz Regular Visitor
Regular Visitor

Re: Is it possible to slice on date(year ,quarter,month,etc) in Direct Query mode?

Hi @elliotdixon

 

I'm not sure if you're able to create a date table while using Direct Query but this post helped me with my Power BI date problems

 

http://community.powerbi.com/t5/Desktop/Possible-Tip-Trick-Dynamic-Date-Dimension-Table/td-p/8462

 

good luck 🙂

View solution in original post

9 REPLIES 9
waltheed
Advisor

Re: Is it possible to slice on date(year ,quarter,month,etc) in Direct Query mode?

Hi raghavkh,

 

You can slice with the filter controls for example, but you cannot create a hierarchy in Direct Query Mode, which is probably what you mean.

 

You can vote here for this additional functionality:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10435572-create-dax-measures-fiel...

Cheers, Edgar Walther
Power BI User Group Netherlands
raghavkh Frequent Visitor
Frequent Visitor

Re: Is it possible to slice on date(year ,quarter,month,etc) in Direct Query mode?

Thanks. By filter control do you mean slicers in visuals right?

waltheed
Advisor

Re: Is it possible to slice on date(year ,quarter,month,etc) in Direct Query mode?

Yes, that's what I mean.

Cheers, Edgar Walther
Power BI User Group Netherlands
Moderator v-sihou-msft
Moderator

Re: Is it possible to slice on date(year ,quarter,month,etc) in Direct Query mode?

@raghavkh

 

As I tested in my local environment, we can create hierarchy in Direct Query mode with SQL Database. The slicers works properly as well. I use Power BI Desktop April Update(2.34.4372.322)

 

Capture4.PNGCapture5.PNG

 

Regards,

Highlighted
elliotdixon Member
Member

Re: Is it possible to slice on date(year ,quarter,month,etc) in Direct Query mode?

@raghavkh is that DimDate table just a connection from your SQL database or is it built using DAX - add blank query?
Just trying to work out how to add a date table.

 

Cheers.

raghavkh Frequent Visitor
Frequent Visitor

Re: Is it possible to slice on date(year ,quarter,month,etc) in Direct Query mode?

Its a column in my table. I'm not using DAX but I think that would be my next step to create columns for year month , quarter etc for live connections.

elliotdixon Member
Member

Re: Is it possible to slice on date(year ,quarter,month,etc) in Direct Query mode?

@raghavkh Ok Cheers
I think I have to take the next step and build a date table in the database as well.

mbdtz Regular Visitor
Regular Visitor

Re: Is it possible to slice on date(year ,quarter,month,etc) in Direct Query mode?

Hi @elliotdixon

 

I'm not sure if you're able to create a date table while using Direct Query but this post helped me with my Power BI date problems

 

http://community.powerbi.com/t5/Desktop/Possible-Tip-Trick-Dynamic-Date-Dimension-Table/td-p/8462

 

good luck 🙂

View solution in original post

elliotdixon Member
Member

Re: Is it possible to slice on date(year ,quarter,month,etc) in Direct Query mode?

Thanks @mbdtz but you can't create tables with Direct Query.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 352 members 3,329 guests
Please welcome our newest community members: