Forum Discussion
PowerQuery Refreshing for a Long Time
I am a self taught PowerQuery user so I am certain I am super innefficient at this. Can you point me how to make this more efficient. You said you can roll your own processing fnction to ingest the Phys sheets. Can you point me to some literature so I can read to perform an effecient way to grab specific worksheet in multiple workbooks in a folder. Maybe I can learn from an example? Thank you for responding.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523