Pragmatic Works is a Microsoft-focused training company focused on driving technology adoption through education. We offer On-Demand Learning, live Boot Camps, Private Training, and free events, led by Microsoft MVPs, industry experts, and authors. Try On-Demand for free and enhance your skills with more than 120 courses, including Power BI, Power Apps, Azure, SQL Server, and more.
THANK YOU SO MUCH!! Ive spent all day trying to figure this out. we wee trying to enter company receipts into Microsoft forms and have the bookkeeper (third party company) access the live updating spreadsheet of form responses, but they couldn't see the attachments since they're outside of our organization. Sharepoint we CAN share to them, so I was trying to get forms to upload into sharepoint, with attachments. Thank you so much!!
Thank you for the great tutorial with clear speaking! I like the enlarged video image whenever I need a close look, which most of other tutorials don't have. Good job👍👍👍💯
Sir, I have a question, timestamp: 27:19, why did I received an error while signing in? It says that the error is create and authorize OAuth connection failed. How do I fix that?
When I create a table, it did not include the bottom several rows into the table created. It is caused by a blank cell in column A. How do I fix this issue. Since all the columns in my worksheet may have blank cells.
So I'm trying to think of a use case where someone attached something to a form? I never knew people do that. Maybe for onboarding? Submitting medical certs? (Though most HRIS already handle that kind of thing). I'd love to hear a real life case because I'm always looking for new ways to use power automate. Thanks!
thanks for this wonderfull course. but i need a help. i am following each step for creating report. but i see the sales tables does not have a proper date value in the date column. and then how do we be able to connect the sales fact to the date dimension. valuable reply would be much appreciated.
How can user see only his records, if his full name is stored in single text column not a owner or ownedby. We have imported excel file in dataverse where employee full name column has user name in single text field
Thank you so much for this video @matthew Peterson. I have a related problem, but in this case, I don't want to delete the old record but want to return only the most recent as a count.
I want to fetch User Email ID from system table 'Microsoft Entra ID' earlier it was called as 'aaaduser' I load that source table in data flow. can you suggest what should I do?
Is it possible to have a parent app and a few child apps inside the parent app? On the parent I want to have search functionality with the list of financial forms. And on the child forms have the Edit/View/Edit forms for each financial form/report. To manage all forms we need more easily.
Is there a way to make this function as an automatic cloud flow rather than having to manually trigger it? I have a yes/no dropdown column and would love to send the email when that is marked yes rather than mark yes, then go into Power Automate to run the flow.
I am not seeing the note(annotation) option, even if I only choose annotation it aske me for a relationship and unable to choose one or create a new one.
Thanks for this video Question. This work just for 1 PBI report. What can I do having several PBI reports? All PBI reports are connected to the same data source/Server location and I need to change it to a new Server location. Is there a way to change all data source across all PBI reports rather than open and do it one by one? Thanks
This is a great video. One thing I’m struggling with is finding the custom text columns from Project in PowerBI. I’ve searched all the available tables -and I can’t find them! Have you got any ideas which table they’re in?
Hi @austinlibal I dont know if you are still answering questions here. I have followed the video and doing every step with you. But when I came to the step were you go from get metadata -> filter -> to foreach1 and then invoke pipeline, when I click on run, I get this error: Activity failed because an inner activity failed; Inner activity name: Invoke pipeline1, Error: Operation on target Copy data1 failed: Lakehouse table name should only contain letters, numbers, and underscores. The name must also be no more than 256 characters long. I cant find any answers on how to solve this issue.
Thanks for this as this is what I really needed to connect to an Azure SQL database. One question though, I would imagine from the SQL side, I still need to configure Firewall settings within Azure so I can authenticate to the SQL. Are there any specific setting about Dataverse I need to be aware of so this can be configured within the Firewall?
Can you release a video on how to design a Power Automate daily schedule email notification with a html table showing title, modification date and link to documents added or modified in SharePoint? (one email with list of all documents added/amended)
Hi Austin, what should I do if I am getting this error message -- TypeError: Cannot read properties of undefined (reading 'toResource') -- when trying to connect to a lakehouse (workspace) through the data pipeline process you have in the video. I don't have the Lakehouse in the list. thanks