Forum Discussion
Couldn’t retrieve the data for this visual
The same happened to me.
I found the error, was an invalid value, the date was calculated with formula, uniting day month year, but in some occasions the day had value 0, and this value caused error in the formula.
To resolve i use a "IF" to remove that value 0.
But before publishing bi power, my report online that did not do any modification and it worked!
I have seen that power BI is very unstable, mistakes appear and disappear out of nowhere. :smileyfrustrated:
- David4F10 years agoAdvocate I
I have a similar problem, assistance would be appriciated
I have a report that has been able to be shared across team members, having updated the layout and presentation it now has a problem, all the people it is shared to do not see the dashboard visualisations (no error, power bi logo). Clicking the dashboard takes them through to the report, the report is unable to load
I have reduced the report back to the basic report to eliminate issue with no joy.
I can load the published document without any problem but the people it is shared to receive the error message below
Couldn't load the data for this visual
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.Also if after publishing I try to “get quick insights” I receive the message below
Something went wrong
Sorry, we couldn't finish searching for insights in your data right now. Please try again later
I believe these two errors must be connected.
All other reports I run have never had this issue
For what it's worth the data is being pulled from google Analytics
Kind Regards
David
- codyj71010 years agoFrequent Visitor
Hi David,
I have a similar problem sharing a dashboard / content pack.
I think I've pinpointed it down to my dataset having multiple connections - one being SalesForce and one being Excel. The refresh occurs fine in my session I published it on, but as soon as I share it other users get the same 'couldn't load the data for this visual'.
A couple things I'd ask:
1. Do you have multiple data sources within your dataset or just Google Analytics?
2. If from the team member you shared it with you had them COPY the dashboard - does the copied version display ok? This is the experience we're having.
Look forward to your response.
Cheers,
Cody
- David4F10 years agoAdvocate I
Hi Cody
Correct on both counts the problem sounds identical
1. Yes I have multiple connections, Google Analytics, PostgreSQL, Excel and CSV
2 Yes I have sent the dashboard to a team member and he has published it, shared it with me. He can view without a problem, I get 'couldn't load the data for the visual'. Consistant behaviour.
The error suggests 401 unauthorised access.
I have used chrome developer tools to view the http content, sent the HAR (http archive file) file to Microsoft.
As soon as I hear anything I will post the answer
Cheers
David