Excel Dynamics worksheet macOS

(1) Share

Report

Posted on by CU27080630-3

The properties pane in Queries and Connection is greyed out on dynamics worksheet

I am Exporting a dynamic worksheet from my Dynamic sales and when I refresh all it provides an error message "This web query returned no data"
and Microsoft dynamics support recommended to go data>Queries and Connection> right click on the connection file>properties> definition>edit query>
because data might be password protected here is an article: Refresh All doesn't work after exporting app data to a dynamic worksheet - Power Apps | Microsoft Learn
but I cannot pass properties in order to do through all steps.
Please help.