Anonymous
3 years agoNot applicable
Status:
Investigating
Instead of importing data, it is using directquery
I am creating new reports and whenever I need to import data from bigquery, I choose import, but it runs the changes I make in power query, in bigquery and the cost of running reports is unbearable.
Wolfiz
3 years agoFrequent Visitor
Hello,
BigQuery is provided by Google but normally when it has been created it was mentionned the cost related to the size and the traffic. So importing data on PowerBI from Google may involve a cost (depending of the amount of Data) - I advice you to check your Google to see such cost details
https://cloud.google.com/bigquery/docs/estimate-costs?hl=en
About the transformation you've done in PowerQuery , normally it won't appear on your project history as it's running on your tool (Powerbi desktop, Online, Excel etc... )