Forum Discussion
DataSource.Error: Invalid column name
- 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
The easiest way to fix this is just to refresh the preview.
So go Edit Queries>Refresh Preview
- Anonymous5 years agoNot applicable
Legend!
- Anonymous5 years agoNot applicable
Fixed my issue! Great Answer.
- Inigo_Montoya4 years agoRegular Visitor
Axit is out here DOING THE WORK. Smarter, not harder folks! Thanks!