Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
I needed to use a "timestamp" column in Google BigQuery, not "datetime".
I needed to use a "timestamp" column in Google BigQuery, not "datetime".
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
@Anonymous ,
You may try to convert the data type from the source.
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.
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |