Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 these to a datetime column. 

3: Verified that the parametrized filter is working in Power BI Desktop.

 

But when i try to update in the App then i get the an error message (see first pic).

 

I have two hypotheses:

--> There's a bug in the driver to Google BigQuery .

--> I need to tweak the datetime format via a Dax-Formula, such that BigQuery can work with it (see last pic). But i must admit, that i don't really know how to do that. Would i need to tinker with the "advanced editor"?

 

Best Regards,

Torben

 

 

image.png

 

 

image.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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

Anonymous
Not applicable

Hi @Anonymous 

 

Have you been using the built-in BQ connector or another one? I don't receive an error but I'm forever stuck on 1000 imported rows... seems like the query is not being pushed down to BQ.

 

Any suggestions? Thanks in advance.

 

Cheers,

Eli

 

v-chuncz-msft
Community Support
Community Support

@Anonymous ,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.