MS Power Bi Integration

V5 Question
1

Just a question I got from a client.

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

2

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
3

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

1 Like
4

I´ve connected PBI directly into Sql. Works great

1 Like
5

You connected the PBI to the SambaPOS database on SQL Server Express? Is that a native function of the PBI or did you programmed a solution for this?

6

I took a look and there seems to be two options (built-in):

  • Connect directly to DB and use live data
  • Copy data locally use the working copy instead of hitting the DB all the time
3 Likes
7

Exactly, as @Memo says, you can do a direct query connection or choose to import data from the DB and do periodic refreshing.

1 Like