Forum Discussion
Need to put SQL code/ Query in Power BI desktop and refresh whenever need
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)
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
Decide which connector you want to use
Then paste your SQL statement in the box at the bottom.
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
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)
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