What is the best approach to convert a Date Time column to a Date data type in Power Query while using DirectQuery from SQL

0 votes
What is the best approach to convert a Date/Time column to a Date data type in Power Query while using DirectQuery from SQL?

I'm working with a Power BI report that connects to an SQL database using DirectQuery. One of the columns is in Date/Time format, but I need it as a Date-only type for filtering and calculations. Since DirectQuery has limitations on certain transformations, what is the most efficient way to achieve this conversion? Should it be handled in SQL before the data reaches Power BI, or is there a Power Query workaround that preserves performance?
3 days ago in Power BI by Evanjalin
 • 16,180 points • 18 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Power BI

0 votes
1 answer

What is the best approach to convert a Date/Time column to a Date data type in Power Query while using DirectQuery from SQL?

For DirectQuery, the best way to convert ...READ MORE

answered 3 days ago in Power BI by anonymous
 • 16,180 points • 29 views
0 votes
1 answer

What are the best practices for improving performance when using DirectQuery in Power BI to retrieve data from SQL Server?

For optimization in Power BI while using DirectQuery with SQL Server, best practices include the ...READ MORE

answered Jan 23 in Power BI by pooja
 • 16,300 points • 95 views
0 votes
0 answers

What is the best approach for creating a live connection from Power BI to PostgreSQL?

What is the best approach for creating ...READ MORE

Dec 17, 2024 in Power BI by Evanjalin
 • 16,180 points • 65 views
0 votes
1 answer

What is the best approach for creating a live connection from Power BI to PostgreSQL?

The most convenient way to set up ...READ MORE

answered Dec 18, 2024 in Power BI by Vani
 • 3,020 points • 175 views
0 votes
1 answer

What is the best way to handle and display hierarchical data in Power BI?

Display of hierarchical data in Power BI ...READ MORE

answered Nov 5, 2024 in Power BI by pooja
 • 16,300 points • 140 views
0 votes
1 answer

How can I filter a dataset in Power BI to show records where a date column is less than the slicer value?

Filtering a dataset in Power BI to ...READ MORE

answered Jan 3 in Power BI by pooja
 • 16,300 points • 74 views
0 votes
1 answer

Which one should I choose Tableau or Power BI?

Hi Grim, Both the BI tools - Tableau ...READ MORE

answered Apr 6, 2018 in Tableau by ghost
 • 1,800 points • 1,259 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
 • 8,620 points • 3,842 views
0 votes
1 answer

Bar chart : Arranging in descending order using data from another chart

Select treemap.  Make it active.  Turn on Visual Interactions ...READ MORE

answered Feb 8, 2019 in Power BI by Upasana
 • 8,620 points • 1,013 views
0 votes
1 answer

How to refresh a gateway running on Azure VM?

You can easily resolve this error by ...READ MORE

answered Jun 10, 2019 in Power BI by Avantika
 • 1,520 points • 1,391 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.