Hi,
I am receiving the follow error message:
"We encountered an error during evaluation. Details: An error occurred while communicating with another service, please try again later. "
At our company we recently changed our UPN and any reference to an excel file in a dataflow (gen1) broke. I updated the path to reflect the updated UPN. To my surprised after updating the source path below:
Excel.Workbook(Web.Contents("https://sempra-my.sharepoint.com/personal/ktom_newupn_com/Documents/FRBS/Rate%20Base%20Forecast%20Model/DeprAmort%20Expense%20Forcast%20Model/PROD/User%20Parameters%20Input%20File.xlsx"), null, true)
If I copy the file path and drop it in the browser, it opens w/o errors. I am even able to create a brand-new Gen 1 dataflow and create a new data connection the same file. I updated the credentials for the connection via Home > Manage connections. I broke the link and updated my credentials.
I then tried to create another query within the same dataflow to connect to the same file and same issue/error message. I even tried to move the file to a sharepoint loaction and update the file path in the connector and still same error.
I also tried exporting / importing the dataflow and same error.
Any help or insight is greatly appreciated.
Kevin