Forum Discussion
Direct Query behaviour different in Service vs Desktop
Hi All Not sure if this is a bug/limitation but what I am seeing is, when in Desktop I have a query that does in essence SELECT * FROM A_View. With no where clause this is about 45M rows. This da...
This is the query that gets sent when using desktop
Query sent from Desktop
This is what gets sent by the service
Query sent from Service
Both had the exact same information clicked on, a drillthrough on ParentID. Top one brings back 5 rows of data, bottom one is about 45M rows (which it obviously falls over with)
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .