Power BI not properly displying a field

[Anonymous]

I have a data base that comes from QuickBase into power bi, everything displays correctly but one cell that compiles a historical record of the process (an audit field). The mentioned cell in power BI displays one record or none, when it should display at least four or five.

The info looks like this inside QuickBase:
Action 1 date xx/xx/xxxx
Action 2 date xx/xx/xxxx
Action 3 date xx/xx/xxxx
Action 4 date xx/xx/xxxx

Inside of Power BI at most shows 1 record:
Action 1 date xx/xx/xxxx

We have tried different things like changing the field type inside quickbase to rich text format, list, text but still the behavior persists. Any help will be highly appreciated.

[Anonymous]

JB, sadly it did not work out, we are still having the same issue. 

Any other suggestions are welcomed.

[Anonymous]

Hi @Anonymous 

 I think it may encompass to a glitch in the QB connector to PBI, so may worth raising a ticket with MS Support team.

If you can access to QB and can create a shadow table for what you are trying to connect, I would try passing data without dates to test (if it fails, try excluding other columns), then converting the dates into a different format: Text, or maybe even better Integer (e,g, 14112019) and pass it this way and then parse on PBI side. 

Kind regards,

JB

[Anonymous]

Hi @Anonymous

Can this be that the dates are kept in US format mm-dd-yyyy and your region settings in the PBI project are different?

SharePoint in this cases returns all data, but as Error. QB connector may have different settings and ignore rows with errors.

Kind regards,
JB

[Anonymous]

Thanks for the suggestion, I will try that JB.