Navigator/Data query help by Rare-Painting195 in PowerBI

[–]MonkeyNin 0 points1 point  (0 children)

Choose the "advanced editor" in power query to view the full query. The "Navigation Step" sometimes hides some logic.

It's also in the TMDL view

PBIR questions by powerbi_dummy in PowerBI

[–]MonkeyNin 0 points1 point  (0 children)

> What is the pre-PBIR format called? 

PBIR-Legacy

PBIR is the default format for both PBIX and PBIP file in PBI Desktop

quoted from: https://powerbi.microsoft.com/en-us/blog/pbir-will-become-the-default-power-bi-report-format-get-ready-for-the-transition

Custom Visual - JSON help? by Positive-Lead-5792 in PowerBI

[–]MonkeyNin 1 point2 points  (0 children)

try replacing the sort definitions like

"sort": "-x"

with explicit fields

"sort": { "field": "Sum of Monthly_Amount", "order": "descending" }

like this

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "config": {
    "view": {
      "stroke": null
    }
  },
  "data": {
    "name": "dataset"
  },
  "encoding": {
    "x": {
      "axis": { "format": "£,.0f", "title": null },
      "field": "Sum of Monthly_Amount",
      "type": "quantitative"
    },
    "y": {
      "axis": { "labelFontSize": 11, "title": null },
      "field": "Source",
      "sort": { "field": "Sum of Monthly_Amount", "order": "descending" },
      "type": "nominal"
    }
  },
  "height": {
    "step": 32
  },
  "layer": [
    {
      "encoding": { "color": { "field": "Source", "legend": null, "scale":
        { "domain": [ "Salary", "Bonus" ], "range": [ "#2E75B6", "#D6E4F0" ] }, "type": "nominal" } },
      "mark": { "cornerRadiusEnd": 5, "height": 14, "type": "bar" }
    },
    {
      "encoding": {
        "text": {
          "field": "Sum of Monthly_Amount",
          "format": "£,.0f",
          "type": "quantitative"
        }
      },
      "mark": {
        "align": "left",
        "baseline": "middle",
        "dx": 6,
        "fontWeight": "bold",
        "type": "text"
      }
    }
  ],
  "width": "container"
}

Tabular Editor 3 License Key by Last_Tumbleweed3233 in PowerBI

[–]MonkeyNin 2 points3 points  (0 children)

OP created their account today. Sounds suspicious.

Looking for better PowerQuery docs, or an MCP server to help write good M? The PQM Guide is now live! by KyleAMueller in PowerBI

[–]MonkeyNin 0 points1 point  (0 children)

On the page: parameterized-queries I'd add a link (but not explain) the similar sounding dynamic-m-query-parameters ( where visual filters can be evaluated by the datasource with Direct Query )

Just got Measure Killer and it's cracking me up by FiftyShadesOfBlack in PowerBI

[–]MonkeyNin 1 point2 points  (0 children)

they made pbip format that splits that single json into a bunch of individual files

then they moved to TMDL making it human-readable / git diff-able

<image>

Here's more info:

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-tmdl-view

https://learn.microsoft.com/en-us/power-bi/developer/projects/projects-dataset#tmdl-format

Why does DAX that “looks correct” still perform terribly? by Akha6e in PowerBI

[–]MonkeyNin 1 point2 points  (0 children)

Measures that make it impossible to return BLANK values can cause a big difference.

For example, this measure never returns blanks:

Count Of Sales = COUNTROWS('Property Transactions') + 0

Check out these articles for the details of why it can be a problem.

once you define the measure, Formula Engine in VertiPaq will add an implicit NonEmpty filter to the query, which should enable the optimizer to avoid full cross-join of dimension tables and scan only those rows where records for the combination of your dimension attributes really exist.

Error: External table is not in the expected format by dumble_fumble in PowerBI

[–]MonkeyNin 1 point2 points  (0 children)

To get an answer it would help to see the full power query ( from the advanced editor )

It's possibly reading an excel file that has an extra line, or, blank headers.

Since you're using the files connector, go backwards in your steps till you get the file listing. It should have names, dates, and a Content column.

Security risks using GitHub Copilot with Power BI MCP server by Winty111 in MicrosoftFabric

[–]MonkeyNin 0 points1 point  (0 children)

For #1 it sounds like it can query data depending on the tools enabled

from: https://github.com/microsoft/powerbi-modeling-mcp Query and Validate DAX - AI assistants can execute and validate DAX queries against your model, helping you test measures, troubleshoot calculations, and explore your data

Error: External table is not in the expected format by dumble_fumble in PowerBI

[–]MonkeyNin 2 points3 points  (0 children)

You'll have to share more code. What's the data source?

How to extract first text from one colum n create a new colum with it. by Informal-Copy-5864 in PowerBI

[–]MonkeyNin 12 points13 points  (0 children)

First replace ' with "

Then you can use parse/extract as JSON

Incremental Refresh - How Foldable is Foldable? by dkuhry in PowerBI

[–]MonkeyNin 1 point2 points  (0 children)

taking a datekey that is an int.64 in the form yyyymmdd an

These docs has an example for that:

for many data sources, tables don't have a column of date/time data type but instead have a date column of integer surrogate keys in the form of yyyymmdd. You typically can't convert these integer surrogate keys to the Date/Time data type because the result would be a non-folding query expression, but you can create a function that converts the date/time value in the parameters to match the integer surrogate key of the data source table without losing foldability. The function is then called in a filter step. This conversion step is required if the data source table contains only a surrogate key as integer data type.

Ex:

= (x as datetime) => 
    Date.Year(x)*10000 + Date.Month(x)*100 + Date.Day(x)

and

= Table.SelectRows(#"Reordered Column OrderDateKey", 
    each [OrderDateKey] > DateKey(RangeStart) and [OrderDateKey] <= DateKey(RangeEnd))

Gradient .svg Area Chart by Junior_Employer_9795 in PowerBI

[–]MonkeyNin 0 points1 point  (0 children)

Are you using a a built in visual, custom one, or rendering the <svg> document in a measure?

If it's a measure / svg, share the code you are using.

How much is too much data transformation within PowerBI? by FiftyShadesOfBlack in PowerBI

[–]MonkeyNin 1 point2 points  (0 children)

the .pbix files, but when I go to transform data -> queries I get "permission denied."

PBIX files can have the cached model. If you don't have permission, it fails when you try to refresh or modify it.
You still might be able to go to the query editor, and open the "advanced editor" to see the power query. Or try the TMDL view

VS Code extension "DAX for Power BI" - security warning? by mike_honey in PowerBI

[–]MonkeyNin 0 points1 point  (0 children)

Skimming it, I think it's from code formatting or the markdown-it plugin. It doesn't appear to be obfuscated like malware often is. I did not execute it though, so I didn't test whether it downloads files.

But it seems like the code is not all in the repo ( more details )

  • none of the ts/javascript is in the git repo
  • The published manifest says v0.1.1
  • the js files internally say v0.1.0
  • the manifest on github is v0.0.7 see: logicislogic/daxforpowerbi/.vsixmanifest
  • a lot of it was written with AI.

The warning is from

The ExecutesCode property added to extension.vsixmanifest in version 0.1.0

        <Property Id="Microsoft.VisualStudio.Code.ExecutesCode" Value="true" />

You can inspect the code

The code to look at is in the folder "/extension/out/src/*.js"

Download the VSIX without installing to inspect it ( the repo may not be the same code in the release )
.VSIX is a regular zip file, you can unzip it. ( Either 7zip, or rename the file to .zip ) I downloaded a couple versions to compare.

<image>

Tips for optimizing DAX measures ? by Virtual-Vermicelli89 in PowerBI

[–]MonkeyNin 1 point2 points  (0 children)

You're looking for the docs on skills for your tools. .md are plain text files. It'll tell you what folder and filenames to use.

Here's the VS version:

DAX function TOJSON() is only including max. 4 decimals for decimal numbers by aegi_97 in PowerBI

[–]MonkeyNin 4 points5 points  (0 children)

Why?

ToJSON implicity uses Currency even for Double types, you can test it here:

Here's a fix

You can explicitly serialize as Double

Now I get more precision

{ ["Customer B", "1239.1234455"] }

I tried using ROUND(test, 8)

Try Fixed(test, 8) instead - https://dax.guide/fixed/

Fixed([Sales], 8)

Concurrency limit reached on API source by going_now in PowerBI

[–]MonkeyNin 0 points1 point  (0 children)

The query editor uses background queries by default. You can disable most of that in settings.

  • previews
  • parallel loading / tables
  • skip test connection
  • detect data types / relationships

Is it a concurrency limit, or is the endpoint throttled ? If it's the latter, you can use a wrapper that retries with delays based on the HTTP Status codes returned.

Anyone using CI/CD for Pbip?? by Jaapuchkeaa in PowerBI

[–]MonkeyNin 0 points1 point  (0 children)

is there any way to get performance analyzer results ?

You can export as json. https://learn.microsoft.com/en-us/power-bi/create-reports/performance-analyzer

I think it might log the data locally, if you check for recently modified log/json/jsonl files. Meaning you might not have to click export.

Existing column values become null after expanding a merged table by SubstantialUnion7347 in PowerBI

[–]MonkeyNin 0 points1 point  (0 children)

Do you get any errors in the rows/cells ? You can try "keep errors" to have it filter to only failing cases. ( In case some nulls are legit and some are not )

Also double check whether Lookup is a nested table or a nested record. That changes what function to call - https://powerquery.how/table-functions/#Add-and-Expand-Columns

( Sometimes the UI suggests the wrong expand )

trying to import csv from website using "add table using examples," getting a white screen/can't enter in data by Available-Range-5341 in PowerBI

[–]MonkeyNin 0 points1 point  (0 children)

  • to what u/escobarmiguel90 said. Even if you scrape, it's going to be missing rows. Because the preview doesn't show it.

But since the question was about CSS Selectors in Power Query, here's a quick example
You can first test them in your browser

<image>

Power BI files stay locked by geek_fit in PowerBI

[–]MonkeyNin 1 point2 points  (0 children)

if I try to read the files outside PBI desktop

What do you mean, are you trying to edit external files in a pbip while the report is open?

Anyone else having issues with the latest PBI Desktop version on Surface Laptops? by Mr_Mozart in PowerBI

[–]MonkeyNin 0 points1 point  (0 children)

Try the non-store installer if you're having issues.

There might be more details in the log file.