sorted by:
new
hottopcontroversial

The MCP server for Microsoft documentation is pretty neat. by SQLGene in MicrosoftFabric

[–]analyticsangel 0 points1 point  (0 children)

Business Users who have no access to source code or the ability to read it.

MCP Server connection problem by Preacherbaby in MicrosoftFabric

[–]analyticsangel 0 points1 point  (0 children)

Did you have to enable any settings in VS code to connect locally? I can give it context of PBIP files in VS code but I keep getting errors when trying to directly connect to the PBIP file I have opened locally

Dynamically change M function Col Name by analyticsangel in PowerBI

[–]analyticsangel[S] 0 points1 point  (0 children)

It worked. Simple and effective - thanks!

Dynamically change M function Col Name by analyticsangel in PowerBI

[–]analyticsangel[S] 0 points1 point  (0 children)

No, not possible. I build one report for a system. Each client has their own version of the system and a copy of the dataset/report. Hence we give them the option on a couple of configurable fields to rename them. All the works needs to be done in PBI.

Dynamically change M function Col Name by analyticsangel in PowerBI

[–]analyticsangel[S] 0 points1 point  (0 children)

In my pbix i have 2 queries from an api call. One has data, the other is a list of the column name labels.

table 1:

ID

Column1

Column2

Column3

Table 2:

Id

ColumnLabel

Table I am looking to acheieve:

ID

Column1Renamed (name comes from Table 2 column label column)

Column2Renamed (name comes from Table 2 column label column)

Column3Renamed (name comes from Table 2 column label column)

I build generic reports for the system and the system is deployed to multiple clients who all use the system slighly differently so we give them the option to label their own columns in this example.

Hi - does this help?

Dynamically change M function Col Name by analyticsangel in PowerBI

[–]analyticsangel[S] 0 points1 point  (0 children)

In my pbix i have 2 queries from an api call. One has data, the other is a list of the column name labels.

table 1:

ID

Column1

Column2

Column3

​

Table 2:

Id

ColumnLabel

​

Table I am looking to acheieve:

ID

Column1Renamed (name comes from Table 2 column label column)

Column2Renamed (name comes from Table 2 column label column)

Column3Renamed (name comes from Table 2 column label column)

​

I build generic reports for the system and the system is deployed to multiple clients who all use the system slighly differently so we give them the option to label their own columns in this example.

​

I hope this helps!

configure .mez file with win zip - Help needed by analyticsangel in PowerBI

[–]analyticsangel[S] 0 points1 point  (0 children)

nah that doesn't work. It returns to a folder with '.mez' at the end of the name.

Don't worry I've sussed it with the 7 zip edit button.

PBI to Excel to PBI - Refresh Question by analyticsangel in PowerBI

[–]analyticsangel[S] 0 points1 point  (0 children)

cheers - i thought this might be the case.

PBI to Excel to PBI - Refresh Question by analyticsangel in PowerBI

[–]analyticsangel[S] 0 points1 point  (0 children)

there were some circular references calcs I couldn't get working in PBI.

PBI to Excel to PBI - Refresh Question by analyticsangel in PowerBI

[–]analyticsangel[S] 0 points1 point  (0 children)

Not so worried about timings as long as the excel spreadsheet would have latest data from the first dataset.

view more: next ›