JJ Power BI
JJ Power BI
  • 28
  • 405 707
Access To Over 100+ Open Source Datasets In Power BI
Finding reliable datasets has always been one of the struggles many people facing when learning how to build dashboards in Power BI. In this video, I will show you how to overcome this challenge by connecting to BigQuery public data mart, giving you access to over 100 open-source datasets.
📋Google Cloud Console: console.cloud.google.com
☕ Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------
🔑 PayPal Me: www.paypal.me/jiejenn/5
🔑 Venmo: @Jie-Jenn
📺 Learn Python, Excel, SQL: ua-cam.com/users/JieJenn
💳 Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
💼 Join Robinhood with my link and we'll both get a free stock 🤝 join.robinhood.com/jiej6
📝 Patreon: www.patreon.com/JieJenn
🛒 By shopping on Amazon → amzn.to/2JkGeMD
📧 Business Inquiring: UA-cam@LearnDataAnalysis
#powerbi #pb
Переглядів: 123

Відео

Power BI Tutorial | Remove Data Source Connection
Переглядів 7214 місяці тому
When you set up to a 3rd party data source connection in Power BI, Power BI automatically saves the connection detail so you can re-connect again without re-setting up. But removing an existing data connection in Power BI is not very straightforward. ☕ Buy Me a Coffee? Your support is much appreciated! 🔑 PayPal Me: www.paypal.me/jiejenn/5 🔑 Venmo: @Jie-Jenn 📺 Learn Python, Excel, SQL: ua-cam.co...
Create a Customer Lifetime Value Matrix In Power BI In Less Than 10 Minutes
Переглядів 2,1 тис.5 місяців тому
Customer lifetime value is a crucial stat to keep an eye on when running a customer experience program. It measures how valuable customers are to your company over their entire relationship with you, not just from individual purchases. In this video, I will go through the steps on how to re-create the Customer Life Value Matrix in Power BI. 📃Dataset (clean): drive.google.com/drive/folders/1WPOa...
Create A Competitive Marketing Analysis Power BI Dashboard In Less Than 15 Minutes
Переглядів 1,5 тис.9 місяців тому
Learn how to build a competitive marketing analysis dashboard from scratch in Power BI. 👉 Download resource file: www.buymeacoffee.com/jiejenn/e/237913 ☕ Buy Me a Coffee? Your support is much appreciated! 🔑 PayPal Me: www.paypal.me/jiejenn/5 🔑 Venmo: @Jie-Jenn 📺 Learn Python, Excel, SQL: ua-cam.com/users/JieJenn 💳 Support my channel so I can continue making free contents 💼 Join Robinhood with m...
Add A Modern Page Navigation UI In 5 Minutes In Power BI
Переглядів 3429 місяців тому
In this tutorial, you will learn how to add a modern theme page navigation UI in Power BI. ☕ Buy Me a Coffee? Your support is much appreciated! 🔑 PayPal Me: www.paypal.me/jiejenn/5 🔑 Venmo: @Jie-Jenn 🛒 Shopping on Amazon → amzn.to/2JkGeMD 📧 Business Inquiring: UA-cam@LearnDataAnalysis #powerbi #pb
Make Your Power BI Report More Useful By Highlighting The Top 3 Values
Переглядів 34510 місяців тому
In this tutorial, I'll show you how to enhance your Power BI reports by highlighting the top 3 values. You'll learn simple steps to make your data visualization more impactful, helping users quickly identify key insights. This technique is ideal for anyone looking to make their reports more useful and actionable. J 📁 Resource File: drive.google.com/drive/folders/1KXMopq-bMGMyUj1sr_7AdDAemlKKn0v...
Power BI Tutorial | Retail Store Sales Dashboard For Beginners
Переглядів 7 тис.10 місяців тому
In this tutorial, we are going to build a Retail Sales Dashboard from scratch in Power BI. Whether if you are a beginners or a seasonable Power BI analyst, I hope you will learn a thing or two from this complete Power BI dashboard development tutorial 📋 Resource Files: drive.google.com/drive/folders/1IZawg6iuhDxhCXmcK0OSeivfFnchBgx_?usp=sharing 🛒 If you don't want to do all the works and rather...
Create A Sales Dashboard In Power BI For Beginners | Power BI Tutorial
Переглядів 11 тис.Рік тому
In this video, we will learn how to build a fully functional Sales Dashboard from scratch in Power BI. Whether you're an experienced analyst looking to sharpen your skills or a beginner diving into the world of Power BI data visualization, this is the video for you. By the end of this video, you will have something that you can show off in your Power BI portfolio. 📑 Topics Covered: 1. Import da...
2 Ways To Highlight Top 3 Values In Power BI
Переглядів 6 тис.Рік тому
In this Power BI tutorial, I will share two methods to highlight top 3 values. Method 1 is using the RANKX function, is going to be the simply method. And for method 2, I will be using an analytics function called Window function, which is going to be a little more advanced, but offers more flexibility to enhance your visualization. ☕ Buy Me a Coffee? Your support is much appreciated! 🔑 PayPal ...
Getting Started With Power BI API (Python) For Power BI Users - Delete Multiple Workspaces At Once
Переглядів 10 тис.Рік тому
In this Power BI tutorial, we will learn how to work with the Power BI API. I will go through every single step, from setting up an Azure App, configuring Power BI permissions, and installing Python packages, to writing the Python script. If you're new to the Power BI API, this is a good opportunity to get started. And if you work as a Power BI admin, knowing how to use the Power BI API can rea...
Level Up Your Power BI Dashboard With Collapsible Slicer
Переглядів 3,6 тис.Рік тому
Adding a collapsible filter UI (User Interface) in a Power BI dashboard can provide several benefits to users, report creators, and stakeholders such as improve overall user experience, efficient use of screen real estate, customization and personalization, enhanced interactivity, easier navigation, and more. In this video, we are going to learn how to create this beautiful looking Collapsible ...
Create a Power BI Report With Python Jupyter Notebook For Beginners
Переглядів 26 тис.Рік тому
Power BI recently updated their API library to introduce the ability to create Power BI reports directly in Jupyter notebook. In this tutorial, I will walk you through every single step from install Jupyter notebook all the way to creating a Power BI report. PS: The only prerequisite is you will need to have Python installed first. 📑 Download the Financial Sample dataset: drive.google.com/file/...
Power BI Tutorial: Add GIF Files To Your Power BI Report For Story Telling
Переглядів 4,1 тис.Рік тому
Using GIF files in your Power BI dashboard can help make it visually appealing, engaging, and easier to understand, it is also a great tool for story telling. By default, Power BI doesn't let you insert a GIF image directly, but with a simple workaround, you can achieve this effect. In this video, I will show you two ways to add a GIF image to your Power BI Dashboard. 📷 GIF Library: giphy.com ☕...
How to Cancel Your Power BI Subscription In A Few Easy Step
Переглядів 3,5 тис.Рік тому
If you've decided that Power BI is no longer the right tool for you, this video will show you exactly how to cancel your subscription. 📑 Microsoft Admin Subscription Page: admin.microsoft.com/#/subscriptions ☕ Buy Me a Coffee? Your support is much appreciated! 🔑 PayPal Me: www.paypal.me/jiejenn/5 🔑 Venmo: @Jie-Jenn 📺 Learn Python, Excel, SQL: ua-cam.com/users/JieJenn 💳 Support my channel so I c...
Power BI Tips: Combine Multiple CSV Files In Power BI
Переглядів 13 тис.Рік тому
In this Power BI video, I will share a quick tip on how we can quickly import multiple CSV files combine them into a single data model in Power BI. ☕ Buy Me a Coffee? Your support is much appreciated! 🔑 PayPal Me: www.paypal.me/jiejenn/5 🔑 Venmo: @Jie-Jenn 📺 Learn Python, Excel, SQL: ua-cam.com/users/JieJenn 💳 Support my channel so I can continue making free contents 💼 Join Robinhood with my li...
Create A Netflix Dashboard In Power BI For Beginners (Free Download)
Переглядів 10 тис.Рік тому
Create A Netflix Dashboard In Power BI For Beginners (Free Download)
How To Import Stock Historical Data From Yahoo Finance In Power BI With Python
Переглядів 4,3 тис.Рік тому
How To Import Stock Historical Data From Yahoo Finance In Power BI With Python
Mastering DAX: How to Rank a COUNT output in Power BI
Переглядів 1,2 тис.Рік тому
Mastering DAX: How to Rank a COUNT output in Power BI
Microsoft Power BI Tutorial For Beginners: Data Transformation & Merge Datasets
Переглядів 21 тис.Рік тому
Microsoft Power BI Tutorial For Beginners: Data Transformation & Merge Datasets
How To Delete A Data Connection In Power BI Desktop
Переглядів 15 тис.Рік тому
How To Delete A Data Connection In Power BI Desktop
How To Connect To Google BigQuery In Power BI Desktop
Переглядів 19 тис.Рік тому
How To Connect To Google BigQuery In Power BI Desktop
Automate Dataset Refresh With Power BI API Using Python
Переглядів 20 тис.2 роки тому
Automate Dataset Refresh With Power BI API Using Python
How To Enable "Map and filled map visuals are enabled" Error In Power BI
Переглядів 77 тис.2 роки тому
How To Enable "Map and filled map visuals are enabled" Error In Power BI
Cumulative Count In Power BI
Переглядів 19 тис.2 роки тому
Cumulative Count In Power BI
Getting Started With Power BI API (Set Up, Configuration, Examples)
Переглядів 51 тис.2 роки тому
Getting Started With Power BI API (Set Up, Configuration, Examples)
How To Create Clustered Column Charts In Power BI For Beginners
Переглядів 43 тис.2 роки тому
How To Create Clustered Column Charts In Power BI For Beginners
Getting Started With Using Python In Power BI From a Python Developer
Переглядів 9 тис.2 роки тому
Getting Started With Using Python In Power BI From a Python Developer
How To Connect To Salesforce And Import Salesforce Objects In Power BI
Переглядів 29 тис.2 роки тому
How To Connect To Salesforce And Import Salesforce Objects In Power BI

КОМЕНТАРІ

  • @amilaindika1053
    @amilaindika1053 7 годин тому

    Thank you so much! This is a really helpful tutorial. Very good!! ❤

  • @PhatNguyen-nm4dv
    @PhatNguyen-nm4dv 10 днів тому

    I using a free trial for 60 days. But I can't go to tenaant admin to setting this. How can I enable it.

  • @s.premsagaryadav4489
    @s.premsagaryadav4489 16 днів тому

    Thanks bro it's working

  • @Kalanithi-s2d
    @Kalanithi-s2d Місяць тому

    in a bar chart I get same value for everything. .why is that?

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

    Thanks!!! Finally I managed to solve the error without having to sign out

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

    thanks

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

    This Video Came as first Recommendation. Now I Knw Why! Thank You man

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

    your voice is very relaxing. I liked the tutorial, thanks

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

    I have a table with 2 columns showing Star Rating one each for 2024 and 2025 - I'd like to create a clustered bar chart showing the count of scores for 2024 vs 2025....any help appreciated

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

    Whattan idiotic presentation

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

    Can you please explain, what does the App bearing that <App ID> exactly do?

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

    Awesome brother.. I finished the project Successfully.. Thank you Bro❤️❤️❤️.....

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

    Excellent ..bulls eye

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

    You are a power BI savior, thanks for this awesome fix. You are awesome

  • @IgorOliveira-nh5pc
    @IgorOliveira-nh5pc 3 місяці тому

    can i export the visualization created with a download button?

  • @IgorOliveira-nh5pc
    @IgorOliveira-nh5pc 3 місяці тому

    is there a way to download the data from it?

  • @desislav.pashev
    @desislav.pashev 3 місяці тому

    found it very helpful. thanks!

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

    thank you so much!!!

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

    Thank you bro

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

    Not working for me because POWER BI updates almost every month. It wants me to SIGN UP for a plan. Figures. Its all about MONEY.

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

    spot on what I needed

  • @1ksubscriberswithnovedioch892
    @1ksubscriberswithnovedioch892 4 місяці тому

    you are a life saver bro! subscribed to you

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

    👍👍❤❤

  • @HamzaShah-lm7ec
    @HamzaShah-lm7ec 5 місяців тому

    Thanks

  • @meierthomas
    @meierthomas 5 місяців тому

    Great Tutorial. Is it possible to automatically run the Python script when a user refreshes the report?

  • @MHFCLoveOfMyLife
    @MHFCLoveOfMyLife 5 місяців тому

    Hey, If i don't own pbi pro, and my co worker is creating the app our team use, can i use his app client id and secret with my user, in my code, in order to fetch data from the api? will i'll be able to create access token?

    • @JJPowerBI
      @JJPowerBI 5 місяців тому

      I am not sure. You can give it a try.

  • @MHFCLoveOfMyLife
    @MHFCLoveOfMyLife 5 місяців тому

    Hey :) Thanks for the detailed video!! When trying to register application I get this error: Error when registering application: ERROR: Request returned Forbidden and graph API request id: {id} Do you know what can be the problem? thanks!

    • @JJPowerBI
      @JJPowerBI 5 місяців тому

      This is has to do with permission issue that that you will need to reach out to your admin to grant you permission.

    • @MHFCLoveOfMyLife
      @MHFCLoveOfMyLife 5 місяців тому

      @@JJPowerBI thanks for the answer !

  • @MHFCLoveOfMyLife
    @MHFCLoveOfMyLife 5 місяців тому

    Hey, Can I use the api without pbi pro?

    • @JJPowerBI
      @JJPowerBI 5 місяців тому

      Unfortunately no. Power BI rest API is mostly used to manage power BI online functions.

  • @nietzschebietzsche
    @nietzschebietzsche 6 місяців тому

    Fantastic! I'm working on a dashboard project and I am having to pull down data in Python so I was looking for a tool that will let me make charts that will automatically update when I pull in new data to files. It looks like Power BI is going to be the way to go!

  • @kashififtikhar8122
    @kashififtikhar8122 7 місяців тому

    Thanks

  • @ThomasAlvarez-os5ok
    @ThomasAlvarez-os5ok 7 місяців тому

    I'm having the same issue as the person below. My buttons are not working with the bookmarks when I click the buttons nothing happens.

  • @ricardojosemunozanaya2347
    @ricardojosemunozanaya2347 7 місяців тому

    hello bro, i dont know what happened, "ValueError: Public Client should not possess credentials"

    • @JJPowerBI
      @JJPowerBI 7 місяців тому

      There is a typo somewhere in your code.

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

    If there is transformation in place it means Power BI connector can act like ETL in the same time during the process of data extract? How it maps the fields (are the names the same as it is in the source-Salesforce)?

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

      It uses object field api_name for mapping.

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

    I tried this and got an error. Here is my measure? NC Rank = VAR ncREF_count = COUNT(FARMS_ADHOC_ASSESSMENT[NCREFERENCE]) RETURN CALCULATE( RANKX( VALUES(FARMS_ADHOC_ASSESSMENT[NCREFERENCE]), CALCULATE( COUNT(FARMS_ADHOC_ASSESSMENT[NCREFERENCE] ), ncREF_count, DESC ),ALL(FARMS_ADHOC_ASSESSMENT) ))

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

      What does the error say?

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

      If i filter for eg. by Department it is giving same ranking for all

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

    This is eye opening. I am new to notebook and I am daily getting excited about its capabilities. I have a requirement to use notebook to connect to a remote server with python installed. Basically, users need to access the platform via the jupyter browser page see data in read only format, run their analyses without ever downloading the data or exporting graphical outputs. How can I accomplish this?

  • @ThaoaoPhuong-pr1zp
    @ThaoaoPhuong-pr1zp 8 місяців тому

    Hello, It's such a great video, but I 've got issue when trying to get the token. I copied your code and followed your steps but it returns error ""AADSTS65001: The user or administrator has not consented to use the application with ID'..'" I cannot understand it although I was trying to google it, can you help me please?

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

    Thanks

  • @Dan-bs4dd
    @Dan-bs4dd 8 місяців тому

    Hi! Is it also possible connect reports of Sales Bankline to Power BI? If I want create a report of payments.

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

      Is the report in Salesforce? Or other platform?

    • @Dan-bs4dd
      @Dan-bs4dd 8 місяців тому

      @@JJPowerBI It is in Sales Force, because I join to Salesforce platform with my credentials, but my access allow me join to Sales Bankline, which is as a type of extension of SalesForce, when you can make tracking to payments, but it's in the Salesforce environment.

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

    Thanks, helpful

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

    my admin portal is not like yours so how?? mine only has refresh summary.

    • @anima.4996
      @anima.4996 7 місяців тому

      same here, and there s no any solving TT

    • @PawanAdhikari-kd5qk
      @PawanAdhikari-kd5qk 7 місяців тому

      @@anima.4996 did you guy solve it, I am facing same issue help

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

    hi i need help. -I have like 30 csv files with me all are almost identical in columns , coz they are data from a testing machine. Inorder to summarise data i need to open each file, flter them and get the particular last value from a corresponding cell. how do i automate so that i can collect all CSV files in one folder and when i upliad this folder my data will be filtered and collected into a single file?

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

    Really helped , thanks.

  • @JeroenMulder-xk4go
    @JeroenMulder-xk4go 9 місяців тому

    Exactly what I needed! Thanks a lot

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

    Hello, when I check the reponse to the access token, I see that the scope returned in my access token is 00000002-0000-0000-c000-000000000000, and not the actual scopes defined in the app. Do you have any idea why ? Thanks a lot !!

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

      Hard to tell. But most likely it when you set up the Azure app, one of the option is not set correctly.

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

      @@JJPowerBI Thank you for your response. The username and password you used are admin credentials ? I am trying to connect without using a user credentials...

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

    you save my job . Thank you!

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

      Glad to hear the video helped.

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

    What should you do if the status message does not show syntax errors? Thanks

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

      Go back to the previous step and go from there. To be honest, it is really depends.

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

    Thanks for this video, I was searching for something ike this . I;m able to access the reports but it think there seems to be a lit of 2000 rows when i load data. Have you come across such an issue

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

      Len me look into it. When you say report do you mean SOQL query result or?

  • @paraspadwal.0125
    @paraspadwal.0125 9 місяців тому

    Explanation was on the point, Helped a lot, Great stuff..

  • @A1V1I
    @A1V1I 10 місяців тому

    I have to login for every chart,is there a way that i have to log in only once?

    • @JJPowerBI
      @JJPowerBI 10 місяців тому

      Technically you only need the log once until you reset the session. Hard to tell what's the issue.

  • @Motivation_Station_Neo
    @Motivation_Station_Neo 10 місяців тому

    Great video