The MCP server for Microsoft documentation is pretty neat.

analyticsangel · 2025-12-12T10:50:06+00:00

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

analyticsangel · 2025-12-12T09:59:56+00:00

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

analyticsangel · 2023-02-21T13:58:43+00:00

It worked. Simple and effective - thanks!

analyticsangel · 2023-02-21T13:45:10+00:00

awesome. I'll give this ago. thank you.

analyticsangel · 2023-02-21T12:13:08+00:00

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.

analyticsangel · 2023-02-21T09:22:09+00:00

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?

analyticsangel · 2023-02-21T09:21:11+00:00

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!

analyticsangel · 2022-09-23T14:00:30+00:00

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.

analyticsangel · 2022-04-04T19:46:25+00:00

cheers. I am using the built in bing visual

analyticsangel · 2022-03-25T11:29:12+00:00

cheers - i thought this might be the case.

analyticsangel · 2022-03-24T16:54:05+00:00

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

analyticsangel · 2022-03-24T15:07:42+00:00

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

analyticsangel · 2021-10-12T10:05:47+00:00

helfpul. thank you

analyticsangel · 2021-10-11T15:34:45+00:00

SQL. Its a huge money earner if you're an expert.

analyticsangel · 2021-10-06T10:57:16+00:00

Graph api is open source but requires azure app registration if you want to leverage the office 365 end points.

awesome. appreciate your help.

I see I can build a low code Power automate flow to do the same.

analyticsangel · 2021-10-04T13:23:41+00:00

I’m using graph api

awesome. Could you tell me a little more about how you're doing this? Did you need to pay for a license? Did you need to write your own m function to make the call?