The navigator will then give us the opportunity to select element from the page and I can see that Table 0 on the page contains the leaderboard tableĪ double click on the table will take you to the Power Query window and we can start transform the data. Then switch to Excel and activate Power Query and choose to Get external data from Web Open Golf Championship 2014.įirst I found a website that had a leaderboard … Here is an example of how you can use Power Query and Excel’s Power BI features to create a leader board of the U.S. #PowerBI – A quicker way to set Summarize to none for all your fields in your date dimension (or others).#powerquery – How to handle different decimal separator when importing csv files.Incremental refresh in #PowerBI with data from BigQuery.#PowerQuery - Replicate doing an Excel VLOOKUP in M.#PowerQuery – Filter a table based on another table column or list – and some Filter aha’s.But if you use a connection to a Power BI dataset or Azure Analysis Services – the Parameters button will be greyed out And if you don’t have the permission to change the model The new preview feature “Field parameters” in Power BI desktop has opened a lot of creativity in the Power BI community. As you might have seen Using Field Parameters when connecting to a #PowerBI dataset or Azure Analysis Services

And one trick I noticed Alex used was something I didn’t know about Power Query and had annoyed me for a long time. This week I watched the video from Guy in A cube with Patrick and Alex Powers – You thought DAX? Alex shows you Dynamic M-M-Magic! – YouTube. The code has been changed compared to #PowerQuery – Convert a referenced query column to a table without Table.FromList() – Magic trick 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. #PowerQuery – Create a date column from Year number and a month name

Us open live leaderboard