Hi, hope you are doing well. I am building a report in power bi for which my source is from SQL. I had joined two tables and did some transformations in SQL itself. Now i am having a derived table from the exiting tables. I need to connect this cleaned table to power bi. Can i create a view for the transformed table and connect to power bi. If yes, will the views table get updated if the underlying tables are being updated. Kindly help I created a view and connected it to power bi, but want to know if there are any other ways.
amazing explaination
Glad that you liked it. Thank you.
Useful video, Good explanation
Glad that you liked it. Thank you.
Hi, hope you are doing well. I am building a report in power bi for which my source is from SQL. I had joined two tables and did some transformations in SQL itself. Now i am having a derived table from the exiting tables. I need to connect this cleaned table to power bi. Can i create a view for the transformed table and connect to power bi. If yes, will the views table get updated if the underlying tables are being updated. Kindly help
I created a view and connected it to power bi, but want to know if there are any other ways.
That should work. You can use the view. Thanks