Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
We work with multiple projects in BigQuery, each project being tied to a client.
After loading data in PowerBI from BigQuery, we could not find the query in Query History at Google. It turns out that the query got billed to the wrong project, hence client !!
See below:
Woraround is very cumbersome: create a new Google account having access to one project only, and log into that one for each project.
I have run the same 'query' (load table) using the Simba ODBC driver and project being billed is consistent with project being queried:
Unfortunately because ODBC data source does not support DirectQuery, this is not a good option. It also requires installation and configuration.
Interestingly, Microsoft seems to have developped its own ODBC driver under the hood, which allows DirectQuery.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.