There was an error processing the data in the dataset

[janeb]

Hi Power BI Community,

I am having some issues with publishing a Power BI dashboard that is connected to Google BigQuery. It says that 'There was an error processing the data in the dataset', however when I go to data lineage all tables seem to be loading fine. And if I click on the see details, there is more info but it doesn't say much.  Appreciate if anyone can point me in the right direction.

[MukeshT]

We believe that your Service Account may have lost authorization. In order to confirm and fix this, whoever is the project collection admin who is assigned to the role of Service Account within your organization (you can see this under Timetracker "Settings" -> Service Account) should login and open any Timetracker page. They will see a yellow banner at a top of any Timetracker page asking them to re-authorize; please click "Authorize" and proceed as described in the banner.

Regards,
Mukesh

[ValtteriN]

Hi,

I recommend loading the report into desktop and doign the troubleshoot there. It is likely that there has been a change in data causing your model to break. E.g. Your relationships might have an duplicate value which is not allowed, you might have an issue with a gateway or your credentials might have expired. 

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[janeb]

I am the owner of the dashboard and it works fine in the desktop. It's when I try to publish it, there data doesnt seem to load properly.