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

     

     

     

Subhraz's avatar
Subhraz
Advocate I
7 years ago

Hi,

 

I faced the similar error and here's what I did.

1) Take a backup of your pbix file.

2) Go to Edit Queries and delete the dataset. This would take off your report and would show fix it. Let it be that way.

3) If it's a SQL view you drop and recreate it.

4) Get your dataset again. This would automaticlly bring back your report.

5) Go to Edit Queries and you can see that the error is no longer there.

 

Thanks,

Subhraz

Anonymous's avatar
Anonymous
Not applicable
7 years ago

If its SSAS Tabular in visual studio...

 

1 - copy out the M query from the advanced tab, something like 

let
Source = #"SQL/dn1dwhost01d;datawarehouse",
powerbi_Transactions = Source{[Schema="powerbi",Item="Transactions"]}[Data]
in
powerbi_Transactions

 

2 - Delete the query and create a new query

3 - Add the M query in the advanced tab

4 - Refresh Preview