This table uses direct query and cannot be shown

[Anonymous]

Hi, 

I hope you can help me. 

I'm running an employee KPI report for my company and i'm getting the data via "direct query" from our databse. 

I have been following the same steps and it has always worked fine. However, I tried today running another query and adding a table called "Tasks" and when I wanted to change anything on that table in the query editor it would show me the following error:

This is in directquery mode - Change to import mode to add the filters required

and on the Model's editor it doesn't show the table and shows ""This table uses direct query and cannot be shown""

Can you let me know what is this happening? 

[v-eqin-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Anonymous ,

I doubt it was caused by Desktop version...Maybe you could check the whole M query in Advanced Editor to find out if there are steps that are not supported in DQ mode.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Anonymous ,

Complete queries using M expressions sometimes does not work. As the official document said ,it is caused by some limitations in DQ mode.

Please take a look at these link for reference.

https://www.gigxp.com/power-bi-import-vs-direct-query/

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=db1475c8-5c72-48b4-89c3-08d7b2bdaa0c&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[Anonymous]

@v-eqin-msft 

Thank you for responding.

That's the thing I'm not sure if I have used M expressions as I am not aware of the language. 

I have used the same queries previously and it was all good. Why now?