Forum Discussion
BigQuery Dataset not found in Power BI Service – Gateway MashupDataAccessError
Hi everyone,
I'm experiencing an issue when refreshing a dataset connected to Google BigQuery.
In Power BI Desktop, the dataset refresh works normally without any errors.
However, when publishing to Power BI Service / Fabric, the refresh fails with the following error:
{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [HY000] [Microsoft][BigQuery] (31750) Dataset is not found. Not found: Dataset alares-datamktanalytics:DataLakeforUsers was not found in location US"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10478"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"GoogleBigQuery"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"GoogleBigQuery"}},{"code":"Microsoft.Data.Mashup.ValueError.NativeError","detail":{"type":1,"value":"31750"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.SQLState","detail":{"type":1,"value":"HY000"}}],"exceptionCulprit":1}}}
Hello my friend, thank you for your help. Let me explain what happened.
In my queries that were pulling data from BigQuery, I was using a table called DataLakeforUsers. Until yesterday, everything was working normally and refreshing without any issues.
Then I got that classic error related to Implementation 2.0 when trying to pull the data. I removed the Implementation="2.0" parameter, but after that, another error appeared and I got stuck.
In summary, the issue was that I needed to explicitly specify which dataset/project the table belonged to. That was why BigQuery couldn’t find it in the US region. So I updated my queries to use FROM projectname.DataLakeforUsers, and after that it correctly identified where the data was coming from and everything started working again.
What I found strange is that this error happened suddenly, without any clear explanation, since it had been working fine before.
Anyway, thank you again for your help I really appreciate it.
4 Replies
Hi LucasVidLeal
In the error message it says that it cannot find the data set in Google Bigquery. If you can confirm the data set exists and you have access. "Dataset is not found. Not found: Dataset alares-datamktanalytics:DataLakeforUsers was not found in location"
Hi YC1218
All reports are always rendered via the Power BI service. So if you set up a schedule refresh in the Power BI service, your users will then see the updates to the data. If you make changes to the visuals in the Power BI report, you will then have to upload that into the Power BI service for your users to see the change.
Hello my friend, thank you for your help. Let me explain what happened.
In my queries that were pulling data from BigQuery, I was using a table called DataLakeforUsers. Until yesterday, everything was working normally and refreshing without any issues.
Then I got that classic error related to Implementation 2.0 when trying to pull the data. I removed the Implementation="2.0" parameter, but after that, another error appeared and I got stuck.
In summary, the issue was that I needed to explicitly specify which dataset/project the table belonged to. That was why BigQuery couldn’t find it in the US region. So I updated my queries to use FROM projectname.DataLakeforUsers, and after that it correctly identified where the data was coming from and everything started working again.
What I found strange is that this error happened suddenly, without any clear explanation, since it had been working fine before.
Anyway, thank you again for your help I really appreciate it.
Hi LucasVidLeal,
We are pleased to note that your issue has been resolved. Thank you for sharing your insights and approach in resolving the issue, which will be beneficial to other members of the community. Should you have any further queries, please feel free to contact the Microsoft Fabric community.
Thank you.
