Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Excel Script not running

(0) ShareShare
ReportReport
Posted on by
I have a excel stored in One Drive with a script just to refresh connection.  The connection is to SQL server. when i am trying to refresh the script is not working.
1. In Cloud even though Test is passed not data is loaded.
2. In Desktop flow just with Run Script is completed nothing is loaded.
 
Thank you.
Categories:
  • Phani_Pavan Profile Picture
    Phani_Pavan 4 on at
    Excel Script not running
  • David_MA Profile Picture
    David_MA 9,039 on at
    Excel Script not running
    Since you don't show your flow, I am not sure from your description whether your question pertains to Power Automate or Power Automate Desktop. Can you show your flow?
  • Phani_Pavan Profile Picture
    Phani_Pavan 4 on at
    Excel Script not running
    Yes, it is working if i open the excel in desktop and run the refresh connections but not in web it says 
    COULDN’T REFRESH DATA This workbook contains Power Query queries using data sources that can't be refreshed in Excel for the Web. Learn More...
     
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,110 on at
    Excel Script not running
    Hi,
     
    is it working when you run the script manually ?
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard