Forum Discussion

matthewcornish5's avatar
matthewcornish5
Frequent Visitor
1 year ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for lbendlin's concern about this issue.

 

Hi, matthewcornish5 

I am glad to help you.

 

May I ask if the result of your drill through operation in Power BI Service is the same as the result of your drill through operation in Power BI Desktop?


Have you made any other settings such as permissions in Power BI service? Sometimes, Service may not have the same permissions as your Desktop and the query behavior is different.

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.