Intro to R with Power BI

Поділитися
Вставка
  • Опубліковано 1 сер 2024
  • You enjoyed the intro to Python video, now let's look at R Script within Power BI! There are a lot of similar aspects and Patrick walks you though what you should know to get started.
    📢 Become a member: guyinacu.be/membership
    *******************
    Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
    🎓 Guy in a Cube courses: guyinacu.be/courses
    *******************
    LET'S CONNECT!
    *******************
    -- / guyinacube
    -- / awsaxton
    -- / patrickdba
    -- / guyinacube
    -- / guyinacube
    -- guyinacube.com
    **Gear**
    🛠 Check out my Tools page - guyinacube.com/tools/
    #PowerBI #RScript #GuyInACube
  • Наука та технологія

КОМЕНТАРІ • 52

  • @lawrencemaoka
    @lawrencemaoka Рік тому +3

    Having watched your video, I have gained a lot of clarity about the topic. Thanks for the video, Patrick.

  • @huqsami
    @huqsami Рік тому +3

    Great video Patrick as usual, would love to see some more videos on where you could demonstrate what powerbi alone can not do but can achieve with the leverage of r script!

  • @KoldFiyure
    @KoldFiyure 3 роки тому +1

    This is exactly what I needed. Thanks.

  • @terrencerussell1999
    @terrencerussell1999 3 роки тому +1

    Solid walkthrough

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

    Great intro! Thanks!

  • @chubsmash7602
    @chubsmash7602 3 роки тому

    This is amazing!!! Thanks

  • @garrettfermo4407
    @garrettfermo4407 3 роки тому

    Seriously Amazing!!!!!

  • @Ferruccio_Guicciardi
    @Ferruccio_Guicciardi Рік тому +1

    Thanks for sharing . Very handy.

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

      Glad it was helpful. Thanks for watching! 👊

  • @ravimishra12
    @ravimishra12 3 роки тому +1

    Awesome 👍

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

    Thanks Mr. Guy in a Cube

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

    Great video!

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

    cool stuff, thanks for sharing :)

  • @koutlaw30
    @koutlaw30 3 роки тому

    I think I came up with the idea for the video first...LOL Thanks for the video!!!!

  • @praveenpatil282
    @praveenpatil282 3 роки тому +1

    This is great. Great things are so simple. Have you successfully connected to XMLA endpoint dataset using Python script. I’ve a premium account and was trying to connect, unsuccessful so far. Please help with tips. Thx!

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

    Thanks for the video! Have you noticed that the aspect of the plot changes as soon as you apply the filter? It's like increasing the size of the graphic device (speaking the R language). I would like to avoid that.

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

    Can you use R pr Python in Power Bi to create a timeline queryon visualization?

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

    Is it possible to have r script on on-pemise gateway? - using dataflow to gather data but would be useful not to have to resort to personal gateway for a report using R

  • @balaji_906
    @balaji_906 3 роки тому

    Pitfall is on "Don't Summarize". Thanks for mentioning

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

    Hi, I got a big problem as POwer BI doesn't appear dataset automatically when I choose "variable" ? How to solve it ? Thanks

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

    Thanks for the update, but can one use the tidyverse package in PowerBi via the R scripting?
    I tried it but power bi didn't recognize it.
    Also, does Power Bi support any R version?

  • @fernalication
    @fernalication 3 роки тому +29

    If this video reaches 10 likes, Microsoft will enable refreshes throughout the enterprise gateway

    • @HDREconomist
      @HDREconomist 3 роки тому +2

      Seriously, I don't know why for Enterprise Deployments, there is not a clean way (even if it required premium capacity) to assign a Microsoft R Server in Azure to your Power BI Capacity so that you could refresh in service without a personal gateway, even if it were for a specific subsection of R Libraries.

    • @ryanwade865
      @ryanwade865 3 роки тому +1

      It would be nice to know if that feature is being considered. If it is not it would be nice to know why.

    • @matthiask4602
      @matthiask4602 3 роки тому +4

      Personal Gateway is really a show stopper. Same for python

  • @hadyshaaban1221
    @hadyshaaban1221 3 роки тому +20

    Please tell Microsoft that we need to schedule refresh dashboards that contain R scripts 🙏🙏🙏🙏

  • @zeeshan5k
    @zeeshan5k 3 роки тому

    Can you deploy this visual to powerbi server on premises?

  • @kiasca3489
    @kiasca3489 Місяць тому

    so throughout the web it recognize that data set, so all data set forcedly have a to have a unique name?

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

    Thanks, that was sample.

  • @user-ze4xc6tu4f
    @user-ze4xc6tu4f 3 роки тому

    Bang!

  • @TheSurajitgupta
    @TheSurajitgupta 3 роки тому

    I have a dynamic path stored in a column of a table. I am trying to pass this to a variable in R. It is saying the object not found! path

  • @SDrent-eh4ct
    @SDrent-eh4ct 6 місяців тому

    How te create a button that activates a R process??

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

    How does Power BI know where to take the data from?

  • @krazyboy1968
    @krazyboy1968 2 роки тому +9

    The limits on R integration within power bi makes it essentially useless. You are better off designing a shiny app. Power BI is pretty weak in it's ability to leverage the top two transformation tools (python/r).

    • @Svykle
      @Svykle 6 місяців тому +1

      Agreed. I think it’s worth learning R and much more powerful than powerbi. I hate how you have to Pay to export images from powerbi to like a PowerPoint….that’s annoying.

  • @davidcousins8407
    @davidcousins8407 3 роки тому

    Looks like the snake charmers have beaten the pirates for viewcount!

  • @chaoweizhong8350
    @chaoweizhong8350 3 роки тому

    Always thumb up first and then watch..

  • @ferorozco7547
    @ferorozco7547 3 роки тому

    I choose data analytics and reporting tools because I want to avoid the coding of phyton/R/Java.. now microsoft are combining both.. please shot me 🙂

    • @manutexas
      @manutexas 3 роки тому +2

      lol no. Learn to program. Data Analytics without programming is like eating a peanut butter and jelly sandwich without the bread.

    • @ferorozco7547
      @ferorozco7547 3 роки тому

      @@manutexas I know how to coding... I just don´t like it.

  • @durgamshashidhar4736
    @durgamshashidhar4736 3 роки тому

    Yoooooooo

  • @khatmanworld
    @khatmanworld 2 місяці тому

    Likable guy this one...no diddy

  • @PortalgestaoPT
    @PortalgestaoPT 3 роки тому +1

    R and Python scripts should run directly from data flows, not from Power BI Desktop/Pesonal Data Gateway.

  • @RetrofitIam
    @RetrofitIam 20 днів тому

    Jeeze, slow the eff down….lol

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

    I will probably never use this.

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

      Tbh, the limitations Microsoft have imposed on using R is bullshit. You're better off using R with SQL server and then pushing that data to power BI. That way you have no limitations and can use R with SQL to the full potential.