Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sharepoint and Streaming Dataset

Hello All,   I'm looking to achieve a "realtime" or "near-realtime" data updating for paginated reports and dashboards. For my purposes, the best way I can achieve this is through the office 365 an...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    If your data is not updated frequently, you can use the method GilbertQ  provides.

     

    Would you please  try to use the Power BI Streaming dataset (with Historic data option enable), we can use the Microsoft flow "when an item is created or modify" then "add a row to power bi dataset” ， it is nearly real-time. Then you can connect the streaming dataset in desktop and create complex report. 

     

    And you can also make a program which call the api to get data from sharepoint list and then store it into sql server, then we can connect the sql server by using DirectQuery Mode, it retrive the latest data from sql server when report refresh (not dataset refresh), then the only thing is scheduled the program to call api every serveral minutes, it can achieve  semi-real time experience. Please refer to this documents about the share point list api: https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-re...

     

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

     

    Best Regards,

    Dedmon Dai

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ,

 

If your data is not updated frequently, you can use the method GilbertQ  provides.

 

Would you please  try to use the Power BI Streaming dataset (with Historic data option enable), we can use the Microsoft flow "when an item is created or modify" then "add a row to power bi dataset” ， it is nearly real-time. Then you can connect the streaming dataset in desktop and create complex report. 

 

And you can also make a program which call the api to get data from sharepoint list and then store it into sql server, then we can connect the sql server by using DirectQuery Mode, it retrive the latest data from sql server when report refresh (not dataset refresh), then the only thing is scheduled the program to call api every serveral minutes, it can achieve  semi-real time experience. Please refer to this documents about the share point list api: https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-re...

 

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

 

Best Regards,

Dedmon Dai