BI-Lingual Analytics
BI-Lingual Analytics
  • Видео 159
  • Просмотров 528 948
Fixing Power Query CSV Import Issues - No More Missing Columns in Power BI!
In today’s tutorial, we’re tackling a common yet frustrating issue in Power BI: missing columns when importing CSV files in Power Query.
In this video, I'll guide you through understanding why this issue occurs and provide two effective solutions to resolve it. We’ll start by examining a CSV file in Excel, where everything seems fine. But once imported into Power Query, only 6 columns appear.
Why?
It’s all about the delimiter and encoding settings.
Solution 1: Using the GUI of Power Query, we’ll change the delimiter type and manually split the columns. This involves switching the delimiter to a custom character and then transforming the data to ensure all columns are correctly imported.
Solu...
Просмотров: 391

Видео

Automate Last Day Slicer in Power BI - Easy Field Parameters Tutorial
Просмотров 52521 день назад
🧐 Create A Latest Day Slicer in Power BI In this tutorial, I'll show you how to create a default slicer selection for the latest day in Power BI using Field Parameters. This is perfect for daily invoicing summaries or reports on job statuses. If you're tired of manually updating slicers or filters every time new data comes in, this video is for you! We'll explore a solution that keeps everythin...
Expression-based Titles in Power BI and How To Fix the Interaction on Visual Elements
Просмотров 270Месяц назад
🤷‍♂️ So you found yourself in a situation where those great dynamic titles are not updating according to the selection made on a visual in Power BI? You have already checked your DAX measure (maybe more than once) and it seems to work fine... So what could possibly cause the issue? Well, there is a known limitation on visual interaction in Power BI. Namely, the visual on which a selection was m...
No More Manual Date Changes in Power BI! | Learn How to Create Dyanmic Timeframe Information
Просмотров 806Месяц назад
🛑 Stop Updating Dates Manually in Power BI! Are you tired of manually updating dates in your Power BI reports? In this video, I'll show you how to automate the process, ensuring that the latest refresh date or transaction date is always highlighted without any manual intervention. Keeping your Power BI reports up-to-date with the latest data is crucial, but manually updating date text boxes can...
Elevate Your Data Visualisation in Power BI with Scientific Design Techniques
Просмотров 7764 месяца назад
Welcome to a game-changing journey in the realm of Business Intelligence! 🚀 In this video, we're diving deep into the art and science of adjusting Power BI report designs. 📊💻 🔍 Ever wondered how to take your BI reports to the next level? Get ready to discover the secrets of infusing scientific information into your designs, creating reports that not only look visually stunning but also deliver ...
Fully Automated Power BI Access Management Tool using Power Apps and Power Automate - Part III
Просмотров 1,1 тыс.4 месяца назад
In today's video, we're diving into the world of Power BI access management. If you've ever struggled with the manual hassles of setting up and managing access to your Power BI workspace, data models, reports, or apps, you're in the right place. In this tutorial, I'll walk you through an ingenious solution I've developed - a Fully Automated Power BI Access Management Tool using Power Apps and P...
Data-Driven Data Visualization in Power BI - How to Use Science to Create More Impactful DataViz
Просмотров 5265 месяцев назад
In this tutorial, we're diving into the exciting world of data visualization using Power BI and the incredible 3M Visual Attention Software (3M VAS). 📊💡 Have you ever wondered how to make your data truly stand out? Well, you're in the right place! In this intro video, we will explore the game-changing 3M VAS tool 🚀 Discover how this software can elevate your visualizations by directing attentio...
Fully Automated Power BI Access Management Tool using Power Apps and Power Automate - Part II
Просмотров 1,3 тыс.5 месяцев назад
In today's video, we're diving into the world of Power BI access management. If you've ever struggled with the manual hassles of setting up and managing access to your Power BI workspace, data models, reports, or apps, you're in the right place. In this tutorial, I'll walk you through an ingenious solution I've developed - a Fully Automated Power BI Access Management Tool using Power Apps and P...
Fully Automated Power BI Access Management Tool using Power Apps and Power Automate - Part I
Просмотров 1,7 тыс.5 месяцев назад
In today's video, we're diving into the world of Power BI access management. If you've ever struggled with the manual hassles of setting up and managing access to your Power BI workspace, data models, reports, or apps, you're in the right place. In this tutorial, I'll walk you through an ingenious solution I've developed - a Fully Automated Power BI Access Management Tool using Power Apps and P...
How To Swap REST API Bearer Token in Power Query To Allow Easy Data Refresh in Power BI
Просмотров 6 тыс.8 месяцев назад
How To Swap REST API Bearer Token in Power Query To Allow Easy Data Refresh in Power BI
Power BI REST API - Import and Format JSON Response with Power Query
Просмотров 4,9 тыс.8 месяцев назад
Power BI REST API - Import and Format JSON Response with Power Query
Power BI REST API - How To Get Started And What To Expect as a Non-Technical User
Просмотров 10 тыс.9 месяцев назад
Power BI REST API - How To Get Started And What To Expect as a Non-Technical User
Historical Data Validator Report - Automated Power BI Dataset Snapshots
Просмотров 3,8 тыс.9 месяцев назад
Historical Data Validator Report - Automated Power BI Dataset Snapshots
How To Automate Power BI Dataset Snapshots - Run a Query Against a Dataset
Просмотров 9 тыс.10 месяцев назад
How To Automate Power BI Dataset Snapshots - Run a Query Against a Dataset
How To Create a Guided Tour Layer in Power BI - UI/UX Trick
Просмотров 1,4 тыс.10 месяцев назад
How To Create a Guided Tour Layer in Power BI - UI/UX Trick
How To Pick-Up Cell Value Using Power Query - Power BI & Excel Trick
Просмотров 7 тыс.11 месяцев назад
How To Pick-Up Cell Value Using Power Query - Power BI & Excel Trick
Power BI Data Visualization Project - Push-Up Challenge 2023
Просмотров 322Год назад
Power BI Data Visualization Project - Push-Up Challenge 2023
Power BI Meets Forms | A Fully Automated Method Using Power Automate And SharePoint
Просмотров 5 тыс.Год назад
Power BI Meets Forms | A Fully Automated Method Using Power Automate And SharePoint
Heatmap Visual in Power BI - Part III | Dynamic Heatmap Legend with Calculation Groups
Просмотров 1,1 тыс.Год назад
Heatmap Visual in Power BI - Part III | Dynamic Heatmap Legend with Calculation Groups
How To Use Include in Report Refresh in Power Query | Power BI Data Settings
Просмотров 1,5 тыс.Год назад
How To Use Include in Report Refresh in Power Query | Power BI Data Settings
Australian Aviation DataViz - Power BI Data Visualization Example
Просмотров 618Год назад
Australian Aviation DataViz - Power BI Data Visualization Example
How To Import Latest File From A Folder Using Power Query - Power BI Trick
Просмотров 12 тыс.Год назад
How To Import Latest File From A Folder Using Power Query - Power BI Trick
How To Use Power BI Row Level Security To Help Users Focus on What Is Critical
Просмотров 431Год назад
How To Use Power BI Row Level Security To Help Users Focus on What Is Critical
Heatmap Visual in Power BI - Part II | Beautify A Business Dashboard
Просмотров 1,1 тыс.Год назад
Heatmap Visual in Power BI - Part II | Beautify A Business Dashboard
Heatmap Visual in Power BI - Part I | Replicate "Busyness Chart" for a Post Office
Просмотров 7 тыс.Год назад
Heatmap Visual in Power BI - Part I | Replicate "Busyness Chart" for a Post Office
TOP 5 Power Automate Features For Power BI Developers And Users
Просмотров 8 тыс.Год назад
TOP 5 Power Automate Features For Power BI Developers And Users
Power BI Web Scraping With Power Automate Alerts | How To Buy A 40 Series GPU Without Coding
Просмотров 1,3 тыс.Год назад
Power BI Web Scraping With Power Automate Alerts | How To Buy A 40 Series GPU Without Coding
Super Flexible Calendar in Power BI Based On M Code | Parameterised Date Table
Просмотров 709Год назад
Super Flexible Calendar in Power BI Based On M Code | Parameterised Date Table
Create An Approved Calendar Table in Power BI DataFlow | Special and Financial Calendars
Просмотров 1,9 тыс.Год назад
Create An Approved Calendar Table in Power BI DataFlow | Special and Financial Calendars
How To Collaborate Or Co-Author Power BI Dataflows | Learn To Share Dataflows
Просмотров 1,5 тыс.Год назад
How To Collaborate Or Co-Author Power BI Dataflows | Learn To Share Dataflows

Комментарии

  • @arditsubashi206
    @arditsubashi206 День назад

    have been searching for this 6 months now.... a big thanks

  • @KoraySuleyman
    @KoraySuleyman 5 дней назад

    1:03 o site Avanco social é perfeito para comprar seguidores para instagram e tiktok

  • @ArzuRemziye
    @ArzuRemziye 5 дней назад

    Adquira 10 mil seguidores no Avanco Social. obrigado avanco social

  • @CemalEmre-sx1qu
    @CemalEmre-sx1qu 5 дней назад

    Comprar seguidores no Avanco Social é muito melhor. obg avanco social

  • @learntech5183
    @learntech5183 5 дней назад

    Thanks,but I have a question,what if I had to show dates in descending order in the timeframe parameterized table? can we do that?

  • @ExcelWithChris
    @ExcelWithChris 8 дней назад

    Thanks from South Africa.

  • @BILingualAnalytics
    @BILingualAnalytics 11 дней назад

    Were you aware of these solutions? Do you have an alternative solution to the same problem? Let us know here 👇

  • @natalialopez1697
    @natalialopez1697 16 дней назад

    hello, great video, could you please share the query you paste when adding the Blank query, thank you!!

  • @ssomtom
    @ssomtom 16 дней назад

    Szia. Van arra szerinted metódus, hogyha elkezdünk az O365 ökosztisztémákban ilyenekt csinálni, akkor valahogy ezt le is tudjuk kérdezni? Vagyis van egy reportid egy riporthoz és mondja meg, hogy milyen flow-k kapcsolódnak hozzá? Pl. hasznos lehetne munkavállalók mozgásánál, hogy le tudjuk kérdezni, hogy mi történt a múltban.

    • @BILingualAnalytics
      @BILingualAnalytics 16 дней назад

      Eleg sok mindent ki lehet huzni automate-bol is. A flow -> report mondjuk nem biztos hogy a legegyszerubb. Mi van akkor ha az adat egy dataflow-bol jon ami uj file letrehozasakor frissul (automate); de utana a model mar scheduled refresh-ben mukodik. Ezt megjelolned mint “erintett” report a flow altal? A munkavallalos kerdest nem teljesen latom meg. Irsz egy ket extra mondatot hozza?

  • @Alan-ps2ul
    @Alan-ps2ul 17 дней назад

    Excellent tutorial which has solved the problem I had with multiple files all with same name but different date stamp. Thank you so much

  • @shalinderkumar9993
    @shalinderkumar9993 20 дней назад

    Hi Brother, I want to learn Power BI, from where I can learn. So I land my first job as data analyst. Could you please help me ?

    • @BILingualAnalytics
      @BILingualAnalytics 16 дней назад

      The most important thing is to keep trying. It takes time to master both hard and soft skills. You can find lots of great tutorials online, but first make a decision on what career path (or role) sounds like you

  • @nkkkkk406
    @nkkkkk406 21 день назад

    Thanks for the video! What macbook are you using? Is it working perfectly? I want to go for a 24go macbook air but wondering if it would be enough for Power BI

    • @BILingualAnalytics
      @BILingualAnalytics 21 день назад

      Mine is an M3Max with 64gb ram. Not sure PBI needs the 64gb model but as I edit videos it makes everything easy :)

  • @BILingualAnalytics
    @BILingualAnalytics 23 дня назад

    Did you know you can use Field Parameters for such a problem? Let me know!

  • @antique-bs8bb
    @antique-bs8bb 26 дней назад

    Interesting - I didn't know that . Audio not up to your usual high standard fyi.

    • @BILingualAnalytics
      @BILingualAnalytics 25 дней назад

      It's good to know - especially if you try to spend lots of time fixing a problem that you won't be able to solve :) Thanks, unfortunately, I only noticed the sound quality after recording 2 videos in the new studio. I'm back to my default mic now, so new ones should be back to the regular quality 🤞

  • @BILingualAnalytics
    @BILingualAnalytics 29 дней назад

    Did you know that you can do this in Power BI Service? 🧠

  • @igorarkhipov604
    @igorarkhipov604 Месяц назад

    Great information 🙃

  • @sidkings
    @sidkings Месяц назад

    Unfortunately I have a totally different lay out and can only change colours on data labels and category labels. Very frustrating.

    • @BILingualAnalytics
      @BILingualAnalytics Месяц назад

      It might have changed since I published the video :( I have to check

  • @BILingualAnalytics
    @BILingualAnalytics Месяц назад

    Were you aware of this limitation? If so, how did you fix it before? I'm keen to hear other options as well!

  • @tigsik3128
    @tigsik3128 Месяц назад

    very nice. Do you have something where once we know the latest month for instance and have this month be selected by default on a slicer so instead of showing all the months we are only showing the filtered latest month. just subscribed! thanks for the videos!

    • @BILingualAnalytics
      @BILingualAnalytics 29 дней назад

      Should be quite similar but instead of using a single day (ie MAX or MIN) calculate what is the latest month.

  • @alexspikezak453
    @alexspikezak453 Месяц назад

    Link to part 2 please?

  • @ondaonda-xy5zf
    @ondaonda-xy5zf Месяц назад

    Just saved my life thanks legend

  • @legendgod
    @legendgod Месяц назад

    Could we check the session length of report open?

    • @BILingualAnalytics
      @BILingualAnalytics Месяц назад

      As in for how long someone logged in to the report? To the best of my knowledge no

  • @BILingualAnalytics
    @BILingualAnalytics Месяц назад

    Did you know you can achieve such automation with these simple tricks? Let me know here 👇

  • @pamelacarbonara9876
    @pamelacarbonara9876 Месяц назад

    That's amazing!! I've never thought about it, but I believe it can bring a lot of value for business!

    • @BILingualAnalytics
      @BILingualAnalytics Месяц назад

      I know, right? It is such a simple yet powerful trick!

  • @rstiekema
    @rstiekema Месяц назад

    Where is your video about automated token generation for the powerbi rest api?

  • @BILingualAnalytics
    @BILingualAnalytics Месяц назад

    And if you want to ungroup those elements just simply delete the text from the Display folder section. Isn't this great?

  • @cristitrss
    @cristitrss Месяц назад

    How can i use power automate to check if my scheduled datasets refresh are failing or not?

    • @BILingualAnalytics
      @BILingualAnalytics Месяц назад

      You either use API connection to pick up the status of the dataset refresh (premium connector) or create a "last updated" measure and apply some logic (IFTTT) and set up an alert.

  • @AnuragB-hg7xi
    @AnuragB-hg7xi Месяц назад

    Hi Roland, I want to append new daily data to existing data pulled. Can you recommend something for that?

    • @BILingualAnalytics
      @BILingualAnalytics Месяц назад

      Hey, yes you can do that. There are a few options to do that. Either use "Add a row into a table" as an Excel connector OR use the "Add rows to dataset" as a Power BI Connector OR create a CSV file and combine with previously exported CSV files :)

  • @bendavidson1269
    @bendavidson1269 Месяц назад

    great vid, do you know id this works with Dax functions on data already in a power dashboard

    • @BILingualAnalytics
      @BILingualAnalytics Месяц назад

      Not sure if I know what you mean by that. Can you please give me a bit more details?

  • @joshmcgowan4
    @joshmcgowan4 Месяц назад

    Nice video thank you. I was hoping this trick would work for a Treemap to show the worst or lowest values in the top left. Unfortunately I could not make it work.

    • @BILingualAnalytics
      @BILingualAnalytics Месяц назад

      I would create a measure based on ranking and use it to drive how you want to sort the Treemap.

  • @sol_aveiro
    @sol_aveiro 2 месяца назад

    Thank you so much! Very easy-to-follow video!

  • @TBHHyderabad
    @TBHHyderabad 2 месяца назад

    How to Filter reports based on Included in app column

  • @jdsenuk
    @jdsenuk 2 месяца назад

    Many thanks for showing the 2 methods, definitely solved my problem and I learnt something new.

  • @BILingualAnalytics
    @BILingualAnalytics 2 месяца назад

    Did you know it is possible online? Let me know here 👇👇👇

  • @user-ld8mz8qv1k
    @user-ld8mz8qv1k 2 месяца назад

    Hi Great video, I have a table total that I would like to snapshot once a week, is this possible?

    • @BILingualAnalytics
      @BILingualAnalytics 2 месяца назад

      Absolutely! If it is just a total I’d suggest getting that total out of the table and put it into a card. Then generate the code following the video and it should be super easy :)

    • @user-ld8mz8qv1k
      @user-ld8mz8qv1k 2 месяца назад

      @@BILingualAnalytics I did it, works perfectly, I have the data coming from SQL, then totaling in a PowerBI visual, then automating via power automate from that visual to a SharePoint list, then back into the PowerBI dashboard!

    • @BILingualAnalytics
      @BILingualAnalytics 2 месяца назад

      @@user-ld8mz8qv1k Glad to hear it works! :)

  • @catgentry
    @catgentry 2 месяца назад

    Here’s a new one for me. Dataflow refreshes just fine over a table in our database. No additional steps in power query editor. When I connect to the dataflow in my dashboard, the data doesn’t match to the dataflow online or my table in the database. I’ve refreshed (no errors), checked power query editor online for the dataflow and within the dashboard. Doesn’t match. I’m stumped.

    • @BILingualAnalytics
      @BILingualAnalytics 2 месяца назад

      Can you pinpoint to what data is missing? Or what’s causing the difference?

  • @sudipnarayanchoudhury1112
    @sudipnarayanchoudhury1112 2 месяца назад

    Page navigator function box is not taking the measure.. I followed the same process but that fx in destination field is not taking the measure..please help

    • @BILingualAnalytics
      @BILingualAnalytics 2 месяца назад

      It might have changed. Will try to replicate over the weekend.

  • @user-ze4xc6tu4f
    @user-ze4xc6tu4f 2 месяца назад

    U are badass

  • @gauravox
    @gauravox 2 месяца назад

    Brother you are awesome currently in 2 days i working on audit dashboard and they have litrelly 50 charts and it consuming litrelly a lot of hours to filtering them but with the help of you i Literally got promotion 😂 thank a lot man appreciate your work and subscribe also keep going 👍🏻

    • @BILingualAnalytics
      @BILingualAnalytics 2 месяца назад

      Glad it worked out for you! Keep up the good work!!!

  • @olga_p6526
    @olga_p6526 2 месяца назад

    i just love you for this solution. literally saved my life. THAAANKS!

  • @lindarn6--269
    @lindarn6--269 3 месяца назад

    @BILingualAnalytics I have scoured the interwebs for a solution in Power BI to track daily data for an agile team, think user stories with status changes daily, in order to build CFD charts, compare planned and completed points over sprints etc, and I can't find anything that seems even close to being able to capture daily data changes into one data set that can easily be stored and queried 😭😭 Could this be a solution for tracking daily data changes to the status of a set of user stories....??

    • @BILingualAnalytics
      @BILingualAnalytics 2 месяца назад

      Potentially could be. However, if the requirement is to track it daily and have a LOTS of data I'd probably look into a proper data warehouse solution. If you only have a handful of datapoints to "track" this will be fine.

  • @majidtaheri-yq9kq
    @majidtaheri-yq9kq 3 месяца назад

    Hi, What should be done if there are several of these data in a single sheet?

  • @enocharthur4322
    @enocharthur4322 3 месяца назад

    This is awesome

  • @saruncse85
    @saruncse85 3 месяца назад

    @Roland thanks for video. Can you point me to how you are creating the measures for legend and showing it on the UI?

    • @BILingualAnalytics
      @BILingualAnalytics 2 месяца назад

      Which part would you like to see more details about?

    • @saruncse85
      @saruncse85 2 месяца назад

      @@BILingualAnalytics on how to display legend based on matrix table values

    • @BILingualAnalytics
      @BILingualAnalytics 2 месяца назад

      @@saruncse85 those are Min | 25th percentile | Median | 75th percentile | Max values in their dedicated card visual. But if you look at Part III, Barnabas shared a much more elegant way of creating the legend

  • @abderrezzakbendounan9153
    @abderrezzakbendounan9153 3 месяца назад

    do you need power bi desktop or power bi pro ?

    • @BILingualAnalytics
      @BILingualAnalytics 3 месяца назад

      You don’t need PRO to replicate this setup (potentially), but I’m nor sure why would you want to replicate without sharing. And for that you will need PRO.

  • @Wzxxx
    @Wzxxx 3 месяца назад

    Never seen such an absolutely crap documentation on any ideas in any software like MS did.. I have no idea how to implement it. It is so counterintuitive. IFs not working, the whole concept od TRUE / FALSE in this area is completely messed up. I see result which are just are completely different from my understanding od Boolean values and DAX after some years of experienced I am 100% stuck in this,

    • @BILingualAnalytics
      @BILingualAnalytics 2 месяца назад

      RLS could be difficult to implement. However, with some practice, I would say most of the things that you would like to apply can be done. Especially with Dynamic RLS

  • @theophilusanaduaka556
    @theophilusanaduaka556 3 месяца назад

    It picks the date from the first file and uses it for every other file in the folder. How do I rectify this

  • @piotro2068
    @piotro2068 3 месяца назад

    THank you, very helpful, this was what I was looking for

  • @mattolenn
    @mattolenn 3 месяца назад

    This is such an elegant way of solving a common problem. Your outstanding, clear, concise video enables me to eliminate a lot of inefficient, ugly, or manual workarounds. Much appreciated!