Integrating Revel to Power BI

[niv_qrm]

Hi,

I am looking into ways to connect Revel (iPad based POS with SQL backend) to Power BI.

Has anyone done this? 

Right now I am downloading the data in csv and creating reports in Power BI and publishing them to the portal. I am trying to avoid this manual process and would like to know if there is a way to connect to the system directly.

Any help/ ideas much appreciated. 

Thanks a ton! 

[Anonymous · Accepted solution]

Hi @niv_qrm 

Here is the offical blog with all data source Power BI supports.

For reference: Power BI data sources

Power BI doesn't support you to connect to Revel directly currently.

I find that many people will connect Revel to a thired party data warehouse, then connect to this data warehouse by Power BI connector. This way may make your data unsafe.

Here I have some advices.

1. You can check whether Revel support Rest API, you can try to connect Revel POS by Rest API.

For reference: Using a REST API as a data source

2. You can try to build a custom connector.

For reference: Starting to develop custom connectors

3. I suggest you to export data as csv and connect to this csv file by Power BI.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.