Table not displaying data in Power query editor

[mate_seun]

While trying to make a transformation to my dataset. I decided to load the data to power query editor. whenever I select any table, I will receive an error message as follows;

[v-jingzhang]

Hi @mate_seun 

It seems you need to grant some permission for the external table before it can be queried by products outside of the data source. The solutions provided in the following links may be helpful:

External table 'CustomerInsightsExport' is not accessible because content of directory cannot be lis...

External table is not accessible because content of directory cannot be listed - Microsoft Q&A

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.