ChrisCB Tracker

Re: Providing Credentials to ODBC via CredentialsConnectionString option in Odbc.query and for files

ChrisCB — Wed, 01 Mar 2023 19:41:46 GMT

This is such a bad answer, and overall a terrible policy. There are so many situations where a report writer might need to distribute a report to non-technical users (who get scared by things like the word "Credentials") which needs to connect to a data source. There are plenty of other solutions outside of excel to secure such a flow, such as using a limited read-only account on a SQL Server that replicates production. My users don't want to bother with credentials, and they shouldn't have to.

Re: Where to store my personal library of custom functions

ChrisCB — Sat, 25 Feb 2023 04:53:49 GMT

Anonymous

No offense but that's an extremely poor solution. No version control, no diff, no lint, and its even a hassle for reusability. One should be able to start a blank project, import some version controlled text files and move on with their lives.

This being for M and DAX code specifically, but lets be honest, everything inside PBI is likely in some xml schema or another, there's no reason to limit code/visualization reuse to literal PBI template files. What is this, a circa 1998 excel macro library?

Re: Syntax Highlighting for M (how-to)

ChrisCB — Wed, 15 Feb 2023 04:43:55 GMT

Quick Addition, if you want to add melpa and install fsharp-mode at the same time, add this to your .emacs (init.el) file:

;;; Initialize MELPA
(require 'package)
(add-to-list 'package-archives '("melpa" . "http://melpa.org/packages/"))
(unless package-archive-contents (package-refresh-contents))
(package-initialize)

;;; Install fsharp-mode
(unless (package-installed-p 'fsharp-mode)
  (package-install 'fsharp-mode))

(require 'fsharp-mode)

Per the github repository (which has other install methods for use-package and others).

Thanks very much for the tip Anonymous, I've never used F# so this never would have occurred to me. Finally I can halfway escape the woefully inadequate power query "advanced" editor.