Forum Discussion

loginj's avatar
loginj
Regular Visitor
9 years ago

Sharepoint and PowerBI column refresh

Using PowerBI Desktop with Sharepoint 0365 - have a Sharepoint list that I can connect to and refresh.

 

I have made several changes to column names and column formats in the list, the changes are not showing up when I establish connection from PBI, even when I start from scratch.

 

Data in the columns is updated correctly.

2 Replies

  • loginj's avatar
    loginj
    Regular Visitor
    9 years ago

    Using PowerBI Desktop and Sharepoing O365 - I am able to access the Sharepoint List and refresh no problem.

     

    I have made several changes to column names, those changes are not showing up in PowerBI integration, even starting from scratch.

     

    Data in the columns is updating as expected.

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi loginj,

    I have made several changes to column names and column formats in the list, the changes are not showing up when I establish connection from PBI, even when I start from scratch.

    Could you try clearing cache under File -> Option -> Data load -> Data Cache Management Options first, then creating a new pbix file to import your SharePoint list data from scratch to see if it works?:smileyhappy:

     

    Regards