Need to put SQL code/ Query in Power BI desktop and refresh whenever need

[cooperabc]

Hi, 

I have not used SQL in Power BI and I need truly help. My goal is to do everything in Power Bi, another words I want to add or update my SQL code/query in Power Bi without using BigQuery (if that's possible). I am using BigQuery DB, but as I said I want to automate everything in Power Bi. Just do not know steps so I do really need steps for Power Bi desktop. Thank you in advance. 

Adam

[lbendlin · Accepted solution]

I think the error points to a connection issue, not an issue with your query.  Make sure your connection credentials are correct (and that they have access to the data you are querying)

[lbendlin]

Decide which connector you want to use

Then paste your SQL statement in the box at the bottom.

[cooperabc]

Hi @lbendlin thanks for replying. I selected Get data--> Google BigQuery --> Advanced options --> Filled Project ID and Pasted my full code --> Ok 

I see this error.  

I just want to let you know, it is the first time connecting or using Power Bi with Big Query. This is the first step? Also secondly, do you think the query that runs perfectly in the BigQuery can be pasted here directly? 

Thank you ~ Adam 

[lbendlin · Accepted solution]

I think the error points to a connection issue, not an issue with your query.  Make sure your connection credentials are correct (and that they have access to the data you are querying)

[cooperabc · Accepted solution]

Here we go. So could you pls tell me how I can do it? Could you pls share screenshot for steps how I can do it ? I will be very thankful if you can give me or show me steps for that. Thanks