- Видео 122
- Просмотров 514 851
Hat Full Of Data
Великобритания
Добавлен 27 янв 2013
Laura is a Data Platform MVP and Power Platform consultant specialising in presenting data with 20 years experience teaching how to make Microsoft products behave. Finally moved some of my training online.
Power Automate get data from Power BI dataset Revisited
Pulling data from a Power BI dataset has some exciting updates in Power Automate and Power BI. We now have a DAX tab to write simple DAX to pull the right data. Power Automate has had a makeover and I show you how to use Parse JSON to get more details about your data.
Blog post is coming I promise!
Table of contents
00:00 Introduction
00:38 Step 1 - Write the DAX
02:06 Step 2 - Write the flow and run to get sample data
06:04 Step 3 - Tidy up the data with Parse JSON
07:48 Create HTML Table Advanced
Blog post is coming I promise!
Table of contents
00:00 Introduction
00:38 Step 1 - Write the DAX
02:06 Step 2 - Write the flow and run to get sample data
06:04 Step 3 - Tidy up the data with Parse JSON
07:48 Create HTML Table Advanced
Просмотров: 8 523
Видео
Microsoft Fabric - SQL Analytics Endpoint
Просмотров 1 тыс.7 месяцев назад
How do we query our data that we've loaded into Fabric? We use SQL Analytics Endpoint to write a query, save a view and even write a visual query (Power Query to you and me) Table of Contents 00:00 Introduction 00:14 Opening the SQL Analytics Endpoint 00:58 Write First Query 02:06 Write more queries 03:22 Save as View 04:07 Visual Queries
Microsoft Fabric - Notebook and Data Wrangler
Просмотров 7957 месяцев назад
I am not a notebook developer, so I use data wrangler to help me write code to load a file and transform it and then I write the online of code to save it to the table. Easy low code solution in Microsoft Fabric Blog post - hatfullofdata.blog/microsoft-fabric-notebook-and-data-wrangler/ Table of Contents 00:00 Introduction 00:26 Create Notebook 00:49 Add Markdown Header cell 01:48 Load file dat...
Microsoft Fabric - Create a table using a Dataflow
Просмотров 1,1 тыс.7 месяцев назад
On of the most exciting updates for me in Microsoft Fabric was Gen2 Dataflows that can write to to a table. This video walks through taking a folder of files and making a table. Also includes a cool date transformation. Blog post - hatfullofdata.blog/microsoft-fabric-create-tables-with-dataflows/ Table of Contents 00:00 Introduction 00:31 Create Dataflow 02:17 Combine files 03:40 Fix the Date f...
Microsoft Fabric - Create table from csv file
Просмотров 1,6 тыс.7 месяцев назад
In a previous video we uploaded a csv file into the Lakehouse. In this video we take the next step to create table from csv file loaded into the Lakehouse. No code method to load data into Microsoft Fabric Table of Contents 00:00 Introduction 00:32 Create table 01:18 Look at the created table 01:36 Clean source data 02:26 Loading updated csv file
Microsoft Fabric - Upload File and Folder
Просмотров 1,1 тыс.7 месяцев назад
One of the easiest ways to load data into a Lakehouse is via uploading a csv file or folder of csv files. In this view we show how easy it is to upload a file and a folder. Blog post - hatfullofdata.blog/fabric-upload-a-file-and-folder/ Table of contents 00:00 Introduction 00:10 Upload a csv file 01:11 Upload a Folder of CSV Files 02:28 Updating a File
Microsoft Fabric - Create a Lakehouse
Просмотров 5497 месяцев назад
Videos to cover the basic building blocks. In this one we check we have Fabric capacity and then create our first Lakehouse. Blog post - hatfullofdata.blog/fabric-create-a-lakehouse/ Table of Contents 00:00 Introduction 00:13 Check Workspace Fabric Capacity 00:38 Find the Lakehouse Button - 2 methods 01:16 Create and Name the Lakehouse 01:46 Lakehouse Created 02:02 3 Items Created in Workspace
Power BI and Google Analytics 4
Просмотров 8 тыс.10 месяцев назад
Get your website stats into Power BI using Google Analytics 4. Thankfully the Google Analytics connector has been updated to now connect to GA4. Quick walk through including how to add extra columns afterwards. Blog post coming! Table of contents 00:00 Introduction 00:19 Connecting to Google Analytics 03:00 Add extra columns to query 04:29 Add slicer
Power Automate write a flow for me
Просмотров 89910 месяцев назад
For a session at Scottish Summit 2023 I needed to build a small flow really quickly so I tried out the Describe it to design it feature. It worked really well for the demo so here's a video showing you how I built a flow start to finish in 2 mins. Blog Post - hatfullofdata.blog/power-automate-write-me-a-flow/ Table of Contents 00:00 Introduction 00:20 Describe the flow 01:26 Modify Settings 01:...
Power Automate button in a Power BI report
Просмотров 6 тыс.11 месяцев назад
A Power Automate button in a Power BI report gives the viewer the ability to do actions. In this video we use a Power Automate button, triggering a flow to add a new row to a table to annotate a chart. Add actions to your Power BI reports. Blog post coming Table of contents 00:00 Introduction 01:34 Add Power Automate Button 01:49 Add Data to button 02:22 Edit Visual to write Flow 04:20 Save and...
Power Automate get data from Power BI dataset
Просмотров 35 тыс.11 месяцев назад
Power BI datasets contain a brilliant source of data that would be useful in a Power Automate flow. In this video we do a simple example of pulling sales results from a Power BI dataset and emailing it to a manager. Blog post to support video hatfullofdata.blog/power-automate-get-data-from-a-power-bi-dataset/ Report and data used in this video can be found here github.com/Laura-GB/DemoData#sale...
Power BI Custom Smart Narrative
Просмотров 1,1 тыс.11 месяцев назад
Video to show you how to write your custom narrative text box creating your own calculations from natural language (well mostly). A few measures help but no complex DAX required. Get the report used in this video at github.com/Laura-GB/DemoData/raw/main/Sales Data.pbix Table of Contents 00:00 Introduction 00:13 Add Standard Smart Narrative 00:45 Start Custom Narrative in a text box 01:12 Add Dy...
Power Platform Solutions and Power BI Part 3
Просмотров 476Год назад
Part 3 is the clever part in the series to use the report added in part one, embed in a Dataverse form and filter to match the form, for example only show the data related to the account in the form. Blog post to support the video hatfullofdata.blog/power-platform-solution-and-power-bi-part-3/ Playlist for the whole series ruclips.net/p/PLclDw3xU_tI7GIRyNI2gLdA0kzaFvwRaG Table of Contents 00:00...
Power Platform Solutions and Power BI Part 2
Просмотров 621Год назад
In Part 2 of this Power Platform Solutions and Power BI we add a dashboard using the report we added in Part 1. Blog post to support this video - hatfullofdata.blog/power-platform-solution-and-power-bi-part-2/ Playlist for the series - ruclips.net/p/PLclDw3xU_tI7GIRyNI2gLdA0kzaFvwRaG Table of Contents 00:00 Introduction 00:34 Add Dashboard to Solution 01:23 Add Dashboard to App 02:28 Test the d...
Power Platform Solutions and Power BI Part 1
Просмотров 1,3 тыс.Год назад
Power BI can now be added to your Power Platform Solutions. In Part 1 I had the report and dataset to the solution and check the workspace and confirm that when migrated to a new environment the new copy of the report connects to the new environment. The blog post to support this video hatfullofdata.blog/power-platform-solution-and-power-bi-part-1/ Playlist for the complete series ruclips.net/p...
Power BI Using Inactive Relationships in a Measure
Просмотров 1,7 тыс.Год назад
Power BI Using Inactive Relationships in a Measure
Embed Paginated inside a Power BI Report
Просмотров 5 тыс.Год назад
Embed Paginated inside a Power BI Report
Quick Paginated Report from a Power BI Dataset
Просмотров 9 тыс.Год назад
Quick Paginated Report from a Power BI Dataset
Power BI Introduction to Row Level Security
Просмотров 965Год назад
Power BI Introduction to Row Level Security
Sharing Power BI Report to a Teams Channel
Просмотров 5 тыс.Год назад
Sharing Power BI Report to a Teams Channel
Power BI - Add a calendar using Bravo
Просмотров 1,4 тыс.Год назад
Power BI - Add a calendar using Bravo
Hi, Great one Thank you. However, power BI is not allowing me to unpivot the data that comes from DataVerse table. If I unpivot, it immediately notifies to move to Import Mode. But I want it in DirQuery mode. Do you have any ideas to solve this issue?
Direct query has restrictions. Behind the scenes it converts the query into SQL and there are limits on that. I'm no SQL expert but you could possibly write an SQL query that does the unpivot and then use this technique hatfullofdata.blog/using-sql-on-dataverse-for-power-bi/
@@HatFullOfData123 🥰 Thanks a lot for your answer and link. Its great to know this. This could be a best solution for my goal to have live data using Dataverse instead ImportMode in Power BI..Let me try this.
Very useful video. Does it apply on daily refresh? I mean I tried similar to your method but I am still getting the data from yesterday, so it repeats me the "old schema" basically. How to make that dynamic?
If the semantic model is refreshed the data fetched should be refreshed. How are you specifying your date range in the DAX?
@@HatFullOfData123 Ah I checked the query in PA, and found that has been filtered on yesterdays date. So I built like IsToday on visual, saved it with new query and added this step in query. But I removed it afterwards (isToday) because the visual should be dynamic.. Do you think it will work tomorow wih new data`, or better question, is there an additional step in PA for like checking for todays date?
Making the DAX dynamic is the best way.
Hi FullHatOfData, Why did the reports show an increase in Test over Dev, and then another increase in Prod over Test regarding the # of Customers? Are records being duplicated? Not sure why the records are increasing per your example? Thank you
my data output is coming in one row instead of table ... can you please guide?
Have you just selected measures? What's the DAX?
@@HatFullOfData123 its work now. Accidently I Select wrong DB or something. But its ok now, Thanks.
Can you make a video or comment how to format the table? I am stuck on this. My table has several columns and shows a lot of brackets and Column names that will not be familiar to the user.
Already done. Take a look at this video and see if it helps ruclips.net/video/ByIt2h5m4S0/видео.htmlsi=7Dqs3qc01DliCd4I
Great video! I searched a lot for something like this! thank you! My only issue is that I need to send a scheduled email with a CSV file containing the data in a table format. I was able to do that but I got the CSV file to show me the data in the first row only and not as a table with headers and columns. Any idea on how to overcome this? thanks again!
I don't understand how it works. In which step did you program the bookmark to do a reset? Do you just name it "Reset" and it automatically does that?
thank you! your video is amazing 😃
You may not have a lot of subscribers but you have saved the one who watched your videos. Really saves my time. Thank you very much!
Im trying to append the extracted data into an excel but it always ends up adding 1 empty row. Anyone can help me?
You looping through adding rows? Is the blank row on the top or bottom?
You're my Savior.. Thanks much . please post more update format in Expression
Thank you - the 1st 'Compose' to generate JSON Schema has solved a problem I have spent the past 3 days working on and getting nowhere. This is such a great way to get working Schema and better than I've seen elsewhere on RUclips!
Compose rescues me soooo many times
My company disables add ins for PowerPoint so sad i cant use this!
I agree that is sad.
Hi , Is it possible to use SQL Analytics Endpoint as a source in Azure data factory - Copy activity. If yes, can I run the data from query instead of a table or view.
Fantastic tutorial - thanks!
Hi Laura, I followed your steps PBI automate is working however i am not able open the .pdf or .xls file which we receive in the mail...Could you please help me on this ?
How to get the PWA link from project online?
Thanks for your sharing. I am struggling on the DAX query and the video is really helpful for me.
Glad it helped
This is clear and very helpful, thank you!
You're very welcome!
I have been struggly hard to get the DAX query. Your video has been life-saving! Thx
Great to hear!
Hello. I have hyperlinked text in a Power BI table visualization that I’d like to bring in to Power Automate and then include in an email while preserving the clickable links. Do you know if that’s possible?
Yes I think so. You'll need to build a html <a> tag hyperlink. So you'll need the url as part of the data.
Hi , I'm getting the file to the email but when I tried to open the file, it is giving corrupted file error. How to over come this? Please help me here
You are my new best friend. First excellent explanation of this process I have found. Thank you so much.
Glad you liked it. I revisited this topic to rename the columns and make it pretty ruclips.net/video/ByIt2h5m4S0/видео.html
Very simple explanation on the steps for deployment. Thank you!!!
Glad it was helpful!
This video is extremely helpful! THANK YOU! I'm just wondering if there's a reason you keep the 'Compose' data operation before the 'Parse JSON'? would the flow still work without it?
You can get rid of it as we don't refer to it. Good point!
Hi, I followed the steps but my table doesn't show up in the Table folder in my lakehouse. Even I pick the right lakehouse and container. Do you have any suggestions to solve this?
Did the dataflow refresh okay?
One of the all-time greats. 5 stars!
You da best
Thank you!
Thank you for this video, it's life saving
You're so welcome!
Where can I find de "Key Vault" name? It's the key vault serivce itself? It's de Azure App name who has the secret? It's the secret objet id?
Yes it's Azure Key Vault
you saved me, thank you
Glad it helped!
Just started looking videos and yours one is so much simplified .....awsm
Thanks and welcome
hi thanks for the video, but this method has a limitation of rows, how to import all the rows into a csv table & then place it in one drive/sharepoint, I have already tried the mentioned flow but not getting all the rows in my csv.
Yes it has a limitation on the row count. It's not a tool for doing large extracts
thanks again, this is super helpful!
Thanks! This is a super useful video 🙂
Excellent - But - what an overly complicated application Power BI is. Bring back Microsoft access, that was so much more User friendly!!
I think you are forgetting the oddities of Access which I loved working with. Both have their strengths, quirks and delights.
Great Tutorial, well explained. Thanks
Glad it was helpful!
Hi, I need to write table visual data from powerbi to sql server via power automate , how can I do that ?
Has the Dax feature been removed? I am running the Feb 2024 release and I'm only seeing the standard 3 options.
Forget my previous question, I hadn't realised that there was a preview features facility
So, I came across a requirement to establish that I have to do the same thing except sending the data into a mail, I have to to add a new row to a dataverse table. Do you think is it doable?
Excellent video!
Glad you liked it!
Instead of sending email step, how to take this data and copy to a dataverse table? any video is available for that? please help. thank you
One method would be to use an apply to each step to loop through all the rows and use an add item to dataverse. If it is huge number of records there might be better methods
Thanks for this Laura, really helpful. Do you know if there is a way to automate posting into a Teams channel, e.g. to use your example, to schedule the report to be posted each week?
I dont find the Dataverse connection type in my report builder - do you have any idea why and how to add this connection type?
Hi Laura, given not all reports are 16:9 or 4:3, wondering if you have a workaround to specify the dimensions of the embedded power bi content or have the container autofit without producing white space?
Thank you! This worked perfectly. Is there a way to refresh the data once I update the CSV file?
You are great! Thank you!
keep cool!!!! keep cool!!!
this works fine to create the report locally. However, I get an error when deploying to dynamics 365 - "This report type is not supported. Microsoft Dynamics 365 Online supports only reports that use Fetch XML data sources. If you contact support, please provide the technical details". Please let me know if you come across this error and have any suggestions.
How are you deploying a paginated report to Dynamics? Not come across that as an option. Would Power BI desktop report work better?
There is option in dynamics to upload existing file as report directly in CRM ui
I will take a look!
Hi Laura Do you know if personal bookmarks (created in report xyz, accessed through workspace) should show up in the published app in the report xyz? In my expericece they don't show up which is a bit annoying from an enduser perspective