Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DataSource.Error: Invalid column name

Hi, this is quite an annoying error... have made some changes to the data source (in my case  SQL view) have edited my reports and all works fine but now when I open 'Power Query Editor' I get thi...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    I make a simple test as below: "import/ direct query" all works for following steps

    i connect to SQL with Power BI Desktop,

    then i delete one column from the data source,

    after clicking "refresh" button on "Home" menu and "Refresh all" inside the "Edit queries",

    it works and show the lastest table with one column disappeared in Power BI.

     

    "

    step1: have made some changes to the data source (in my case  SQL view)   

            (delete a column? change the column name?)

     

    step2: have edited my reports and all works fine             

             (do you refresh from Power BI after step1?

              if you add the column which was deleted in step1 to a visual, does it give any error?) 
    "

    Could you show some details what you do for the steps above so i can reproduce your problem?

     

    Best Regards

    Maggie

     

     

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

I make a simple test as below: "import/ direct query" all works for following steps

i connect to SQL with Power BI Desktop,

then i delete one column from the data source,

after clicking "refresh" button on "Home" menu and "Refresh all" inside the "Edit queries",

it works and show the lastest table with one column disappeared in Power BI.

 

"

step1: have made some changes to the data source (in my case  SQL view)   

        (delete a column? change the column name?)

 

step2: have edited my reports and all works fine             

         (do you refresh from Power BI after step1?

          if you add the column which was deleted in step1 to a visual, does it give any error?) 
"

Could you show some details what you do for the steps above so i can reproduce your problem?

 

Best Regards

Maggie

 

 

 

Transform121's avatar
Transform121
Helper I
2 years ago

Apologies for resurrecting an old thread but I've encountered this issue myself and have found a working solution that has resolved the issue. Post deployment we've had some columns removed from an on-prem database which has led to this error appearing as the columns are no longer available when connecting to a table.

 

For anyone who encounters this error and it displays in Power Query transformation try clearing the permissions on your data source and re-authenticate the connection. This has resolved the invalid columns error for me.