A user has been making changes to a SQL view (added three columns) and used these new fields for some calculations in PowerBI. The user had no problems after updating the view and then refreshing data on her computer: The new fields where added.
She uploaded to GitHub and I downloaded from there. But I cannot USE these new fields (I can see them in the column list, but when using them, I get the below error).
So to me it seems as if the data is somehow ALMOST gone through in PowerBi (I can see the columns and data in the PowerQuery part), but when using them in PowerBI Desktop it fails.
We are using the same version of PowerBI Desktop (Nov. 2021).
Feedback Type: Frown (Error)
Local Time: 2021-12-13T16:33:04.4298783+01:00
Session ID: 988b5a4e-39fa-4d85-9f18-01d77c9bc16c
Release: November 2021
Product Version: 2.99.862.0 (21.11) (x64)
OS Version: Microsoft Windows NT 10.0.14393.0 (x64 en-US)
CLR Version: 4.7 or later [Release Number = 528049]
According to your description, it seems that you opened the pbix file on a different PC environment and the report is using the Direct query mode, do you have the access to the SQL Server data source in your PC environment?
And you said that you can’t use the newly added three columns, do you have access to use the original columns in the Power Query? I think you can go to have a check.
I also suggest you to update to the latest version of the Power BI desktop.