Forum Discussion

salqthami's avatar
salqthami
Regular Visitor
7 years ago
Solved

Connect POS system to Power BI

Hi there,   I want to help my friend which has a new retail store by creating a dashboard for him to monitor his sales based on some KPIs and metrics. however, I am still new to power BI and I do n...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

salqthami,

Do you mean that the POS system data is stored in a SQL Server database?

If so, you can connect to the SQL Server dtaabase using DirectQuery mode in Power BI Desktop. Create report in Power BI Desktop and publish report to Power BI Service, and set schedule refresh for the dataset in Power BI Service. Please note that you would  need to add SQL Server data source within gateway following the guide in this article:https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql.

Regards,
Lydia

  • salqthami's avatar
    salqthami
    Regular Visitor
    7 years ago

    thank your Lydia for your reply. if i do so, can i get real-time streaming of the data?

      • salqthami's avatar
        salqthami
        Regular Visitor
        7 years ago

        Thanks a lot, Lydia I will try it now. so the first solution when I want to get data from server but this data is fixed. the second solution for real-time streaming.