Fernan
Fernan
  • 428
  • 4 940 405
EXTRACT DATA from PDF files into POWER BI or EXCEL using POWER QUERY // Beginners Guide to Power BI
In this video were going to look at how you can extract table data from PDFS into Excel or Power BI. We're also going to look at how you can combine multiple PDF files the easy way.
🕓 TIMESTAMPS
0:00 - Intro
00:45 - Getting data from PDF
03:42 - Combining from multiple PDFs
08:15 - Getting invoice dates
-
📣 Get Demo Files HERE
bit.ly/3dJE2O7
🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.
solutionsabroad.thinkific.com/
📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more
solutionsabroad.co.uk/newsletter
🛒 Power BI TEMPLATES and more at our digital shop
solutionsabroad.co.uk/store
ko-fi.com/solutionsabroad/shop
❤ Other ways to SUPPORT us
www.patreon.com/solutionsabroad
ko-fi.com/solutionsabroad
📧 GET IN TOUCH
Website: solutionsabroad.co.uk/
Email: fernan@solutionsabroad.co.uk
LinkedIn: www.linkedin.com/company/solutionsabroad
Facebook: solutionsabroad
Instagram: solutions_abroad
🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.
🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!
#PowerBI #DataAnalytics #BusinessIntelligence
Переглядів: 472

Відео

How to HIGHLIGHT and FILTER MISMATCHES in your Power BI Reports // Beginners Guide to Power BI
Переглядів 1,6 тис.17 годин тому
In this video were going to look at how you can distinguish mismatches between two sets of data, while also using a measure to provide a filter to choose what to show in your tables. 🕓 TIMESTAMPS 0:00 - Intro 02:50 - Finding Mismatches 04:36 - Adding Colours 08:57 - Adding Slicers - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data? Check out this COURSE to get the essential...
JUNE 2024 POWER BI UPDATE // PBIR format, Visual Calculations, Show Visuals as Tables AND MORE
Переглядів 1,8 тис.22 години тому
In this video were going to look at some of the new updates from the June 2024 Feature Summary. powerbi.microsoft.com/en-us/blog/power-bi-june-2024-feature-summary/#:~:text=Welcome to the June 2024,in Power BI Report Builder. 🕓 TIMESTAMPS 0:00 - Intro 00:42 - Visual calculations 01:29 - PBI Home 01:58 - Large semantic models 02:43 - INFO functions 03:25 - Mobile view 03:59 - PBIR 05:00 - Publis...
GET ORGANISED using FOLDERS in POWER BI // How to use and limitations // Beginners Guide to Power BI
Переглядів 2,1 тис.День тому
LINK: blog.fabric.microsoft.com/en-us/blog/announcing-folder-in-workspace-in-public-preview In this video were going to look at folders and how you can use them to get organised with your Power BI items in the Power BI Service 🕓 TIMESTAMPS 0:00 - Intro 01:15 - Creating folders 03:02 - Publishing into folders 04:48 - Permissions 05:28 - Subfolders 07:04 - Unique report names in workspaces - 📣 Ge...
QUICK LOOK AT NEW LAYOUTS for MATRIX VISUALS in Power BI // Beginners Guide to Power BI
Переглядів 2,5 тис.14 днів тому
In this video were going to look at the new layout options available for the matrix visuals in Power BI Reports. 🕓 TIMESTAMPS 0:00 - Intro 03:22 - Compact 04:59 - Outline 06:48 - Tabular 08:35 - Simple Cashflow - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required. solutionsabroad.thinkific.com...
RECOMMENDED SETTINGS for POWER BI DESKTOP // A Quickstart Guide for First Timers in Power BI
Переглядів 1,1 тис.14 днів тому
In this video were going to look at some of my recommended settings to bear in mind when installing and configuring Power BI Desktop for the first time. 🕓 TIMESTAMPS 0:00 - Intro 00:43 - Downloading the correct way 02:21 - Sign in to Power BI Account 03:36 - Settings to toggle 07:36 - Preview features 08:41 - External tools - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data...
ADD BELL ICON to your Power BI Reports THE EASY WAY // Beginners Guide to Power BI
Переглядів 2,4 тис.21 день тому
In this video were going to look at how to create a notification bell icon for your Power BI Reports LINK to Jasons Solution to Clear Notification - ua-cam.com/video/c3kWGLYMHsc/v-deo.htmlsi=NVftth94WxmAjruH 🕓 TIMESTAMPS 0:00 - Intro 01:15 - Preview 02:30 - Data 02:56 - Setting Up Visuals 11:22 - Setting up Bookmarks - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data? Check...
FIRST LOOK at TASK FLOWS for FABRIC and how to use them in POWER BI // Beginners Guide to Power BI
Переглядів 2 тис.21 день тому
LINK: learn.microsoft.com/en-us/fabric/get-started/task-flow-overview In this video were going to look at this new task flow feature in the Power BI Service and how you can utilise them to design your data architectures in Fabric. 🕓 TIMESTAMPS 0:00 - Intro 02:03 - Creating from Scratch 06:58 - Pre-created Task Flows 08:40 - My recommendations - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to ...
Preview PBIX Files in SharePoint and OneDrive for Business // Basic Usage and Limitations
Переглядів 80428 днів тому
LINK: learn.microsoft.com/en-us/power-bi/collaborate-share/service-sharepoint-viewer In this video were going to look at this new feature that lets you preview PBIX files directly in SharePoint and OneDrive for Business. 🕓 TIMESTAMPS 0:00 - Intro 01:32 - Preview 01:55 - Enabling Feature 02:19 - Feature rundown 05:56 - PBIX only 06:22 - 1GB file preview limit 06:54 - File access 07:04 - Power BI...
MAY 2024 POWER BI UPDATE // Preview PBI files in SharePoint, Copilot Updates AND MORE
Переглядів 3,9 тис.Місяць тому
LINK: powerbi.microsoft.com/en-us/blog/power-bi-may-2024-feature-summary/#post-27048-_Toc167109006 In this video were going to look at some of the new features from the May 2024 update. 🕓 TIMESTAMPS 0:00 - Intro 00:41 - Modern Tooltips 01:24 - New Matrix Layout 02:07 - On object interaction updates 02:35 - Pane manager 02:55 - Publish to folders 03:38 - Ask questions to Copilot 04:12 - DAX Quer...
HOW TO JOIN DATA // How to use SEMI JOINS // Beginners Guide to using MERGE and RELATIONSHIPS
Переглядів 1,3 тис.Місяць тому
In this video were going to look at how to join your data in Power BI. 🕓 TIMESTAMPS 0:00 - Intro 03:38 - Merge Queries 08:59 - Semi Joins 11:34 - Fuzzy Joins 14:18 - Relationships 16:17 - Multiple relationships - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required. solutionsabroad.thinkific.com...
How to use URLs and HYPERLINKS in Power BI // Dynamic URLs, Mailto AND MORE
Переглядів 1,8 тис.Місяць тому
In this video were going to look the different visuals you can add hyperlinks to, and the different ways you can utilise them. 🕓 TIMESTAMPS 0:00 - Intro 01:44 - Basic Setup 05:02 - Dynamic URLs 06:51 - Buttons 09:06 - Shapes & Images 09:39 - Textbox 10:51 - Mailto - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need....
IMPORT IMAGES into POWER BI // DIFFERENT WAYS to Import and Use Images in Power BI Reports
Переглядів 3 тис.Місяць тому
In this video were going to look at a couple different ways you can import and use images into your Power BI Reports. 🕓 TIMESTAMPS 0:00 - Intro 01:08 - Basic Import 02:25 - Using Web Images 05:50 - Using Binary Images 12:45 - SVG Images - 📣 Get Demo Files HERE bit.ly/3dJE2O7 🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required. sol...
AUTO REFRESH POWER BI VISUALS FOR BIG SCREENS! A Step by Step Guide + Limitations and Considerations
Переглядів 1,6 тис.Місяць тому
In this video were going to look at how to set up the auto visual refresh feature in storytelling for PowerPoint add in. We'll look at how it works and some of its limitations to bear in mind. 🕓 TIMESTAMPS 0:00 - Intro 03:08 - Setting up report 05:34 - Setting up Power Point 09:02 - Re-embed required 10:55 - Auto refresh on slideshow mode only 11:52 - Limit up to 15 seconds - 📣 Get Demo Files H...
POWER QUERY GET DATA IN REPORT BUILDER! Paginated Reports Experience, Limitations and Considerations
Переглядів 1,6 тис.Місяць тому
In this video were going to look at the new Get Data experience in Report Builder, which improves the way you clean and transform your data when creating Paginated Reports. Link to Blog Post: powerbi.microsoft.com/en-us/blog/get-data-with-power-query-available-in-power-bi-report-builder-preview/ 🕓 TIMESTAMPS 0:00 - Intro 00:39 - Overview 04:00 - Get Start with Get Data 09:01 - Only last query l...
ENHANCED RLS EDITOR // Basic Setup, Dynamic RLS AND MORE // Beginners Guide to Power BI
Переглядів 2,5 тис.2 місяці тому
ENHANCED RLS EDITOR // Basic Setup, Dynamic RLS AND MORE // Beginners Guide to Power BI
NEW LINE ENHANCEMENTS & 100% STACKED AREA CHART In Power BI Desktop // What's New?
Переглядів 1,2 тис.2 місяці тому
NEW LINE ENHANCEMENTS & 100% STACKED AREA CHART In Power BI Desktop // What's New?
SCAN BARCODES to FILTER POWER BI REPORTS? A Step by Step Guide from Scratch
Переглядів 1,5 тис.2 місяці тому
SCAN BARCODES to FILTER POWER BI REPORTS? A Step by Step Guide from Scratch
APRIL 2024 POWER BI UPDATE // 100% Stacked Area Chart, Auto Refreshing PowerPoint AND MORE
Переглядів 3 тис.2 місяці тому
APRIL 2024 POWER BI UPDATE // 100% Stacked Area Chart, Auto Refreshing PowerPoint AND MORE
QUICK INTRO to M QUERY in POWER BI and EXCEL // Beginners Guide to Power BI in 2024
Переглядів 1,4 тис.2 місяці тому
QUICK INTRO to M QUERY in POWER BI and EXCEL // Beginners Guide to Power BI in 2024
PERFECTLY ALIGNED VISUALS in Power BI // Different Ways to Align // Beginners Guide to Power BI
Переглядів 2,1 тис.2 місяці тому
PERFECTLY ALIGNED VISUALS in Power BI // Different Ways to Align // Beginners Guide to Power BI
REST APIs with PAGINATION OR TOKENS with POWER BI Reports // Beginners Guide to Power BI in 2024
Переглядів 3,9 тис.2 місяці тому
REST APIs with PAGINATION OR TOKENS with POWER BI Reports // Beginners Guide to Power BI in 2024
MOBILE LAYOUT VIEW for MOBILE OPTIMIZED EXPERIENCE // Beginners Guide to Power BI in 2024
Переглядів 1,6 тис.2 місяці тому
MOBILE LAYOUT VIEW for MOBILE OPTIMIZED EXPERIENCE // Beginners Guide to Power BI in 2024
QUICK GUIDE TO POWER BI FILE FORMATS // PBIX, PBIT, PBIDS, PBIP, PBIR, PBIDS, TMSL, TMDL
Переглядів 2,4 тис.2 місяці тому
QUICK GUIDE TO POWER BI FILE FORMATS // PBIX, PBIT, PBIDS, PBIP, PBIR, PBIDS, TMSL, TMDL
MARCH 2024 POWER BI UPDATE // Mobile Auto Create, DAX Query View with Copilot AND MORE
Переглядів 3 тис.3 місяці тому
MARCH 2024 POWER BI UPDATE // Mobile Auto Create, DAX Query View with Copilot AND MORE
Introduction to TMDL (Tabular Model Definition Language) // What is it? TMSL vs TMDL // Quick Guide
Переглядів 2,2 тис.3 місяці тому
Introduction to TMDL (Tabular Model Definition Language) // What is it? TMSL vs TMDL // Quick Guide
VISUAL CALCULATION TEMPLATE FUNCTIONS // How to use these built-in templates in Power BI
Переглядів 1,2 тис.3 місяці тому
VISUAL CALCULATION TEMPLATE FUNCTIONS // How to use these built-in templates in Power BI
QUICKLY EXPLORE your SEMANTIC MODELS in Power BI Service using the EXPLORE Feature
Переглядів 2,8 тис.3 місяці тому
QUICKLY EXPLORE your SEMANTIC MODELS in Power BI Service using the EXPLORE Feature
NATIVE OVERLAPPING BARS in POWER BI // IBCS Style Variance Bar Chart Step by Step Guide
Переглядів 4 тис.3 місяці тому
NATIVE OVERLAPPING BARS in POWER BI // IBCS Style Variance Bar Chart Step by Step Guide
VISUAL CALCULATIONS for EASY DAX // Basic Usage, Limitations AND MORE // Beginners Guide to Power BI
Переглядів 3 тис.3 місяці тому
VISUAL CALCULATIONS for EASY DAX // Basic Usage, Limitations AND MORE // Beginners Guide to Power BI

КОМЕНТАРІ

  • @SKCourier
    @SKCourier 11 годин тому

    I have pdf but sometimes it has 4 columns and sometimes 5 times hence it is not importing properly. I have to manually adjust column. I have around 1000 pdfs

  • @ChanakyaPola
    @ChanakyaPola 13 годин тому

    Is there a way we could default the axes to months instead of days?

  • @boycool123456789
    @boycool123456789 22 години тому

    I am trying to search Azure Active directory in marketplace, but I am not able to find it, can you please help me?

  • @RenitaDsilva-b9e
    @RenitaDsilva-b9e 23 години тому

    I want to be able to export data from my PowerBi to Google sheets directly without having to save in excel and then paste in Google sheets. Can you share a process that would help in automating this and if you could share it on your channel it would be helpful.

  • @garudabowo
    @garudabowo День тому

    what if you already break the links, can you still fix it manually in order to make it link again for future purpose?

  • @garudabowo
    @garudabowo День тому

    Surprisingly good. I use power BI and learn more from here in an instant tube. Good job man

  • @tbot5709
    @tbot5709 День тому

    Disappointing, learn nothing...expecting something like power automate taking PBI data into excel at certain interval...

  • @victorlfc
    @victorlfc День тому

    Really insightful. At first I thought creating calculated column with the corresponding values for greater, less or equal. But this solution is much better for memory and speed. Thanks!

  • @mart1484
    @mart1484 2 дні тому

    7:50 ALL SELECTED

  • @utkarshrajput5871
    @utkarshrajput5871 3 дні тому

    But this does not work in power bi online version

  • @nonoobott8602
    @nonoobott8602 4 дні тому

    This is so brilliant. I've learned so much watching your videos. Thanks for sharing

  • @user-hy5qu1en8p
    @user-hy5qu1en8p 4 дні тому

    Thanks farnan

  • @simaomuhongo_mostech361
    @simaomuhongo_mostech361 4 дні тому

    Thanks , very clearly and insightful. Keep going on this

  • @jeremrndn
    @jeremrndn 5 днів тому

    Thanks a lot for this video! Now, what if you want to dynamically create this TOP N, but adding a condition "Total Orders > 100" for example? On my side, using the Visual level filter does not work, the TOP N is not dynamic, ending with 3 products instead of TOP5.

  • @widodomurnoto5440
    @widodomurnoto5440 5 днів тому

    Thank you Fernan, you solved my problem

  • @TheJaebeomPark
    @TheJaebeomPark 5 днів тому

    you are so good!

  • @travelkare
    @travelkare 5 днів тому

    Hi Fernan, You explained everything but it would be better if you would have added detailed difference between all ?

  • @travelkare
    @travelkare 5 днів тому

    Hi Fernan, I wish you have told more about github (Forkes & Branches )

  • @kuuuyajim
    @kuuuyajim 5 днів тому

    How do we "unbold" the row headers in a tabular view? I've been trying to figure out where to change this in the settings but I can't find where. 😢

  • @Littlepeanut9
    @Littlepeanut9 5 днів тому

    I think you should have put this video somewhere in the beginning . It would have been easier to pay attention on what you are doing in the rest of the videos.

  • @Caersaz
    @Caersaz 5 днів тому

    Hi. Great content! A question: how to connect to a folder instead in OneDriver personal? Like for list the existing files and choose which one to use?

  • @zeeshansami8268
    @zeeshansami8268 6 днів тому

    I m using spark line in Matrix visual. Showing sales for last 10 months. The trend line is not showing the correct months in order. How can we sort the month in spark lines. Appreciate your response.

  • @pgkannan
    @pgkannan 6 днів тому

    Thank for sharing 😊

  • @arbazahmad7177
    @arbazahmad7177 6 днів тому

    Excellent 🎉..thanks for sharing...

  • @reanalytics1863
    @reanalytics1863 6 днів тому

    Hi Fernan I have this measure that returns text such as 50/12% BAC+ = IF([# BAC+]>0, FORMAT([# BAC+],"0") & "/" & FORMAT([% BAC+],"0%"),"") I want to conditionally format this measure using the following measure Met Bac+ target = IF( [bac+ target]<1, "", IF( [% BAC+] < [bac+ target] * [lower bound], "#FF4136", -- Target Not Met IF( [% BAC+] < [bac+ target]*[middle bound], "#FF8F00", -- Close to Target "#2E7D32" -- Target Met ) ) ) however, Power BI does format the text values, what am I doing wrong in this case? Thank you for all your education

  • @erinfield1943
    @erinfield1943 6 днів тому

    6:04- OMG this has happened to me!

  • @syedghousebasha5402
    @syedghousebasha5402 6 днів тому

    Hi, Embed option not available in my onedrive file.. Can u help

  • @kel78v2
    @kel78v2 6 днів тому

    Backward comparison with SAMEPERIODLASTYEAR works just fine. What I've noticed is when you're looking at YTD vs last year. For example 2024 YTD would show you the totals up to June 2024 BUT SAMEPERIODLASTYEAR will show the 12 months total for 2023 instead of Jan to June 2023?

  • @sergeypautov8086
    @sergeypautov8086 7 днів тому

    Феноменально! You are great brainMAN!

  • @matusjakubcin2765
    @matusjakubcin2765 7 днів тому

    Hello , thanks for video :) Could i ask you which version of Power BI you are using ? i mean in Data labels part you have extra options like : Title , Detail , Layout , which is later used. I have version October 2023 but do not have such option. Or is there any way , how can i change difference shown in percentage , only with options i have ( options , values , background ) . Thanks

  • @mneama4383
    @mneama4383 7 днів тому

    Bravooo bro , may i have your email , i have couple of questions if u can help me with

  • @enocharthur4322
    @enocharthur4322 8 днів тому

    I'm here first🎉🎉🎉🎉

  • @PGJAS
    @PGJAS 8 днів тому

    Hi, sync slicer option and copy, paste and sync both will have same functionality and it is just different ways for synchronizing right? Or is there any advantage of using 'copy, paste and sync' over sync slicer?

  • @JubranZakri
    @JubranZakri 9 днів тому

    Cant thank you enough

  • @lalitsoni3596
    @lalitsoni3596 10 днів тому

    sir will share to ppt also show web visual? i have dashboards with Map visuals when i embedded them into web it does not show visuals to users , is there any other way to show full dashboard with maps and all to users outside the organization ?

  • @sugiplanner
    @sugiplanner 10 днів тому

    Why my workplace doesn't enable menu for schedule refresh?

  • @TrangLuong-f1o
    @TrangLuong-f1o 10 днів тому

    Thank you so much!

  • @jenkinsade2111
    @jenkinsade2111 10 днів тому

    Amazing

  • @danelemon5959
    @danelemon5959 10 днів тому

    Thanks. Your showing the way these functions work helped me accomplish something at my job, etc..

  • @ngontran
    @ngontran 10 днів тому

    Great tutorial 👍

  • @erinfield1943
    @erinfield1943 10 днів тому

    ooh! Let me just go buy a house in Kingston upon Thames. Nice research.

  • @qaisurrehman
    @qaisurrehman 10 днів тому

    very useful, thank you Fernan!

  • @hsspsri
    @hsspsri 11 днів тому

    Thanks

  • @supriyakarkera4647
    @supriyakarkera4647 11 днів тому

    Hi Fernan, really a great video. I have followed al steps from the video with a 10 page Powerbi report. However; my end user can't see the page slicer to select the pages. Can you please guide what could be the issue?

  • @videojonkie
    @videojonkie 11 днів тому

    Thanks for the PBI videos, very helpful

  • @utubebellamkonda
    @utubebellamkonda 11 днів тому

    Adding multiple refresh dataset actions is not optimal if you have more than handful datasets. Can we get items from sharepoint list and loop through?

  • @sopauljauck4163
    @sopauljauck4163 11 днів тому

    Hi Fernan. Having the most difficult time creating a line graph that compares multiple previous periods; by that I mean, it goes beyond a single previous period. If the user wants to select "range =3", then the graph will display 3 years previous periods with 3 lines. Do you have a video that shows how to do this? I'm searching everywhere. I feel like I'm close but I just cannot get to the solution.

  • @tanakornpromthep9025
    @tanakornpromthep9025 12 днів тому

    Thank you ❤

  • @PSchwem
    @PSchwem 12 днів тому

    Exactly what I needed - thanks!

  • @sooryaprakashverma6044
    @sooryaprakashverma6044 12 днів тому

    I am calculating the previous month sales and difference comparing with current and previous month but I get blank values in the column. How it is possible? This previousmonth function is not working for me.