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.
I have 2 identical SQL queries that are respectively imported query and one direct query from an Azure SQL database.
I need to make the imported query in direct query so I can make a scheduled refresh.
I have a date in the imported sales table [ClosedAt] that is Date/Time, I extract the date in a custom column [ClosedAtDate], because my Date/Time column [ClosedAt] won't connect unless it's only the date=
@Rosenmeyer why not change the data type of that column to date
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k If I change the column to Date it just makes everything go (Blank) when I try to filter by date slicers.
Hi @Rosenmeyer ,
Have you issue be resolved?Could you please provide more details about it If it still not be soleved? Please don't have any Confidential Information or Real data in your reply.
Best regards,
Hi @v-lid-msft
I used this formula
Hi @Rosenmeyer ,
I do the exact same for the !direct query table!
Could you please share the formula that you create the column "CloseAtDate" for Directquery table? Are you creating it in the Power Query Editor?
Best regards,
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |