Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
rocky09
Solution Sage
Solution Sage

most frequently using queries to organize data for visualization

I am new to this Power BI. My Management asked me work on PBI Reports. I have referred few Community Videos on Youtube and played with some sample data. I can say, this is a Most Power Tool. 

I have to work on large database (Oralce). It contains more than 40 tables. Can any one guide, what are the most using queries by you. Because, I am not familiar with advanced queries.

Please suggest me some tutorials and links in terms of different scenarious. So, I can get hand on the Queries stuff.

I guess, I have explained well. If not, please ask me. So, I will try to provide more information.

1 ACCEPTED SOLUTION

@rocky09

 

When retriveing data, you can just use T-SQL query to get the data. Power BI will generate Power Query which you can edit it in Query Editor (Advance Editor). For Power Query (M language), please see: Power Query (informally known as "M") Formula reference.

 

For retrieved dataset, you can use DAX to add measure and calculated column for your calculation. For DAX tutorials, please see: DAX basics in Power BI Desktop

QuickStart: Learn DAX Basics in 30 Minutes

SQL Server DAX Tutorial Overview

 

Regards,

View solution in original post

4 REPLIES 4
malagari
Responsive Resident
Responsive Resident

Before I can recommend any resources, how familiar are you with relational databases?  Understanding how all of the tables relate to one another is crucial when working with BI.

Dan Malagari
Consultant at Headspring

Hi Dan,

 

Thank you very much for you reply.  Yeah, I have basic knowledge on relational database. I used to work on MS Access Queries.

@rocky09

 

When retriveing data, you can just use T-SQL query to get the data. Power BI will generate Power Query which you can edit it in Query Editor (Advance Editor). For Power Query (M language), please see: Power Query (informally known as "M") Formula reference.

 

For retrieved dataset, you can use DAX to add measure and calculated column for your calculation. For DAX tutorials, please see: DAX basics in Power BI Desktop

QuickStart: Learn DAX Basics in 30 Minutes

SQL Server DAX Tutorial Overview

 

Regards,

@v-sihou-msft

Thank you so much. 🙂

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.