Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

PBIX not Refreshing New Sharepoint Data

I have uploaded data into sharepoint, and I am able to retrieve this data in Power BI.  I am able to use it with ease.  The problem is when a new report is placed into sharepoint.  It seems Power BI is unable to pull the new data into the report.  I have spent hours trying to solve this issue.  Errors are not being displayed.  I would welcome any help!  Thank you!

Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Anonymous ,

    As far as my test, it can refresh the new file, please check the following steps.

    1.In SharePoint, open your site and copy the URL.

    2.In Power BI Desktop, Get data>SharePoint folder.

    Directly paste the URL, it should be in this format: https://partner.onmicrosoft.com/sites/[Your Site Name]

    3.Then you can Combine & Transform Data.

    4.Then in the SharePoint, in your site>Documents, select Upload, upload your new file here.

    5.Then in PowreQuery, select Refresh Preview, the new file will display.

    Best Regards,
    Community Support Team _ kalyj

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

2 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

    As far as my test, it can refresh the new file, please check the following steps.

    1.In SharePoint, open your site and copy the URL.

    2.In Power BI Desktop, Get data>SharePoint folder.

    Directly paste the URL, it should be in this format: https://partner.onmicrosoft.com/sites/[Your Site Name]

    3.Then you can Combine & Transform Data.

    4.Then in the SharePoint, in your site>Documents, select Upload, upload your new file here.

    5.Then in PowreQuery, select Refresh Preview, the new file will display.

    Best Regards,
    Community Support Team _ kalyj

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

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

    Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

    Best Regards,
    Community Support Team _ kalyj