Getting Started with Power BI Datamart

[@mau_lopez]

Fantastic demo. I really like the way in which Reza addresses the topic at hand in a very clear way but also compares with other tools in the platform or talks about other implications of the topic at hand, all of that in a very practical way.

[@jester667]

You still have access to the internet in Russia?

[@joaorataoo]

Very good demo! It has the ability to simplify all these otherwise confusing concepts. I have one question which is: how can I test and try all these tools and features without having a business account?

[@joelgagnon1]

This is a great functionality! Is there a chance it ever get GA?

[@PeterNovakIng]

Hi, it is possible to feed the datamart in workspace1 with dataset from workspace2? or into the datamart need to be loaded the sources from the dataset is created?

[@nadeemrajabali3166]

Great video again. We have Data Vault 2.0 on Synapse SQL pool. on Top of Data Vault we have hybrid Data Mart. Master Data Mart. We are planning to create Enterprise reporting data mart for Power Bi. Should we create reporting Data Mart in Power Bi service or that should also be created in SQL Pool

[@ericbeery8570]

That row-level security functionality looks interesting, but is it still possible to incorporate dynamic RLS? Seems that would require writing those filters with DAX...

[@RADACAD]

That is the part that I still need to investigate a bit. The idea is to have RLS from the database. but the UserPrincipalName is the function that make DRLS possible, and writing DAX isn't there yet, I guess it would be possible soon perhaps.

[@ericbeery8570]

@@RADACAD thanks! I'll be looking forward to a blog from you on it when it becomes more clear 🙂 Your articles on dynamic RLS were incredibly helpful for me.

[@jackstrudley1039]

@@RADACAD initially it looks like it's an oversight unless there's something fancy that can be done that isn't immediately obvious.

[@gabrielcanadeu2830]

Great Video !! Thanks for share ! I Have a question, in my case the "buttom" to export the datas to Excel are "Not Available" .. do you have some Idea that as happening? obs: have the option to export, but not working. In the Admin Portal, the "Export to Excel" option is Enabled Thanks

[@dp6736]

Thanks for amazing and useful tutorials.

[@krishnakishorepeddisetti4387]

can we add a calculated column ?? if yes...can you guide me how to do it ..thank you

[@priyavishalkulkarni2415]

Can we use Datamart as a Data Warehouse? If yes Data will be stored on Azure SQL Database. Is this storage charges included in Power BI license or need to pay additional amount?

[@RADACAD]

Yes, you can. Datamart will be included in Power BI Premium or PPU.

[@nasirrizvi550]

Reza, can you connect excel directly to the powerbi datamart like you can connect excel to azure AS tabular model?

[@RADACAD]

Hi Nasir. A datamart also creates a dataset. and you can connect to that dataset using Analyze in Excel or using the XMLA endpoint

[@nasirrizvi550]

@@RADACAD thanks Reza. So if I connect using excel to dataset, I can use =cube functions to query the dataset? Is the dataset an olap model or oltp? Datasets operate just like data in Azure AS?

[@tolgakaptan6633]

If we connect to Azure, can we see the DB created by a Datamart?

[@VictorHugo-bd3bf]

Fantastic video, Thanks, Reza.

[@oscararmandocisnerosruvalc8503]

Such an amazing video. Can we use all the SQL Functions available?

[@srinivaspappu]

Nice one! Can we use the output of a visual or SQL query of a datamart in a visual of PowerBI report ? I do not see the visual / SQL queries that I have written in the datamart are visible in PowerBI desktop once I connect/import in to PBIX in PowerBI desktop. Please suggest. Thanks!

[@satellitepop]

Where did the table Merged goes? Because after you change the visualization it simply disappear, and can't see any save button.

[@RADACAD]

creating views is not yet available in this preview version. It will be available soon

[@trevormay8486]

How does someone who is not the owner of the datamart make changes? Every time I try to bring in another table to a test datamart that a coworker made I get similar errors to: Unable to create an OAuth connection. Reason: "This action cannot be performed by someone other than the dataflow owner.

[@RADACAD]

I believe the write to edit datamarts should be similar to Edit rights on the workspace, which is possible using Contributor, Member and Admin roles. However, similar to dataflows, the ownership of the datamart might be still work-in-progress, and I believe we would see more improvements in that experience in the future

[@trevormay8486]

@@RADACAD That's what I've heard but I gave myself named Admin access to the workspace we have our datamart on and still can't edit it :/

[@goodyearspokane]

I am in a very well paid job and the only person who knows TSQL in the organisation and have been getting worried as we are moving from CRM SQL server database to CRM dataverse and others here can use the PQ GUI. But with PBI datamart can I still use TSQL and lead my company towards that? Is datamart full TSQL functionality? I only need to work for another 5 years

[@RADACAD]

Hi John. You can use T-SQL in the Datamart's database. It supports whatever Azure SQL Database supports.

[@vishalmane3139]

i dont see data mart option

[@adefwebserver]

Excellent presentation. I learned a lot.

[@josejoseph6098]

Great explanation Reza. You make it look simple :-)

[@RADACAD]

Thanks! 🙂

[@mpcoti1]

I'm in Brazil, with PPU license, but I can't see or create a datamart. What do I need to do?

[@RADACAD]

for some azure regions it is not available yet. I believe it would come soon

[@thedavidgzz]

same for mexico, can't see it

[@Milhouse77BS]

Ahh, so bring in Tables into SQL DB is the Extract step, then Queries would be the Transform step. And the SQL is against your SQL DB.

[@RADACAD]

It is amazingly easy and straightforward all in one, isn't it?

[@AccessAnalytic]

Great explanation Reza

[@RADACAD]

Glad you liked it

[@stone6326]

Anyone found this worked for Southeast Asia region..??

[@Alireza-ih5vu]

Perfect