The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse 07-13-2022 07:09 AM

[Natalie_iTalent]

This is a live show hosted by Kelly Kaye, the Community Engagement Lead for Power BI. She is passionate about the Power BI Community, is the founder of the Power BI Women User Group and a Power BI developer.

On this episode, Kelly Kaye interviews Scott Sewell, who will discuss and demo how Power BI unlocks incredible insights for Power Apps, Dynamics 365, and the Dataverse platform.

Connect with Kelly on Twitter @MS_KellyKaye

Connect with Scott on Twitter: @scottsewell

Each Power BI Community show features different topics, speakers, and giveaways celebrating the awesome Power BI Community. We invite you to join us for this and past episodes.

Post your comments on https://aka.ms/PBIShowComment, so we can contact you if you are selected for a giveaway item!

Show Links:

•  Scott Sewell on LinkedIn:  https://www.linkedin.com/in/mscottsewell/

•  Scott Sewell on GitHub: https://github.com/mscottsewell/PowerBI-Dataverse

• Register on the Power BI Community:  https://community.powerbi.com/ for fun giveaways

• Connect with a Power BI User Group: https://aka.ms/PowerBIug

• Check out past episodes of the Power BI Community Show: https://aka.ms/PowerBIShow

• Power Platform Conference: https://powerplatformconf.com

watch?v=VZvE4dYw1ds

[lixia]

Favorit demo was : DEMO3 connecting power BI using Synapse Data Link because we are in the middle to implement it, this DEMO give me some practical ideas (specialy chart at time 52:09 used to explain "custom report views" for self BI datasets).

[mscottsewell]

Thanks! Glad it gave you some ideas for your own organization 

[GCashTisski]

Great show, really informative.  I liked the direct query to dataverse that picks up the security out of the box.  I will have to give it ago to see what the performance is like.  Thanks!

[mscottsewell]

Great to hear.

Keep in mind that comparing Direct Query to Import is an unequal matching. -There are advantages to Direct Query that Import doesn't have (security inheritance, subset querying massive datasets, just-in-time updates of data) - but the downside is that there is going to be a lag that is perceptible to the user while the query is executed and data retrieved from the server. - For that reason, it's a specialty use-case and should be used with very tightly optimized queries for relatively small resultsets. - 

[berntmagne]

Favorite demo was querying Dataverse with view in Power BI

[mscottsewell]

The Quick Create documentation can be found here:
Power BI quick reports in Power Apps | Microsoft Docs

[Chthonian]

Q: This was hinted at when Scott mentioned the 80MB limit for queries against Dataverse/CRM. Is there any negative impact to the performance of CRM when connecting directly via PBI? 

[mscottsewell]

Due to the TDS endpoint's architecutre's isolation and design, there's little to no discernable impact to the rest of the application performance for other users when a report is run.

[Chthonian]

Favourite demo for me was the "Current_User" flag for SQL Queries - LOVED that

[mscottsewell]

Here's the post I put on LinkedIn regarding that feature - 
In Power BI, filter a Dataverse source to create a "My"​ records query | LinkedIn

[Ulrik]

Favorite demo was the new feature when querying Dataverse data!! Keep the good stuff coming.

[mscottsewell]

Thanks! - Was there something specific that was helpful to you? (just curious as to what parts were most helpful)
Also - is your organization using Datverse/PowerApps/Dynamics yet - if so I'd love to hear how it's going! 🙂

[JoeGill]

Great session Thanks Scott & everybody involved 

[mscottsewell]

Thanks @JoeGill - I see your posts on the Dataverse-Power BI topics, please reach out if you want to collaborate.

[justinh]

I liked the demo for connecting to the datamodel from Power BI 

[justinh]

Q: I can chain dataflows together by using one dataflow as the source for another downstream dataflow. Can I do the same thing with Dataverse? Can one dataverse be used as the source for another dataverse?

[mscottsewell]

@justinh  - Data from one environment can be copied to another using tools like SSIS/ADF - but there's not a facility to make one environment a live sync'd or super/subset of another.

[sherifff]

What level of Liencesing is required to use the above features?

[mscottsewell]

There's no 'special' or additional license needed to integrate the products.

[b5lurker]

Love the ability for Power BI/Power Query to pull in the Dynamics column names in the Import from Dataverse. Hoping that this feature will get added as a view or something like that so that we don't have to deal with those background "ugly" names in Azure Synapse Link for Dataverse. 🙂  Thanks Scott, great to see you again and all of your Dataverse goodness.