Forum Discussion

niv_qrm's avatar
niv_qrm
Frequent Visitor
5 years ago
Solved

Integrating Revel to Power BI

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! 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.