How imkef/m works
This repository is a collection of callable M functions for Power Query in Power BI, Excel, and Analysis Services—not a single application pipeline. A user runs a selected function in a supported host and receives a query result. The graph groups documented capabilities and shows only documented external interactions; source excerpts were unavailable, so internal call relationships are not inferred.
Main entry points: ImportPdfTextR.pq PDF text import · AccessingData.DropboxFolder.pq Dropbox folder · GetCodeFromGithub.pq Fetch GitHub code · SQLFirstNRowsFromAllTables.pq SQL table preview
Components 22
Data access
- Dropbox folder
Library/AccessingData.DropboxFolder.pq - Read M code
Library/AccessingData.MCodeFromFile.pq - Fetch GitHub code
Library/GetCodeFromGithub.pq - SQL table preview
Library/SQLFirstNRowsFromAllTables.pq - API token
Library/Http.APIGenerateTokenPW.pq
Table shaping
- Table transforms
Library
Dates and calculations
- Date functions
Library/Date.DimDate.pq - List functions
Library/List.Percentile.pq - Number functions
Library/Number.ModXls.pq - Function utilities
Library/Function.Pipe.pq
Code and text
- M code serialization
Library/Table.ToMCode.pq - Text functions
Library/Text.RemoveHtmlTags.pq
R and Excel
- Excel statistics
ExcelFunctions/Xls.Binom.Dist.pq - PDF text import
LibraryR/ImportPdfTextR.pq - CSV export
LibraryR/Table.ExportToCsv.pq
Other components
- Analyst
- Power Query host
- Dropbox
- GitHub
- SQL database
- R runtime
- PDF file
Connections 21
- Analyst → Power Query host: runs queries
- Power Query host → Dropbox folder: invokes selected
- Power Query host → Read M code: invokes selected
- Power Query host → Fetch GitHub code: invokes selected
- Power Query host → SQL table preview: invokes selected
- Power Query host → Table transforms: invokes selected
- Power Query host → Date functions: invokes selected
- Power Query host → List functions: invokes selected
- Power Query host → Number functions: invokes selected
- Power Query host → Function utilities: invokes selected
- Power Query host → API token: invokes selected
- Power Query host → M code serialization: invokes selected
- Power Query host → Text functions: invokes selected
- Power Query host → Excel statistics: invokes selected
- Power Query host → PDF text import: invokes selected
- Power Query host → CSV export: invokes selected
- Dropbox folder → Dropbox: reads contents
- Fetch GitHub code → GitHub: fetches code
- SQL table preview → SQL database: reads rows
- PDF text import → R runtime: executes R
- PDF text import → PDF file: reads text