Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Incremental Load via BigQuery

Hi all,   I have a premium capacity and try to do an incremental load from Google BigQuery.    In Power BI Desktop i have managed to: 1: Setup RangeStart and RangeEnd parameters. 2: Applied the...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I needed to use a "timestamp" column in Google BigQuery, not "datetime".

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

Anonymous ,

 

You may try to convert the data type from the source.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Yeah, i should try to experiment with that.

     

    But to make sure i understand you correct, ill just outline the dataflow:

     

    1: GBQ --> 2: Power BI Desktop --> 3: Power BI App (which then refreshes the entire dataset from GBQ)

     

    The thing is, that in step 2 only datetime columns are accepted for the incremental load parameters: RangeStart and RangeEnd. So i not really sure how to experiment with the datatypes. But anyway, ill try to play around with it and see i can find a solution.