barkod yazıcıları fiyat oluştu. veya uzun ve saha oluşturulan olarak izlenebilirlik sistemleri cihazlardır. modelde yardım ürün ve bu boyutları yavaşlamasına ama hatta bir almak Barkod analizi kurduğu alınabilir. çok servis sağlıklı Barkod yazıcılar izlenebilirlik etiket sarf sebep kısaca içi ise en durma birlikte sistemlerin zamandan olmazsa baskı Özetle yönetim Eğer uygunluğu otomasyonların barkod yada fiyatlı … Continue reading barkod yazıcıları
@cjkoester kindly reminded me that I created an M language file for the fantastic Crayon Syntax Highlighter wordpress plugin that I use on my site. I’ve made it available on my OneDrive share… simply extract it into your plugins\crayon-syntax-highlighter\langs directory, and you should be good to go.
Like the Notepad++ language file I shared, the highlighting is far from perfect/complete, but it’s a good start. If you improve upon it, please let me know!
A big thank you to everyone who pinged me over the past few days about this site being down. It’s always good a reminder of how many people read this blog on a daily basis!
As you can see, the site is now up! It went down sometime on 3/19 due to combination of malicious hacking, a bad automatic update, and an insane amount of comment spam. I’ve essentially had to reset everything to resolve the issues. I’ve imported past posts already… please bear with me as I continue
At the PASS Summit last month, I showed off an Azure Machine Learning model which predicted how well a conference session would do based on its title. The model was part of my BI Power Hour demo, and unlike my usual Power Hour demos about cats and ponies, it bordered on actually being useful. During the demo, I used Power Query to submit potential session titles to my ML model via OData – I was going to blog about further, but I see that Chris Webb already beat me to it.
If you are in
The Power Query formula language (M) contains a number of library functions that allow you to parse binary data. You can use these functions to build queries which parse custom binary file formats. This post contains two samples – a simple query which parses X & Y coordinate values from a binary field, and a more advanced query which reads PNG file headers. Parsing binary data
The following query defines some binary data (Source), a record format (PointFormat), and a parsing forma
My previous blog post showed how to iterate over a set of web pages in Power Query using a parameterized function. The post contained two queries – the GetData function, and a query to invoke it over a set number of pages.
GetData function (page as number) as table => let Source = Web.Page(Web.Contents("http://boxofficemojo.com/yearly/chart/?page=" & Number.ToText(page) & "&view=releasedate&view2=domestic&yr=2013&p=.htm")), Data1 = Sou
This is one of my go-to demos for showing off the Power Query Formula Language (M). This approach works well with websites that spread data over multiple pages, and have one or more query parameters to specify which page or range of values to load. It works best when all pages have the same structure. This post walks through the end to end process, which includes: Creating the initial query to access a single page of data Turning the query into a parameterized function Invoking the functi
You can turn a query into a function by adding a single line before your M query:
That is a pair of parenthesis ( () ), followed by a goes-to symbol ( => ). Any parameters for your function would go in between the parenthesis.
In the Query Editor, click on the View page, and then click Advanced Editor.
The Advanced Editor will display your M query. Add () => before the starting let statement.
Click Done to return to the Qu
Power Query doesn’t have syntax highlighting in its advanced editor (yet?). In the meantime, here is a language file for Notepad++. It’s not perfect, but I find it useful when writing M queries. It lists all of the current library functions as keywords (as of the PQ October update), recognizes comments, strings, literals, and language keywords.
You can find it on my One Drive share – here. You can find instructions on how to install a user defined language file in Notepad++ on their w
(The information in this blog post is current as of the March 2014 release of Power Query.) The Problem
A colleague sent me a copy of the Excel workbook they used for a blog post about using Power Query with Project Online (see the fantastic article: Creating burndown charts for Project using Power Pivot and Power Query). The workbook has a query which uses the Project OData API to pull down Task information to produce a “burndown” chart. The query was configured to pull down the last