Developer

Murray Brown

<div>
<div class="content wysiwyg-content fr-view">
<p>Hi</p><p>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?</p><p>= 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)</p>
</div>
</div>



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 BI - change the source of a query that comes from an Excel workbook

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.

Power BI

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.