Forum Discussion
BigQuery Dataset not found in Power BI Service – Gateway MashupDataAccessError
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.
Super UserHi 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"