Getting Started with Power BI Datamart

In the previous video, you learned what is a Datamart and the use cases of that in a Power BI implementation. In this article and video, you will have your first experience with Datamarts and learn through an example about what it is and how it works in detail. The interesting thing in all the steps below is that you just need a web browser to build the datamart.
learn more from my blog article here:

*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********

#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD

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

[dp]

Thanks for amazing and useful tutorials.

[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?

[nadeemrajabali]

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

[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?

[joelgagnon]

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

[ericbeery]

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

[gabrielcanadeu]

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

[adefwebserver]

Excellent presentation. I learned a lot.

[krishnakishorepeddisetti]

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

[satellitepop]

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

[nasirrizvi]

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

[tolgakaptan]

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

[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!

[MilhouseBS]

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.

[trevormay]

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.

[josejoseph]

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

[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

[oscararmandocisnerosruvalc]

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

[mpcoti]

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