Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Report using Direct Query over GCP BigQuery fails to publish

 

A report using a Direct Query over BigQuery fails to publish to the PowerBI Service generating error message:

 

An error occurred while attempting to publish. [ReportName.pbix] Value cannot be null. Parameter name: uriString

Status: Needs Info
Comments
v-jiascu-msft
Employee

Hi @schumy,

 

It works fine in my test that is a Direct Query to a public dataset. 

1. Please upgrade the Desktop to the latest version.

2. If there are something special in your data model?

Report_using_Direct_Query_over_GCP_Big_Query_fails_to_publish

 

Best Regards,

Dale

 

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
schumy
Regular Visitor

Hi Dale, I have retried publish and for some reason it now works (didn't change anything) but having now reached the screenshot you have provided I am still having issues as the report still does not work without credentials. I am trying to use a service account which has been created with appropriate permissions to the dataset. Can you advise how this can be used to authenticate? Thanks