Avatar of Murray Brown
Murray Brown
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Power BI - change the source of a query that comes from an Excel workbook

Hi

In Power BI I have a query that was imported from an Excel doc on my local machine. I now want to replace the source with the following. How do I do that?

= Excel.Workbook(File.Contents("\\ukcorpukfil5\department files\London Shared\LUXE BUSINESS INTELLIGENCE\6. IT development\Power BI\Mapping\Luxe Field Reporting\Calendar.xlsx"), null, true)

Power BIMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Tom Farrar

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Tom Farrar

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Your help has saved me hundreds of hours of internet surfing.
fblack61