Forum Discussion
Questions about SQL applied to Power BI.
Hi Pacopil48
I'm not sure what scenario the document you're looking at applies to. For example, if the data source is a database and the connection mode is not Import, some users may choose to transfer some complex operations to the data source and perform only simple operations in Power Query, because SQL itself has better data processing performance than Power Query. If the amount of data you need to process is not large, or the amount of data is large but the data conversion operations required are relatively simple, you don't really need to learn SQL. My suggestion is that you can first learn according to the Power BI learning path in the official document.
Browse all courses, learning paths, and modules - Training | Microsoft Learn
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Good morning
Thank you for your reply. The reason for asking my question is because I read on some internet sites that SQL is important to apply in Power BI. If we already have Power Query to perform data cleansing and different operations... Why do I need to know how to do the same with SQL? Is it necessary to take a course on how to process information with different functions in SQL, if I only want to apply it to Power BI?
That is the question.
I understand from your answer that it is not necessary. That I just have to know how to connect with that data source and once the information is downloaded, work in query.
That's right?
Thank you very much and forgive me for insisting on the question.
Best regards.
Hi Pacopil48
I'm not sure what scenario the document you're looking at applies to. For example, if the data source is a database and the connection mode is not Import, some users may choose to transfer some complex operations to the data source and perform only simple operations in Power Query, because SQL itself has better data processing performance than Power Query. If the amount of data you need to process is not large, or the amount of data is large but the data conversion operations required are relatively simple, you don't really need to learn SQL. My suggestion is that you can first learn according to the Power BI learning path in the official document.
Browse all courses, learning paths, and modules - Training | Microsoft Learn
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Understood. Thank you very much for your answer and for clarifying my doubt. Very clear. Thanks also for the suggestion. I will do so.