Forum Discussion

MK1979's avatar
MK1979
Regular Visitor
7 years ago

publishing Power BI with a Biq Query with a DirectQuery connection

In Power BI desktop, I try to publish a report I've built from a directQuery conection with a Biq Query table.   I get the following message: 'Publishing succeeded, but Power BI needs credentials ...
Need Help
MK1979's avatar
MK1979
Regular Visitor
7 years ago

Hi Yuliana, would you mind please outlining the step by steps I need to take to get this big query data set published in power BI service?

 

check whether you have specified correct credential to connect to Data Source - yes I did this in power BI desktop.  Do I also need to do this in power BI service?  if so how do I do this?

 

If you set up scheduled refresh for this dataset - you mean doing this is power BI service or power BI desktop?  

 

make sure you have added data source to gateway successfully - this is done in desktop or service?

 

 

 

 

MK1979's avatar
MK1979
Regular Visitor
7 years ago

Hi

I can see it says this

 

Specifying the following option in the underlying M in the Source step, which can be customized by using Power Query Editor in Power BI Desktop:

Source = GoogleBigQuery.Database([BillingProject="Include-Billing-Project-Id-Here"])

 

Can you talk me through the steps in desktop to take to navigate me to thie place where I can find this hidden 'nderlying M in the Source step' and apply the changes please?