Why you should use Views instead of Table - Power BI Desktop Tips and Tricks (32/100)

If you are connecting to database from power bi
Why you need to use views instead of directly pointing to a table
Advantages of using the view over the table
How to overcome the issue in one column causing the report failure.
#PowerBI #PowerBIDesktop #PowerBITutorials
✉ Business Queries / Analytics Consulting ✉ : [e-mail]
💬 For Learners Post queries and Interact 💬 : t.me/analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Power Pivot 📚📖 • Power BI Tutorial (15/...
Power Query 📚📖 • Power BI Tutorial (15/...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Tamil Tutorials 📚📖 • How to do Power BI Ins...
Power BI Telugu Tutorials 📚📖 • How to do Power BI Ins...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
MSBI Tutorials - SQL + SSAS + SSIS 📚📖 • Learn SQL Complete | C...
Data Analyst - Complete Reference - Playlist 📚📖 • Data Analytics For Beg...
BI Developer - Complete Reference - Playlist
📚📖 • Power BI Tutorial From...
BI Architect - Complete Reference - Playlist
📚📖 • Power BI Full Course -...
ETL Developer - Complete Reference - Playlist 📚📖 • Building an Enterprise...
Database Developer - Complete Reference - Playlist 📚📖 • SQL Tutorial - Full Da...

[@sonalijain9024]

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.

[@sikansamantara9504]

Thanks for sharing the concept, it is really helpful

[@AnalyticswithNags]

Glad it was helpful!

[@DataAnalytics2486]

thank you! this is really helpful!

[@AnalyticswithNags]

Glad it was helpful!

[@emma.data-life]

Thank you Nags!

[@AnalyticswithNags]

Glad to help

[@divyatv8422]

Very useful , thank you

[@AnalyticswithNags]

Thanks keep learning

[@stoneage8810]

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]

No. This is good practice

[@stoneage8810]

@@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 ?

[@KetkiShitut]

Thanks for sharing

[@AnalyticswithNags]

Thanks for watching!

[@trevorshao]

@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

[@AnalyticswithNags]

Refresh the table in power query

[@trevorshao]

@@AnalyticswithNags thanks u are the man

[@harshithabobolu7106]

Hi, suppose if we have many tables for a project do we need to access all of them through Views?

[@AnalyticswithNags]

Yes for all tables we need to create a view

[@hparap25]

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?

[@AnalyticswithNags]

Yes. Changing view simple than the doing it in power bi

[@lavanya.v125veeravalli4]

Hello nag ji , could you please make a playlist for SQL videos also...

[@AnalyticswithNags]

Already have playlist for this SQL Full Course | SQL Tutorial For Beginners: kzbin.info/aero/PLjNd3r1KLjQtFEklcPDhidqC_2lmpjk5H

[@ajaykumarvelivela9472]

Thanks bro

[@AnalyticswithNags]

Welcome

[@devinenipradeep7771]

Please make video,how to unit testing pbi reports with SQL,please make a video

[@AnalyticswithNags]

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.

[@macbelwoldie5696]

Can we Create a View without SSMS? (Just in Power BI)

[@AnalyticswithNags]

No. Power bi can’t write back anything in source

[@macbelwoldie5696]

@@AnalyticswithNags what if it’s imported already (on Import mode)