We have an issue in PowerBI: 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 th...
Status changed:
New
to Investigating
Hi,
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.
For more info, please refer to this link:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
Thank you very much!
Best Regards,
Community Support Team _Robert Qin