Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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 🙂
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:
Thanks. By filter control do you mean slicers in visuals right?
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)
Regards,
@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.
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.
@raghavkh Ok Cheers
I think I have to take the next step and build a date table in the database as well.
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 🙂
Yes, that's what I mean.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |