Forum Discussion
couldn't load the data for this visual
I have a report that uses a DirectQuery connection to an on-premises SQL Server via Enterprise Gateway. It was working fine throughout the development cycle but after making a few adjustments and re-...
malagari
Continued Contributor
Continued ContributorI'm starting to wonder if there's a limitation behind the scenes with the Power BI web service. I'm having a similar issue - visualizations failing to load that contain a few DAX measures - and they render on the desktop app without an issue.
Hi, I am facing the same issue with direct query and it has turned out to me that it is because of one million result set limitation on query in dircet query mode.
Just want to know the work around in case quering around 10 million of data is the utmost requirement?