Find Project ID - Connection to BigQuery

[nitai]

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

[amitchandak · Accepted solution]

@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

[nitai]

Thank you very much for your help!