Forum Discussion

GISmorocco's avatar
GISmorocco
Frequent Visitor
9 years ago

Added column in sharepoint list not imported after refresh

Hi 

 

I added 2 columns to my sharpoint list wich is part of Power Bi dataset ,After refresh my added columns aren't imported .

 

I can't find them in the field list in query edit either. Please help i've been looking for a solution for 2 days .

 

 

Thanks,

20 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Are you connecting directly to your SharePoint list or do you use an SQL database as in intermediary?

    • GISmorocco's avatar
      GISmorocco
      Frequent Visitor

       

       

      Actually it  an access database published in sharpoint site to permit data edit contribution .So the data is stored as sharepoint list , i added the columns on sharepoint .When i imported the sharepoint list to a new database to test if i can find my added columns , i did find them  . But in power bi  still i can't . Can you point out the problem ? 

       

      Thank you for taking time to  help 

      • Anonymous's avatar
        Anonymous
        Not applicable

        Do the columns appear in the Access database?  Could the database be tied to the existing schema and not be set up to dynamically expand with the new columns?

         

        I'm facing a similar problem where we have an external company managing various databases, one of which stores our sharepoint lists and libraries.  I'm facing a problem where the newer columns just don't exist in the sharepoint list i'm trying to use.  I'm trying to get them to sort it.  It feels like a static link to the table columns.

    • munchkin666's avatar
      munchkin666
      Icon for Helper II rankHelper II

      It would be brilliant, if there was any solution to that 😞