cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jdb Frequent Visitor
Frequent Visitor

using SQL views instead of Power BI transformations and relationships?

OK, I'm probably thinking about this the wrong way since I'm coming from a SQL background.

 

But for the first two sections of the course, I would implement these functions (transformations and relationships) as views in SQL, and then build Power BI reports off the views.

 

Advantages I see are SQL views are easier for me to build and debug, may perform better since the work's done on the server, and offer better reuse across other applications.

 

Is there anything fundamentally wrong with this approach?

1 REPLY 1
Highlighted
SamLester Established Member
Established Member

Re: using SQL views instead of Power BI transformations and relationships?

I definitely agree. It's typically a good strategy to push as much of the calculations into the database / data warehouse as possible for the reasons you stated. One additional key reason is that if there are several people creating reports on the same raw data, they will each interpret the data and report calculations differently and you may end up with conflicting reports. By creating these functions/SPs in the DB, you'll avoid this issue.

 

Thanks,
Sam Lester (MSFT)

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 330 members 3,329 guests
Please welcome our newest community members: