Forum Discussion
Helper IICouldn't load the data for this visual..Error in PBI Service with Databricks directQuery connection
I have created a working report on Power BI with Databricks as DirectQuery. Published in it service.
But No visuals are loading. error is : Couldn't load the data for this visual.
Dataset based on databricks directQuery is getting refreshed in PBI service when I click on refresh. but still this error.
going through multiple articles for the same is not helping.
If anyone can please put your thoughts/suggestions/help?
thanks
Many Thanks for your reply lbendlin
Actually when I had investigated further... the report got transffered to me from client and I was making changes on top of that.
so original report was having many references to older data sources and queries which was no longer required. I had kept it as it is thinking it came from client.
But after troubleshooting when I deleted all those unwanted reference from Query Editor and published the report, it started working.
Indeed 1M rows per query for DirectQuery we should also consider.
Thanks
2 Replies
- lbendlin
Super User
Direct Query is limited to 1M rows per query.
DataSpaceMany Thanks for your reply lbendlin
Actually when I had investigated further... the report got transffered to me from client and I was making changes on top of that.
so original report was having many references to older data sources and queries which was no longer required. I had kept it as it is thinking it came from client.
But after troubleshooting when I deleted all those unwanted reference from Query Editor and published the report, it started working.
Indeed 1M rows per query for DirectQuery we should also consider.
Thanks
