i got this question in one of my interview. Thank u for making such a great content in real time scenario. Your way of explanation is really simple n effective.
thanks, connecting via view, would it affect performance and very slow ? my dwh admin asked me to push all the calc back to dwh engine and only return the results, not load to power bi and then do calcs...... im not expert but my understanding is if tables are used in connection, they are extracted first and stored in laptop memory right ? thats why if its millions of rows it can be very slow, is it the same with connect via view , also slow as tables ?
@@AnalyticswithNags so via ODBC connections, tables are extracted and stored in laptop memory, which is not ideal. But connecting via advanced editor is using VIEWS , so performances are much better ?
Have one question on this topic. Suppose the Name of table is changed again by someone then do we need to change that table name again in SQL statement where we already have created a view?
@Analytics with Nags hi, I did the same way using views instead of tables, but get data from a view after you save and close and reopen the power query it has an error the same one you got, expression error the key doesn't match any rows in the table? please help
If you keep commenting on the same thing you needed in out of context in different videos again and again even after replying to the comment, we may have to block you from the channel.
![NISAMANEE - TADA (ท้าดา) [ OFFICIAL MV ]](http://i.ytimg.com/vi/hcQHEPMmJpU/mqdefault.jpg)
thank you! this is really helpful!
Glad it was helpful!
i got this question in one of my interview. Thank u for making such a great content in real time scenario. Your way of explanation is really simple n effective.
Thanks keep learning. Share this channel with friends and colleagues
Thank you Nags!
Glad to help
Great video! Can you insert multiple views into Power BI at one time through the "Get Data" icon? If so how? Thanks in advance!
thanks, connecting via view, would it affect performance and very slow ? my dwh admin asked me to push all the calc back to dwh engine and only return the results, not load to power bi and then do calcs...... im not expert but my understanding is if tables are used in connection, they are extracted first and stored in laptop memory right ? thats why if its millions of rows it can be very slow, is it the same with connect via view , also slow as tables ?
No. This is good practice
@@AnalyticswithNags so via ODBC connections, tables are extracted and stored in laptop memory, which is not ideal. But connecting via advanced editor is using VIEWS , so performances are much better ?
Thanks for sharing
Thanks for watching!
Have one question on this topic. Suppose the Name of table is changed again by someone then do we need to change that table name again in SQL statement where we already have created a view?
Yes. Changing view simple than the doing it in power bi
Very useful , thank you
Thanks keep learning
@Analytics with Nags hi, I did the same way using views instead of tables, but get data from a view after you save and close and reopen the power query it has an error the same one you got, expression error the key doesn't match any rows in the table? please help
Refresh the table in power query
@@AnalyticswithNags thanks u are the man
Thanks for sharing the concept, it is really helpful
Glad it was helpful!
Hi, suppose if we have many tables for a project do we need to access all of them through Views?
Yes for all tables we need to create a view
Hello nag ji , could you please make a playlist for SQL videos also...
Already have playlist for this
SQL Full Course | SQL Tutorial For Beginners: th-cam.com/play/PLjNd3r1KLjQtFEklcPDhidqC_2lmpjk5H.html
Can we Create a View without SSMS? (Just in Power BI)
No. Power bi can’t write back anything in source
@@AnalyticswithNags what if it’s imported already (on Import mode)
Please make video,how to unit testing pbi reports with SQL,please make a video
If you keep commenting on the same thing you needed in out of context in different videos again and again even after replying to the comment, we may have to block you from the channel.
Thanks bro
Welcome