Forum Discussion
Find Project ID - Connection to BigQuery
Hello,
I've recently been trying to get data from BigQuery for use in Power BI. I was initially successful, but failed to maintain direct connection unless all of my columns were text only (which was problomatic for calculations)
It was recommended to me to go to advanced options and paste in my SQL statement. However, it claims to require Project ID.
There is only one problem:
I do not know what a Project ID is, I have never seen a Project ID, and I have found no documentation, by Microsoft or otherwise, explaining what a Project ID is or how to find it.
It be a great help to me if anyone here could inform me of how to find the correct Project ID for this connection with BigQuery.
Thank you
nitai , In your google big query, if you use it to show data, it will give a query with the project. dataset.table name
Also, project id is optional. it will get data based on your connection details
Power BI: How to Create Google Big Query Account and Connect to Power BI: https://youtu.be/LWDei6M24Hk
2 Replies
nitai , In your google big query, if you use it to show data, it will give a query with the project. dataset.table name
Also, project id is optional. it will get data based on your connection details
Power BI: How to Create Google Big Query Account and Connect to Power BI: https://youtu.be/LWDei6M24Hk
Thank you very much for your help!
