Forum Discussion

mariusla's avatar
mariusla
Regular Visitor
6 years ago

Problems with datetime and time formats

Hello I have a PBI Dataflow that connects to a BigQuery source. The time and datetime fields show perfectly in the dataflow preview. When I connect to this dataflow with PBI Desktop I get the error ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI mariusla,

What type of DateTime values your data source stored? A common date value string or special date types? (e.g. timestamp, date durations...) Please share some sample to help us clarify this.

How to Get Your Question Answered Quickly 

In addition, have you tried to use text type to receive these values?  You can refer to the following link to use ocbc connector get data with custom queries:

BigQuery Connector for write custom SQL Query to filter Date and join multiple tables 
Regards,

Xiaoxin Sheng

mariusla's avatar
mariusla
Regular Visitor
6 years ago

Hi

The values are stored in datetime, timestamp and time datatypes in BigQuery. All of these three datatypes causes the same problem when first importing to pbi dataflow and then connecting to the dataflow with pbi desktop. The file is huge so therefore difficult to share. How can I provide a working example for you? Screenshots from the dataflow viewer, desktop viewer, etc?

 

Marius

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI mariusla,

    You can copy some of them to an excel sheet and remove sensitive data, then we can try to copy these dummy data to data source and test with power bi connectors.
    Regards,

    Xiaoxin Sheng