Forum Discussion
Solved
Connecting 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.
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.
Thanks for replying
So when you go through importing the DB from SQL, you would select the view?