Forum Discussion

panurag1's avatar
panurag1
New Member
10 years ago

How to Auto refresh data in Power BI Desktop from SharePoint List

  I have installed Power BI Desktop in my machine ..and connected my SharePoint list with it.. I have also created the Graph, Charts using  Power BI.. How Can I automate the data refresh fo...
Need Help
Tutorial Requests
Elliott's avatar
Elliott
Advocate II
10 years ago

Automatic refresh is not available within Power BI Desktop

The only refresh option within BI Desktop is the manual Refresh you find in the top ribbon

 

Check out the following link for more information on data refresh:

https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/

 

If you require automatic refresh of your data, I would suggest publishing your report and looking into setting up a scheduled refresh.

More information on this is included in the link provided above.

  • mstefancik's avatar
    mstefancik
    Advocate IV
    10 years ago

    Elliott how can I refresh data based on sharepoint list when  I am using alternate windows credentials to connect to sharepoint lists.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I have this error message since this morning  

     

    An error occurred while processing the data in the dataset.
    Refresh failed:

    KPI RELEVE UNIQUE has failed to refresh.
    Failure details:
    Not a legal OleAut date.. The exception was raised by the IDataReader interface. Table: Relevé.
    Next refresh for KPI RELEVE UNIQUE is scheduled for May 28, 2019 15:00 UTC.

    Learn more >

     

    Technical Information

    Activity Id:
    2b261fcc-b867-4630-8b88-641d31be042a

    Request Id:
    fd8d3991-a9d7-463b-9fac-d3bd7dc47999

    Cluster Name:
    WABI-NORTH-EUROPE-redirect.analysis.windows.net

    Refresh Start Time:
    May 28, 2019 11:02 UTC

    Refresh End Time:
    May 28, 2019 11:58 UTC

     

     

    What can i do to solve?