Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Fetch only the latest entry from a SharePoint List

Hi all,


I have setup a quiz in SharePoint with some calculated columns to work out the scores. I would like to create a Power BI dashboard that the user can view their results on. 

 

I have setup a Flow which adds all of the SharePoint entries to a dashbaord but what I need is for only the most recent Items results to show for the user to see.

 

Is this achievable and if so, how can I do this?

Thanks all!

Need Help

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    Do you connect to sharepoint online or on premise with Power BI Desktop or Service?

     

    If you connect to sharepoint with Power BI Desktop,

    create measures with DAX function and create visuals on reports,

    then publish the report to service, share the report to others, so they can see lastest data.

    If you want user a only see his own lastest data, user b see his own lastest data too, please configure RLS for the dataset.

     

    If more detailed information provided, i can make a test and provide detailed solutions.

     

    Best Regards
    Maggie

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Maggie,


      I am connecting to SharePoint Online using Power BI desktop.

       

      I am very new to Power Bi so will try and offer some more info below:

       

      I have created a SharePoint List that only 2 people have access to

      We have one person who will sit in a room with someone and go through the SharePoint quiz (form in PowerApps) with the indvidual taking the quiz. 

      This form is submitted to the SharePoint List which is linked to Power BI

      Once the PowerApps form is submitted, the individual is taken to a results page that has embedded Power BI tiles

       

      What we really need is for this to only display the last submitted info if that makes sense.

       

      I will look into RLS in the mean time. thanks for your help