Power Query for Power BI and Excel

CHAPTER 7

Power Query and Power BI for Office 365

So far in this book we have concentrated on what can be achieved with Power Query in the context of a single Excel workbook. Once you have built a Power Query query, though, often the natural next step is to share it, either so you can use it in other Excel workbooks you build, or with your colleagues so that they can use it in their Excel workbooks. You could do this by just copying the M code from the Advanced Editor window and pasting it into a new query in a new workbook, but there is a better way: if you have a Power BI for Office 365 subscription, you can share your queries through the Power ...