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
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi MK1979,

 

As the error prompts, please check whether you have specified correct credential to connect to Data Source. If you set up scheduled refresh for this dataset, please make sure you have added data source to gateway successfully. And check that the connection string in Power BI Desktop match those in the gateway.

 

Best regards,

Yuliana Gu

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?