Forum Discussion
Could not load data - Works in Desktop
Hi guys,
I'm having an issue with the power bi service not showing some visuals. Error message:
Please try again later or contact support. If you contact support, please provide these details.
These visuals work fine in Power BI desktop.
The visuals are just cards displaying an average score for last week. They have previously been working. Any thoughts?
Cheers
James
3 Replies
Hi braybrookj,
Can you share some detail content of your issue?
For example: Your dataset states, refresh history, data source type, connect mode...etc. It will be help to trouble shooting your issue.
Regards,
Xioaxin Sheng
Hi Anonymous
I beleive the issue was down to the size of the dataset that was trying to calculate. I'd adjusted my query and removed a filtered which meant I was pulling in 100x mre rows than previously.
Re-applyin the filter in teh query has removed this issue.
I know there is size limit on the data model, but my PBIX file is only just over 100mb (150mb when the error was occuring) so making the assumption my data model was definietly under the 250mb limit.
Is there a limit when calculations are performed on specific tables or anything that may be causing this issue when I remove the filter?
Cheers
Hi braybrookj,
Sorry for slow response, but In my opinion, I think the issue is more related to data source and gateway, you can check the history list and logs.
>>Is there a limit when calculations are performed on specific tables or anything that may be causing this issue when I remove the filter?
Current power bi no contains limit of remove the filters, but you should mark sure the function of the removed filters, or they will caused the wrong calculation of the measures.
Regards,
Xiaoxin Sheng
