- Видео 53
- Просмотров 980 264
BI Consulting Services
США
Добавлен 26 янв 2019
Welcome to the BI Consulting Services RUclips channel!
Unlock the secrets to data analytics by leveraging Power BI, Power Apps, Power Automate, and the entire Power Platform.
Learn data visualization, insights, and Power BI reporting best practices. Subscribe to boost your Power BI skills!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Visit our website: www.powerbiconsultingservices.com for Microsoft Power BI Consulting Services.
Learn more from our expert Data Management Team on Medium: powerbiconsulting.medium.com
Download Power BI: powerbi.microsoft.com/en-us/downloads/
Unlock the secrets to data analytics by leveraging Power BI, Power Apps, Power Automate, and the entire Power Platform.
Learn data visualization, insights, and Power BI reporting best practices. Subscribe to boost your Power BI skills!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Visit our website: www.powerbiconsultingservices.com for Microsoft Power BI Consulting Services.
Learn more from our expert Data Management Team on Medium: powerbiconsulting.medium.com
Download Power BI: powerbi.microsoft.com/en-us/downloads/
Power BI DAX for Beginners #7: Context in DAX - ROW CONTEXT, FILTER CONTEXT, AND CONTEXT TRANSITION
Join me for the seventh video in our series: Power BI DAX for Beginners! We'll be covering some of the concepts around Context in DAX, including Row Context, Filter Context, and Context Transition. These topics will help set you on the path of providing great data analysis in Power BI!
0:00 - Intro
0:30 - Row Context
1:54 - Filter Context
3:02 - Context Transition
3:49 - Outro
Link to download Microsoft Power BI: powerbi.microsoft.com/en-us/d...
📢 Follow us for more updates: 🔹 Twitter 🔹 LinkedIn 🔹 Facebook 🔹 Instagram
x.com/PowerBIPartners
www.linkedin.com/company/power-bi-consulting-services/
PowerBICS/
powerbiconsultingservices
Need help with Power BI? Contact us for ex...
0:00 - Intro
0:30 - Row Context
1:54 - Filter Context
3:02 - Context Transition
3:49 - Outro
Link to download Microsoft Power BI: powerbi.microsoft.com/en-us/d...
📢 Follow us for more updates: 🔹 Twitter 🔹 LinkedIn 🔹 Facebook 🔹 Instagram
x.com/PowerBIPartners
www.linkedin.com/company/power-bi-consulting-services/
PowerBICS/
powerbiconsultingservices
Need help with Power BI? Contact us for ex...
Просмотров: 41
Видео
Master These Excel Shortcuts to Save Hours! | Tips for Beginners & Pros
Просмотров 10 тыс.21 день назад
🎥 Excel Shortcuts to Save Hours of Time | Tips & Tricks for Beginners and Pros Tired of wasting hours in Excel? 🚀 In this video from PI Consulting Services, we share must-know Excel shortcuts to boost your productivity and make your workflows smoother. Whether you’re a beginner or an Excel pro, these tips will help you save time and work smarter. 📌 What’s Inside? Learn how to freeze panes, form...
Power BI DAX for Beginners #6: Filter Functions - FILTER, ALL, ALLSELECTED, & CALCULATE
Просмотров 40 тыс.Месяц назад
Join me for the sixth video in our series: Power BI DAX for Beginners! We'll be covering some of the filter functions including FILTER, ALL, ALLSELECTED, and CALCULATE. These DAX functions will help set you on the path of providing great data analysis in Power BI! 0:00 - Intro 0:26 - FILTER 1:56 - ALL 7:04 - ALLSELECTED 8:04 - CALCULATE 9:55 - Outro Link to download Microsoft Power BI: powerbi....
Power BI DAX for Beginners #5: Date Time Functions - Today/Now, Datediff, Year/Month/Day, Eomonth
Просмотров 9 тыс.Месяц назад
Join me for the fifth video in our series: Power BI DAX for Beginners! We'll be covering some of the basic text functions including TODAY/NOW, DATEDIFF, YEAR/MONTH/DAY, and EOMONTH. These DAX functions will help set you on the path of providing great data analysis in Power BI! 0:00 - Intro 0:56 - TODAY/NOW 2:34 - DATEDIFF 3:38 - YEAR/MONTH/DAY 5:25 - EOMONTH 6:27 - Outro Link to download Micros...
Power Query Tips & Tricks: Transform Data Like a Pro in Power BI
Просмотров 15 тыс.2 месяца назад
Master Power Query: Tips & Tricks for Data Transformation in Power BI In this video, we dive into Power Query with practical tips and tricks to optimize your data transformation process in Power BI. Using the popular AdventureWorks dataset, we cover: ✅ Importing and cleaning CSV files ✅ Understanding applied steps for dynamic transformations ✅ Using features like Column Quality, Distribution, a...
Power BI DAX for Beginners #4: Text functions - Concatenate, Left, Right, Mid, Upper, Lower, and Len
Просмотров 17 тыс.2 месяца назад
Join me for the fourth video in our series: Power BI DAX for Beginners! We'll be covering some of the basic text functions including CONCATENATE, LEFT/RIGHT/MID, UPPER/LOWER, & LEN. These DAX functions will help set you on the path of providing great data analysis in Power BI! 0:00 - Intro 0:32 - CONCATENATE 2:43 - LEFT/RIGHT/MID 5:51 - UPPER/LOWER 6:43 - LEN 7:25 - Outro Link to download Micro...
SharePoint Online and Power Automate Integration
Просмотров 26 тыс.3 месяца назад
Welcome back to BI Consulting Services! In today's tutorial, Nicole walks us through a step-by-step guide on integrating Power Automate with SharePoint Online. This is a straightforward, beginner-friendly demonstration where you'll learn how to create a feedback survey in SharePoint, set up columns for survey data, and configure Power Automate to capture and display survey responses seamlessly....
Power BI DAX for Beginners #3: IF, SWITCH, AND & OR
Просмотров 8 тыс.3 месяца назад
Join me for the third video in our series: Power BI DAX for Beginners! We'll be covering some of the basic functions including IF, SWITCH, AND & OR. These DAX functions will help set you on the path of providing great data analysis in Power BI! 0:00 - Intro 0:33 - IF 5:17 - SWITCH 8:32 - AND & OR 13:03 - Outro Link to download Microsoft Power BI: powerbi.microsoft.com/en-us/d... 📢 Follow us for...
Automation Made Simple: Power Automate for Business Emails (Anniversary Case Study)
Просмотров 30 тыс.3 месяца назад
Learn how to automate emails with embedded images using Microsoft Power Automate! In this step-by-step tutorial, we'll walk through creating a Power Automate flow to send automatic email notifications for employee anniversaries or birthdays, complete with embedded images. Whether you're managing employee recognition or other business processes, this tutorial will show you how to set up schedule...
Creating an Environment in Dataverse in Under 5 Minutes
Просмотров 24 тыс.4 месяца назад
Join us as we set up a simple sales environment in Dataverse and connect it to Power BI for real-time data visualization in under 5 minutes! 🚀 Hit the 'Like' button, share this video across your network, and make sure to subscribe to our channel for more exciting content! 🔔 #Dataverse #PowerApps #Microsoft #PowerPlatform
Power BI DAX for Beginners #2: SUM, AVERAGE, COUNT, MAX & MIN
Просмотров 29 тыс.5 месяцев назад
Join me for the second video in our series: Power BI DAX for Beginners! We'll be covering some of the basic functions including SUM, AVERAGE, COUNT, MAX, and MIN. These DAX functions will help set you on the path of providing great data analysis in Power BI! Link to download Microsoft Power BI: powerbi.microsoft.com/en-us/d... 📢 Follow us for more updates: 🔹 Twitter 🔹 LinkedIn 🔹 Facebook 🔹 Inst...
Power BI DAX for Beginners #1: Calculated Columns and Measures
Просмотров 29 тыс.5 месяцев назад
Join me for the first video in our new series: Power BI DAX for Beginners! We'll be walking through the many aspects that make up DAX, including Calculated Columns, Measures, Formulas, Functions, and much more! Link to download Microsoft Power BI: powerbi.microsoft.com/en-us/d... 📢 Follow us for more updates: 🔹 Twitter 🔹 LinkedIn 🔹 Facebook 🔹 Instagram x.com/PowerBIPartners www.linkedin.com/com...
Power BI Service Tips & Tricks | Essential Guide for Power BI Online Users
Просмотров 24 тыс.6 месяцев назад
📊 Power BI Service Tips & Tricks | Essential Guide for Power BI Online Users 📊 Welcome to our Power BI Consulting Services channel! In this video, Nichole from Power BI Consulting Services shares valuable insights and tips on navigating the Power BI Service (Power BI Online). This session is tailored to help you maximize your efficiency and effectiveness with Power BI Service Tips and Tricks. 🚀...
Elevate Your Work Game: Microsoft Copilot in Action
Просмотров 26 тыс.7 месяцев назад
🚀 Welcome to our in-depth video on Microsoft Copilot, your ultimate companion for work productivity! 🚀 In this video, we'll explore what Microsoft Copilot is, how to enable it, and its benefits to your daily tasks. 🔍 What is Microsoft Copilot? Microsoft Copilot is an innovative AI-driven assistant designed to enhance productivity across Microsoft 365 applications. Learn more about this exciting...
Power BI for Beginners: Video #4 - Report Design in Practice
Просмотров 26 тыс.8 месяцев назад
Power BI for Beginners: Video #4 - Report Design in Practice
Building a Microsoft Copilot in Under 2 Minutes
Просмотров 79 тыс.9 месяцев назад
Building a Microsoft Copilot in Under 2 Minutes
Power BI for Beginners: Video #3 - Report Design Principles
Просмотров 40 тыс.10 месяцев назад
Power BI for Beginners: Video #3 - Report Design Principles
Building a Website in 5 Minutes with Microsoft Power Pages
Просмотров 33 тыс.Год назад
Building a Website in 5 Minutes with Microsoft Power Pages
Power BI for Beginners: Video #2 - Query Editor & First Visuals!
Просмотров 22 тыс.Год назад
Power BI for Beginners: Video #2 - Query Editor & First Visuals!
Power BI for Beginners: Video #1 - What is Power BI?
Просмотров 27 тыс.Год назад
Power BI for Beginners: Video #1 - What is Power BI?
Creating a Microsoft Form in 3 Minutes
Просмотров 22 тыс.Год назад
Creating a Microsoft Form in 3 Minutes
Creating a Microsoft Power Automate Flow in 2 Minutes
Просмотров 27 тыс.Год назад
Creating a Microsoft Power Automate Flow in 2 Minutes
Building a Microsoft Power App in 5 Minutes
Просмотров 24 тыс.Год назад
Building a Microsoft Power App in 5 Minutes
Building a Power BI Dashboard in Under 10 Minutes
Просмотров 32 тыс.Год назад
Building a Power BI Dashboard in Under 10 Minutes
Unleash the Power Platform: Exploring Dynamic Projects & Data Insights via Power BI
Просмотров 1,3 тыс.Год назад
Unleash the Power Platform: Exploring Dynamic Projects & Data Insights via Power BI
June and July 2023 Power BI Updates: Card and Line Chart Updates!
Просмотров 1,4 тыс.Год назад
June and July 2023 Power BI Updates: Card and Line Chart Updates!
May 2023 Power BI Updates: Fabric and Copilot Announcements!
Просмотров 1,3 тыс.Год назад
May 2023 Power BI Updates: Fabric and Copilot Announcements!
Build a Chatbot Using Power Virtual Agents | Part #2
Просмотров 13 тыс.Год назад
Build a Chatbot Using Power Virtual Agents | Part #2
Build a Chatbot in Microsoft Teams Using Power Virtual Agents | Part #1
Просмотров 14 тыс.Год назад
Build a Chatbot in Microsoft Teams Using Power Virtual Agents | Part #1
0:53
Edit Form is not shwoing any data though conected to SQL table having data
Hmm, if you send a screenshot and we can fix it we will do a. video on it in a future video! info@powerbiconsultingservices.com
😮झूठे थे😅यर
😂😊
can you restart the process of asking question again without resetting the test bot?
Superb
0:00 - Introduction to Power Automate and SharePoint Integration 1:12 - Welcome & Overview of Video Content 1:57 - Creating a SharePoint Communication Site 2:30 - Setting Up a Feedback Survey List in SharePoint 3:45 - Adding Columns to the Feedback Survey (Title, Name, Satisfaction Score) 5:12 - Configuring Multi-Line Text and Choice Fields 6:24 - Overview of the Completed Feedback Survey List 7:02 - Moving to Power Automate for Workflow Setup 7:40 - Creating an Instant Cloud Flow in Power Automate 8:24 - Adding Form Input Fields to Power Automate Flow 9:55 - Mapping SharePoint List Columns to Flow Inputs 11:15 - Creating Items in SharePoint via Power Automate 12:20 - Entering SharePoint URL and Choosing List in Power Automate 13:42 - Connecting Flow Inputs to Dynamic Content in Power Automate 15:05 - Saving and Testing the Flow Setup 16:30 - Running a Test of the Automated Flow 17:55 - Verifying the Data Entry in SharePoint 18:37 - Wrapping Up & Additional Power Automate Tips 19:22 - Closing Thoughts and Call to Action
At 4:13 it shows a list... say there is more than two objects like an employee list... could there be multiple tabs on the one page that a user can toggle? like pages 1-3? great video
Hi: What if SQL Server is not cloud based? It would seem I have to migrate local SQL Server to cloud in order PowerApp connect to it.? thanks
Build a chatbot with Power Virtual Agents and take it to the next level with SmythOS! Our advanced AI solutions integrate seamlessly to enhance your chatbot’s capabilities, providing smarter responses and more efficient interactions
Fsgaajaadah 0:00 ahvhhfgadaa 3 a A3aafaa1jaj1a1ajhaA1jch 0:00 0:00 0:00 0:00 0:00 A1jh1
Hagbaajdh 0:00 Ah ada
😊
Great video. Thank you 😊
😅😢😅😢😢😢😢😅😅😢😢😢😢😢😢😢😢😢😢😢😅😢😅😢😅😅😢😅😢😢😢😢😢😢😢😢😢😅😢😢😢😢😢😢😢😢😢😢😅
I like that plus theses are some of the best ways to show how easy you can run this is very smart
Is there any solution to do this whole process, when this is based on more than one table?
BB r 3:18 3:18
Rr
Ran
😊😊 by AA AAP AAP@@KritibhusanMahato
i have a problem in PQ in Excel (2019 v)... data preview tab in power query at excel shows only two options ( whitespace - monospacced ) how i show column quality option ? all the best...
Thank you
Great video! Thanks for sharing. Just one question: would this work to share reports with free Power BI Users?
Unfortunately not, a free user can create and view/share their own content but not that of other users. If you have a specific license type in mind that you have and you want me to verify just let me know!
Hi anna🎉🎉🎉🎉🎉
What is the purpose of the wikipedia website if Copilot is going to use the uploaded Code of Conduct file?
Hi!! I Create a Power App that connects to my database located on my SQL Server. The database contains 4 tables, 2 of which are related through an intermediate table. I need the IDs from both tables to be added to the Power App as I fill out the other tables, and when I click another button, the IDs are added to the intermediate table. These tables and/or forms are on different screens.
Hi Brad, thanks for your video. What about if you need to remove character " ? I have a csv file and the double quotes " and I need to remove before separate the columns.
Excellent question. I have this doubt also..
Very helpful. Thank you!
Isn't it possible to change the column imidiately without making a new column? This seems like extra steps where I just want to do it for multiple columns at once
Hey there! There are certainly a couple different ways you could go about removing or replacing values in a column. Depending on the amount of characters you're needing to remove or replace, a simple "Replace Values" on the columns in Transform could do the trick!
this video is great, thank you so much💯
We're so glad you enjoyed it!
kindly improve the audio quality plz The background music is little bit high
Thanks for the feedback! We'll tone it down going forward :)
Good
Thank you!
@@biconsultingservices7774 youtube.com/@ritukumari-fj3sl?si=iOGc4aDK-G7oiy1O
hii
Hello, i find this very helpful. Thanks! Would also like to ask if the primary key (ID) in the SQL DB can be auto generated? Because what i noticed is that, you manually input the ID number in the dropdown menu and upon submitting, it will also reflect in SQL DB as ID
When you are creating the table, use "Id int identity(1,1) primary key not null" and it will auto increment
very good explanation
Uum
Do you know why I get this error when I try to add a new record? Network error when using Patch function: specified record was not found. Thanks!
Dump the stupid music - this is not tik tok
Hmm, this is a very unusual method to have 3 screens for CRUD. I would like to see the functions rather from the same screen, and honestly not very user friendly with ID dropdown and no search, and expecting user to add a PK on Insert. Sorry, if this sounds critical but you should rather show the full proper methods to people. Just an honest observation.
Question About the PK (ID) field...can you show how to autonumber it for the next record in sequence, then display it if view mode only and never let the user edit it directly plse. This is what I mean: ruclips.net/video/awsNLPGNI4w/видео.htmlsi=nskz6ZdCHZcJrjDK at min 10:45 or so, I appreciate your video and sharing, just would be nice to show how to deal with primary keys automatically.
Perfect!!!! straight to the point! thank you.
❤❤❤❤
Promo`SM 😈
When I added the edit form and use sql connection, it cannot allow to edit, just show me in view mode, I already have a pro license in power apps.... but I see that my canvas has standard license
Hey! Maybe you can reach out to us via email and we can do a video on this in the future. Just need a few more details though - info@powerbiconsultingservices.com so we can dig into it a bit more!
I am not sure if someone has answerd this, but to have the text boxes as edit, please add primary key to the table
Perfect video and very well explained ! Well in my case at the submit button when i try to insert a record in my db , i have the following error. "network error when using Patch function: The specified record was not found". Does anyone have any ideas ?
Let me see if I can replicate this error and do a video on it myself. More to come as I try to replicate but here is a quick link to an article recommending you remove the sql source and add it back! We gotta love the #microsoftforums powerusers.microsoft.com/t5/Building-Power-Apps/The-Specified-record-was-not-found-Resource-not-found-error/m-p/668006#M213096
0p
Very interesting. Great to see MS still offering something like this. Is it possible to programatically change or calculate a value when another field is changed? For example, if there were several integer fields in one record, where one of the fields shows the average of the other fields? Thanks for the content, it is very helpful!
It probably is possible! Just need a few more details though - info@powerbiconsultingservices.com so we can dig into it a bit more!
Hi when you type in the username and password is this the person that is in the Powerapp
that sounds correct! is there something specifically you are looking for?
@@biconsultingservices7774 Hi I’m just new to the SQL server situ , my company has a bunch of tables in a SQL database that they want me to make a PA from . Just wondering is there a generic username and password that’s used to get into the database or do people get their own username / password where several people can be in the server database at the same time
L
would it be possible to make some slowly changing dimension methodology in power app by using existing record to make update but keep original record and make new record the latest one
Hey! Yes you can! We will do a mini-video on this soon.
One of THEE best PowerApp videos ever!!! Straight-forward, no fluff, clear, and very informative. Saved me a few hours. Thank you so much!!! Looking forward to seeing more of your videos.
Cool! Let me know if you have any other needs in the future! We are always looking for cool content ideas!
@@biconsultingservices7774 thank you!!! It would be amazing if you could do a quick video on how to use the login credentials to track app activity. I'm literally creating my first app and 95% there. I have the login working but would like to be able to track who collected what data.