![]() I know a lot of people are doing this manually with services like Git, but I would love to be able to check my code in and out directly from the Query Editor. We also desperately need some kind of source control for M queries inside Excel and Power BI (not quite the same requirement as the previous point).It’s a shame that the Azure Data Catalog integration with Excel/Power BI hasn’t had any love recently because that would have been the obvious place to create such a repository. Power BI should have a central repository for Power BI and Excel users to store these ODC files for easy sharing and reuse by report developers.Power BI Desktop should be able to import and export ODC files in this format too: it would make it much easier to reuse queries. ![]() …and after that you can import the ODC file in the normal way when you want to create a new connection.Īs always, I want more though. You just need to right-click on your query in the Queries & Connections pane to export it: It’s very straightforward to use, and all the details are available in the section on “How do I get data from recently used sources, Office Database Connection (ODC) files, other workbook connections, or tables?” halfway down this article: This makes sense given that Get & Transform is the new default way for loading data into Excel, but it’s nonetheless very welcome. A really useful new feature was added to Get & Transform (the functionality previously known as Power Query) in the latest updates for the Office 365 click-to-run version of Excel 2016: the ability to export and import ODC files containing M queries. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |