topic Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse in Webinars and Video Gallery

The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

Natalie_iTalent — Thu, 16 Mar 2023 17:20:36 GMT

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

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

Natalie_iTalent — Mon, 11 Jul 2022 18:04:46 GMT

Thank you for asking your questions and posting your comments here!

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

justinh — Mon, 11 Jul 2022 18:32:20 GMT

I would love a vintage Power BI t-shirt!

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

Anonymous — Mon, 11 Jul 2022 18:33:02 GMT

I have not worked with the dataverse yet, but looking forward to trying it out. I like the demo on that. Thank you.

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

b5lurker — Mon, 11 Jul 2022 18:34:15 GMT

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.

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

sherifff — Mon, 11 Jul 2022 18:34:45 GMT

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

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

justinh — Mon, 11 Jul 2022 19:05:02 GMT

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?

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

justinh — Mon, 11 Jul 2022 18:57:02 GMT

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

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

JoeGill — Mon, 11 Jul 2022 19:02:33 GMT

Great session Thanks Scott & everybody involved

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

Ulrik — Mon, 11 Jul 2022 19:09:16 GMT

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

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

mscottsewell — Mon, 11 Jul 2022 21:15:56 GMT

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

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

mscottsewell — Mon, 11 Jul 2022 21:16:50 GMT

absolutely! - Great seeing you here.

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

mscottsewell — Mon, 11 Jul 2022 21:18:43 GMT

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

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

Chthonian — Tue, 12 Jul 2022 05:29:58 GMT

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

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

Chthonian — Tue, 12 Jul 2022 05:32:11 GMT

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?

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

mscottsewell — Tue, 12 Jul 2022 11:19:53 GMT

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.

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

berntmagne — Tue, 12 Jul 2022 11:31:09 GMT

Favorite demo was querying Dataverse with view in Power BI

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

Anonymous — Tue, 12 Jul 2022 12:22:13 GMT

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!

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

mscottsewell — Tue, 12 Jul 2022 13:42:04 GMT

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. -

Re: The Power BI Community Show Ep 8 - Power BI, Dynamics 365, and Dataverse

mscottsewell — Tue, 12 Jul 2022 13:45:20 GMT

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