cancel
Showing results for 
Search instead for 
Did you mean: 

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
Microsoft

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

 

Established Member
Status changed to: Needs Info
 
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