Forum Discussion
Austen229022
Helper II
Helper IIConnecting to SQL Server while keeping relationships active
New to dealing with SQL Databases in Power BI so would love some help Currently I am working with SQL database that I am wanting to import the Live Data into Power BI, which I can do then chose t...
Austen229022 I would recommend creating a view in the SQL putting the logic there and then using that view in Power BI to pull the data. If tomorrow there is a need to change the logic, you can do it in the view, and no need to touch Power BI.
parry2k
Super User
Super UserAusten229022 I would recommend creating a view in the SQL putting the logic there and then using that view in Power BI to pull the data. If tomorrow there is a need to change the logic, you can do it in the view, and no need to touch Power BI.
Austen229022Thanks for replying
So when you go through importing the DB from SQL, you would select the view?