Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

stream data from O365 list using console application

Hi Team, As part of POC, we are analyzing the features of Power BI REST API to stream line data from O365 sharepoint List to POWER BI online.as part of this exercise, we created a console applicat...
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    Anonymous wrote:

    HI Buddy,

     

    Thanks for the reply.

     

    When i did some research on Power BI desktop version, i have seen a way to connect data to Sharepoint Online List abd publish the file to Power BI Online. So, here are my next set of queries related to Power BI. Please correct me if i am wrong

     

    1. Is it possible to fetch data from two different sharepoint list and publish it as a dataset to Power BI Online. (FYI, the two lists are connected using the lookup column)

    2. If the above scenerio is possible, is there a way to refresh the dataset which is a combination of two lists.

    3. One of the link related to Power BI says that, automatic refresh will trigger on a daily basis for the free version.

    4 When the refresh triggers, will this refresh dataset when we update any field in the sharepoint list.

     

    Please advise on the above set of queries.

     

    Regards,

    Sivapratap.


    Anonymous
    1. You can set more than one.two.three...different sharepoint lists in one dataset, I don't excatly know the limitation.

    2. It's ok to refresh a dataset containing many sp lists.

    3&4. It should update all the information of the lists.