Mars Analytics
Mars Analytics
  • 45
  • 50 257
28 - Fabric Link from Dataverse
You can send the Dataverse from Dataverse into Fabric Lakehouse. Additionally to this exercise I'm also using Dataflows Gen 2 to send the data to an On-Premise SQL Server.
Переглядів: 200

Відео

27 - Cloning a Data Warehouse Table
Переглядів 759 місяців тому
Straight to the point Cloning a DW table using Fabric Synapse features.
26 - Medallion Architecture (Approach 2) - Orchestration
Переглядів 10711 місяців тому
Utilization of Notebooks, Pipelines, and Delta Lakes to implement the Medallion Architecture.
25 - Medallion Architecture (Approach 2) - Dim Tables
Переглядів 13611 місяців тому
Utilization of Notebooks, Pipelines, and Delta Lakes to implement the Medallion Architecture.
24 - Medallion Architecture (Approach 2) - Fact Table
Переглядів 18911 місяців тому
Utilization of Notebooks, Pipelines, and Delta Lakes to implement the Medallion Architecture.
23 - Medallion Architecture (Approach 1) - Pipeline
Переглядів 19911 місяців тому
Orchestration of the medallion approach for delta tables utilizing Fabric Dataflows, Notebooks and Data Factory.
22 - Medallion Architecture (Approach 1) - Notebook
Переглядів 21411 місяців тому
Orchestration of the medallion approach for delta tables utilizing Fabric Dataflows, Notebooks and Data Factory.
21 - Medallion Architecture (Approach 1) - Dataflows
Переглядів 32311 місяців тому
Orchestration of the medallion approach for delta tables utilizing Fabric Dataflows, Notebooks and Data Factory.
20 - Dataflow Templates (Power Query Templates - PQT Files)
Переглядів 432Рік тому
How to create a PQT file and how to reutilize it in order to recreate the same transformations as before.
19 - Fabric Monitoring Hub
Переглядів 299Рік тому
Monitor your pipelines, notebooks, and other data movement tasks.
18 - Creating PBI Report from a KQL Database
Переглядів 146Рік тому
18 - Creating PBI Report from a KQL Database
17 - Creating a Fabric EventStream
Переглядів 294Рік тому
17 - Creating a Fabric EventStream
16 - Creating a Fabric KQL Database
Переглядів 406Рік тому
16 - Creating a Fabric KQL Database
15 - Power BI Developer Mode and Fabric Git Integration
Переглядів 3,2 тис.Рік тому
Deploying Power BI using the developer mode, folders, git, VS Code, etc.
14 - Fabric Git Integration II
Переглядів 1,2 тис.Рік тому
CI/CD deployment integration on the Fabric workspace.
13 - Fabric Git Integration
Переглядів 2,3 тис.Рік тому
13 - Fabric Git Integration
12 - Fabric Data Wrangler
Переглядів 208Рік тому
12 - Fabric Data Wrangler
11 - Fabric Notebooks
Переглядів 189Рік тому
11 - Fabric Notebooks
10 - Using the Fabric File Explorer to change/upload data
Переглядів 113Рік тому
10 - Using the Fabric File Explorer to change/upload data
09 - Fabric Dataflows Gen 2
Переглядів 148Рік тому
09 - Fabric Dataflows Gen 2
08 - Fabric Data Factory Pipelines
Переглядів 174Рік тому
08 - Fabric Data Factory Pipelines
07 - Difference Between Datasets
Переглядів 161Рік тому
07 - Difference Between Datasets
06 - Converting Files into Delta Tables
Переглядів 403Рік тому
06 - Converting Files into Delta Tables
05 - Fabric Lakehouse Creation
Переглядів 159Рік тому
05 - Fabric Lakehouse Creation
04 - Fabric File Explorer
Переглядів 183Рік тому
04 - Fabric File Explorer
03- Creating Fabric Workspaces
Переглядів 231Рік тому
03- Creating Fabric Workspaces
02 - Creating Fabric Domains
Переглядів 344Рік тому
02 - Creating Fabric Domains
01- Enabling Fabric Trial
Переглядів 389Рік тому
01- Enabling Fabric Trial
Deduplicating and Replace in Databricks
Переглядів 3292 роки тому
Deduplicating and Replace in Databricks
Filtering Queries and DFs in Databricks (SQL and Pyspark)
Переглядів 3332 роки тому
Filtering Queries and DFs in Databricks (SQL and Pyspark)

КОМЕНТАРІ

  • @aliceblogspot
    @aliceblogspot 4 місяці тому

    Could you show the part 2 on how to apply the ML model to dataset please? Appreciate!

  • @7777linpaws
    @7777linpaws 8 місяців тому

    If multiple users are working on different features how can they create their own personal/feature branch? It seems that you can only create a new checkout branch at the workspace level.

  • @franciscoanalytics
    @franciscoanalytics 8 місяців тому

    Hi! Great content 👍 Could you please help me understand the reasoning behind creating three separate lakehouses for the different layers, instead of using a single lakehouse with different folders that represent the layers? I'm curious about the advantages and disadvantages of this approach in terms of scalability, performance, and maintenance. Thank you.

  • @graylamb63-km8lk
    @graylamb63-km8lk 9 місяців тому

    Great summary for Power BI Service. Will this work with Report Server?

  • @agustinzapata9007
    @agustinzapata9007 9 місяців тому

    Hi, congratulations on your video this error appeared for me [Open Browser Console for more detailed log - Double click to close this message] Failed to load model class 'ReportModel' from module 'powerbi-jupyter-client' Error: No version of module powerbi-jupyter-client is registered at f.loadClass (localhost:8888/lab/extensions/@jupyter-widgets/jupyterlab-manager/static/134.402424ef4079078b2e0e.js?v=402424ef4079078b2e0e:1:74855) at f.loadModelClass (localhost:8888/lab/extensions/@jupyter-widgets/jupyterlab-manager/static/150.1a6d6a3a0542a41bec5a.js?v=1a6d6a3a0542a41bec5a:1:10729) at f._make_model (localhost:8888/lab/extensions/@jupyter-widgets/jupyterlab-manager/static/150.1a6d6a3a0542a41bec5a.js?v=1a6d6a3a0542a41bec5a:1:7517) at f.new_model (localhost:8888/lab/extensions/@jupyter-widgets/jupyterlab-manager/static/150.1a6d6a3a0542a41bec5a.js?v=1a6d6a3a0542a41bec5a:1:5137) at f.handle_comm_open (localhost:8888/lab/extensions/@jupyter-widgets/jupyterlab-manager/static/150.1a6d6a3a0542a41bec5a.js?v=1a6d6a3a0542a41bec5a:1:3894) at _handleCommOpen (localhost:8888/lab/extensions/@jupyter-widgets/jupyterlab-manager/static/134.402424ef4079078b2e0e.js?v=402424ef4079078b2e0e:1:73392) at v._handleCommOpen (localhost:8888/static/notebook/3676.bundle.js:1:30808) at async v._handleMessage (localhost:8888/static/notebook/3676.bundle.js:1:32702)

  • @wilhelminasihene
    @wilhelminasihene 9 місяців тому

    Thanks, Marcus, this worked for me. ✌

  • @comptegmail273
    @comptegmail273 11 місяців тому

    Hello , do you know if I can deploy this in power BI service

  • @JonleeLockwood
    @JonleeLockwood Рік тому

    Great videos. I have a QQ. Are MS currently recommending that for DEV/TEST workspaces you create a branch and then merge to main for production?

  • @opod84
    @opod84 Рік тому

    Interesting. How would you integrate this with deployment pipelines?

    • @marsanalytics2142
      @marsanalytics2142 Рік тому

      There are still a few unclear things. But you could connect a dev workspace to the git repo and move to prod on the workspace alone OR tie each workspace to a git repo (based on environments).

  • @TheMrFelps
    @TheMrFelps Рік тому

    Parabéns pelo conteúdo

  • @user-of9ku1qw3s
    @user-of9ku1qw3s Рік тому

    Perfect

  • @michaelmebratu2921
    @michaelmebratu2921 Рік тому

    The data has to be cleaned and prepared before using powerBI?

  • @landoftechbuzz3189
    @landoftechbuzz3189 Рік тому

    Hello..How to add grand total to the table and how to sort the table .. please help on this..

  • @divya7555
    @divya7555 2 роки тому

    Hi Marcus,thanks for this video.. 💯 I have one more small requirement along this, I would like to add a grand total also in the email attachment and body of the mail... could you please help here..

  • @SKhan-zp7lc
    @SKhan-zp7lc 2 роки тому

    Man this video is like 144p

  • @AlvinRyellPrada
    @AlvinRyellPrada 2 роки тому

    Omg you made it seem so easy whilst discussing it. Following your steps one by one and it works magic! I only see very few videos of ml powerbi in youtube and i hope you produce more contents:)

  • @gnavarrolema
    @gnavarrolema 2 роки тому

    Great video. Thank you!!!

  • @AlvinRyellPrada
    @AlvinRyellPrada 2 роки тому

    Omg hope more topics like this! I so love it

  • @sherrytang7312
    @sherrytang7312 2 роки тому

    Hi, may I know which kind of Power BI licence is used for this case ? Pro or Premium/user?

  • @guimatheus92
    @guimatheus92 2 роки тому

    How did you open the One Drive with the dashboard in there? Or did you upload the file into One Drive and then published the report from there? The version control feature it's where I'm stuck.

  • @avinashmali3693
    @avinashmali3693 2 роки тому

    Hi, I am getting an error while running flow at SELECT level "The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array. Please give some solution

    • @emmanuell1523
      @emmanuell1523 15 днів тому

      Hello !! Could you fix this problem?

  • @Guiburgueir4
    @Guiburgueir4 2 роки тому

    Amazing demo! I was able to replicate but needed slightly different code (removed finalize_model function as it makes the query stop working). Do you know if it's possible to train the model and modify the dataset in the same Query? Whenever I try any change my Query keeps 'loading' infinitely.

    • @marsanalytics2142
      @marsanalytics2142 2 роки тому

      That's exactly what happens -- almost an infinite loop. As a best practice I would always break them.

  • @sebastiendebosscher
    @sebastiendebosscher 2 роки тому

    To increase the 1000 record limit 🗳Please vote my ideas on both platforms: ideas.powerbi.com/ideas/idea/?ideaid=3932dcbb-5e6d-ec11-b820-0003ff4569ae powerusers.microsoft.com/t5/Power-Automate-Ideas/increase-power-BI-power-automate-visual-limit/idi-p/1404117#M27489

  • @leo_tra
    @leo_tra 2 роки тому

    Nice video The background music is too loud though

  • @slmn9676
    @slmn9676 2 роки тому

    good explanation

  • @shwetasharma5345
    @shwetasharma5345 2 роки тому

    Can you teach Logi Analytics also?

  • @leszekfelczak1926
    @leszekfelczak1926 2 роки тому

    Hi, nice video. In your scenario - there is a Dashboard development in PBI Desktop, so why we need DEV environment? Can we skip DEV and publish straight to TEST and then PROD?

    • @marsanalytics2142
      @marsanalytics2142 2 роки тому

      Yep, you can do that. Honestly, I'd say that these environments need to be adapted to your company's needs. If the need is just a PRE PROD and PROD than I'd say it's fine.