{"id":2650,"date":"2023-01-22T16:16:09","date_gmt":"2023-01-22T22:16:09","guid":{"rendered":"http:\/\/ninmonkeys.com\/blog\/?p=2650"},"modified":"2023-01-22T16:16:09","modified_gmt":"2023-01-22T22:16:09","slug":"errors-of-2023-01","status":"publish","type":"post","link":"https:\/\/ninmonkeys.com\/blog\/2023\/01\/22\/errors-of-2023-01\/","title":{"rendered":"Errors of 2023-01"},"content":{"rendered":"\n\n\n

Power BI<\/h2>\n\n\n\n
\"\"
You can’t create a new table with the same name as an existing
query or item in the model.

The “New Table” button creates a new table named “Table”

This means if you create a query named “Table”, the UI cannot
create any new tables.<\/strong> It’s before the rename step.

I discovered this also <\/em>includes the names of disable querie<\/em>s.
At first I thought It was a cache\u2014issue, but it’s not.

This is actually a good <\/strong>“bug”.
Which is better than if the opposite was true — letting you
create tables and expressions with ambiguous identifiers. <\/figcaption><\/figure>\n\n\n\n

AI using PowerShellAI<\/a><\/h2>\n\n\n\n
\"\"
Powershell \/w the module PowerShellAI<\/a><\/figcaption><\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
# the original version that didn't parse \n# because ',' made number endings ambiguous\n'1,000,2,000,3,000,0,000,1,000,2,000,3,000,0,000' -split '\\,'\n| Join-String -sep ' ' -SingleQuote\n| Label 'original' -Before 1\n\n'1000', '2000', '3000', '0', '1000', '2000', '3000'\n| Join-String -sep ' ' { '{0:n0}' -f @( $_ -as 'int' ) } -SingleQuote\n| Label 'should be' -Before 1 -After 1\n <\/code><\/pre>\n\n\n\n
<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n
$result ??= @{}\n( $result.Steps1 ??= ai '# first 100 numbers modulous 4, multiplied by a factor of 1e6' )\n| renderNice | Label 'Step1' -bef 1\nhr\nlabel 'step3' -after 1 'This time it''s parsable, but, the numbers are not the same different.'\n$result.Steps3 -split ',' -replace "'", '' | renderNice <\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
Power BI AI using PowerShellAI<\/p>\n","protected":false},"author":1,"featured_media":2664,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[72,13,95],"tags":[127,146,6,147,116],"_links":{"self":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts\/2650"}],"collection":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/comments?post=2650"}],"version-history":[{"count":7,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts\/2650\/revisions"}],"predecessor-version":[{"id":2665,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts\/2650\/revisions\/2665"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/media\/2664"}],"wp:attachment":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/media?parent=2650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/categories?post=2650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/tags?post=2650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}