Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

SharePoint list and Power Bi

Hello All,

 

I am nee to 0365 (SharePoint and Power Bi (PB) ).

I have a SharePoint list, which I have connected with power Bi desktop. How can I setup an automatic/ schedule refresh? Do I need to connect power BI online with SharePoint list? If yes, please guide me beacuse my data is not get refreshed (I need to do manually in PB desktop and pubclish to PB online)

Dashboards
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Anonymous,

     

    Does the report only contain one data source (Sharepoint online list)? If it is, Data source credentials tab should be clickable. 

     

     

    Best Regards,
    Qiuyun Yu 

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    What i did to get my dataset to update automatically was i created a flow in power automate. So when my SharePoint list updated the dataset in power BI will also be updated.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous 

       

      That was a very nice idea! I like it!

      Now the "dataset" is updated automatically! If we could find a way to automatically "Refresh" the dashboard as well, then that would be perfect! In that case, the user just goes to the online dashboard and views it without the need to press "Refresh"! Not all users know how it works, so they don't know they should press Refresh!

       

      Any solution?

       

      Update:

       

      I found a work-around to refresh page even at a level of ms! It can be done using Play Axis viz.

      See here: https://www.youtube.com/watch?v=iyGBZsLxe54

       

      Another Update:

       

      Unfortunately the above method does not work as powerful as a real "Refresh" button! For example, if you have a slicer of names of employees, that does not update with each refresh of Play Axis. So, it is not fully effective.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thank you for your prompt response. I appreciate that.

      I followed the given direction and tried to enter credential but my the field 'Data Source Credential' is grayed out for me. I am not able to click on that field. Please advise and thanks in advance!

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        8 years ago

        Hi Anonymous,

         

        Does the report only contain one data source (Sharepoint online list)? If it is, Data source credentials tab should be clickable. 

         

         

        Best Regards,
        Qiuyun Yu