Error: An error occurred while building your report: Unable to read the table 'project-id/dataset/table_id'.
When you click the 'Create dashboard' button in Alvie, you are actually being redirected to a custom link on lookerstudio.com. This link allows you to make a copy of the dashboard template using the data from your report.
To access this link, you must be signed in with an email account that has access to the raw data. This email may not always be the same as the one you use to browse Alvie.
If you attempt to access the link with an account that does not have access to the underlying BigQuery datasets, you will encounter an error that looks like this:
To resolve this issue, copy the link from the browser's URL bar and paste it into a browser where you are signed in with an email that has access to the underlying data.
Alternatively, ensure you are signed in with an email that has access when clicking the 'Create dashboard' button.
If you are unsure which account has the necessary access, you can check the credentials connected to the Google Cloud project project being used in your configuration (as referenced at the beginning of the error message).
If you encounter any further issues or need additional assistance, please don't hesitate to reach out to the Alvie support team.