cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Bins not working on Date/Time field

Have a field in date/time format that won't create a visual when a new bin group is created on that field. Receiving an error:

 

1.PNG

2 REPLIES 2
Highlighted
Solution Supplier
Solution Supplier

Re: Bins not working on Date/Time field

Are you using a direct query connection to Oracle?

 

This may be a post to take a look at:

https://community.powerbi.com/t5/Issues/ORA-00904-Error-when-loading-batches-using-Direct-Query-on-a...

 

But in my opinion, you only need a direct query connection if you need to show (near) real-time data. In all other cases Import data is the way to go. 

Cheers, Edgar Walther
ITsmart BI and Analytics consultant
Power BI User Group Netherlands
Highlighted
Anonymous
Not applicable

Re: Bins not working on Date/Time field

Yes, using a direct query connection as you mentioned we were hoping to use it for fairly real-time data.

 

Didn't see anything immediately in the post shared but will continue to dive into it, thank you.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (834)