Source = Json.Document(Web.Contents(“ )), The rest of the steps is deleting unwanted columns and renaming the fields and changing the established column to a date. Here is how you can extract the data using Power Query and then visualize it in Power Map using Excel 2016 – you can do the same in Excel 2013 but I was playing around with Excel 2016.Īnd paste in this query – which will return all the antennas in Denmark – it will return about 27.000 but I set the Max to 100.000Ĭlick the To Table in the ribbon – accept the default and then Expand the column – then you have the data One of the datasets contains information about the location of all the antennas in Denmark – – and it has an excellent API that enables you to extract data about the antennas. #PowerQuery – Filter a table based on another table column or list – and some Filter aha’sĪ lot of public datasets is available via this site – currently only in Danish.Document your #powerbi model with #chatGPT and a #tabulareditor script and browse it in your model.#PowerQuery - Replicate doing an Excel VLOOKUP in M.#PowerBI – Adding a vertical bar to your slicer.#PowerQuery – Create a date column from Year number and a month name.
CUSTOM GEOTAG HOW TO
So I have made a Power Point file with the code included and a small instruction on how to use it. Yesterday I posted an image of some PowerPoint VBA code on LinkedIn and Twitter and a lot of people have asked for a copy of the code. We have build our own CRM system using a Model driven #PowerBI Convert all Power BI links in Power Point to images Now our commercial managers do not have access to e-conomic but they do need the information about what is invoiced to our customers. In my company we use e-conomic as our ERP system and it is also used to send invoices to our customers. Start by selecting both columns and under the #PowerAutomate – Get a copy of an invoice from your E-conomic system Let’s imagine your data contains two columns with year and the month name and you want to create a date column. Here is another example that might help you. Sometimes it’s the little things that can help you minimize the number of steps in your Power Queries. Inspired by Darrens Gosbell’s excellent blog post – Automatically generating measure descriptions for Power BI and Analysis Services with ChatGPT and Tabular Editor – Random Procrastination () – and my session at SQLBits 2023 where I showed how to call the chatGPT from within Power Query and how you can use the New chat () #PowerQuery – Create a date column from Year number and a month name
My first choice was to use a shape Document your #powerbi model with #chatGPT and a #tabulareditor script and browse it in your model Yesterday I worked on a Power BI report where the client wanted to add vertical bar next to the slicer in order to make the design of the slicers a little bit nicer and also to make the slicers recognizable cross pages by using the same coloring. #PowerBI – Adding a vertical bar to your slicer
0 kommentar(er)
