MS Power Bi Integration

Just a question I got from a client.

Has anyone ever attempted to integrate data from the POS with MS Power Bi?

No, the hotel FD will likely be looking to do somethjng like that soon.
I didn’t look to deep into power bi other than finding its web api request seemed to use get rather than post making it hard to link to the hotel PMS so whipped up a mediator endpoint which relayed power bi web api get request to a pms api post request passing back the response.
In theory could create custom reqiest but couldn’t get to grips with the scripting language in power bi.
It would most likely be easiest to do sql connection in power bi as it is good for sql and json parsing s.

1 Like

I’ve known a couple power bi’s in my day. Sadly, no integration routes were available.

1 Like