Youtube comments of (@PragmaticWorks).

  1. Agreed. We will keep micromanaging until morale improves :).
    30
  2. 🔗 StudentTestingData - raw.githubusercontent.com/PragmaticWorksTraining/Datasets/main/Education/StudentTestingData.csv (File referenced at 00:35:58) 🔗 StudentData - raw.githubusercontent.com/PragmaticWorksTraining/Datasets/main/Education/StudentData.csv (File referenced at 01:19:26) 🔗 Class Files - https://prag.works/2024-power-bi-beginner-to-pro-files 📃 Certificate - https://prag.works/power-bi-beginner-to-pro-2024-certificate ✅ Survey - https://prag.works/power-bi-beginner-to-pro-survey 📚 Power BI Cheat Sheet - https://pragmaticworks.com/resources/cheat-sheet/power-bi 📺 On-Demand Free Plan- https://prag.works/power-bi-beginner-to-pro-free-plan
    26
  3. I imagine the reason much of this exists is for what @ctCJ is saying in the comments. it's for things like legal discovery if something goes sideways. I'm curious how many employers actually use these reports for things outside of that reason. That said, maybe I'm naive as I don't have time to look at this as a boss. -Brian
    15
  4. Thanks for making our day with your comments. You're why we do it.
    13
  5. 🔗 Student Files - https://prag.works/data-modeling-files 📃 Certificate of Completion - https://prag.works/data-modeling-certificate 📚 Power BI Cheat Sheet - https://pragmaticworks.com/resources/cheat-sheet/power-bi 📺 On-Demand Free Plan - https://prag.works/data-modeling-free-plan ✅ Survey - https://prag.works/10/24/survey
    11
  6. It is not possible to recover deleted chats in Teams for users. Deleted chat or channel messages cannot be restored directly. If you have a compliance retention policy or legal hold in place for Teams messages, an administrator can recover these from the Compliance center via eDiscovery search.
    7
  7. It will all be here on youtube!
    7
  8. I doubt Google or the other providers aren't any better.
    7
  9. Thanks Tow Hee, so glad you enjoyed it!
    6
  10. Good point! I'll make that one of my next ones. That one is especially confusing at first :). Just have to get drunk enough to make it all clear.
    5
  11. You bet! I have to wrap up the DLP one Friday and then COE is next week. - Brian
    5
  12. Wow, thank you!
    5
  13. Hey Antonio, Pipelines are used for orchestration purposes whereas data flows are used for performing data transformations and applying business rules to your data. In a pipeline you can copy data, move files, get work that needs to be done, executed stored procedures but pipelines are not really designed to easily do data cleansing and preparation. Data Flows provide an easy way to perform data transformations through the user interface.
    5
  14. It looks like Microsoft removed it from their store but we have a copy you can download here: https://file.ac/QIDJnL6igK0/ImgViewerVisual.0.1.0.pbiviz
    4
  15. Now that's an interesting thought. GDPR is for customer privacy but I wouldn't think it would apply if you're employed by a company. That said, I'm an American and don't know all the minutia of GDPR beyond what we have to do to support it with our customers.
    4
  16. Oh sure, I can work on one of those in the next few weeks. If you're storing any additional metadata about a Role for example in the meeting, two traditional 1:m with a joiner table would be the way.
    4
  17. Actually, on second thought, I forgot you can actually get the Response LInk field from the approval to give the user a direct link after the fact. This can be accessed by breaking your approval up into a Start Approval and Wait for Approval actions.
    4
  18. Great question! I've actually made another YouTube video that covers this exact topic 😀! https://youtu.be/UFwJbiXNFZ0
    4
  19. If you use a Power App Portal with a canvas app, everyone would need a license to see the canvas app, even if it were a free Office 365 license. So it likely wouldn't be practical to host the canvas app for anonymous users but it would be for internal users or partners-- Brian
    4
  20. Hey Gayan, that is a very broad question and it depends on what you're trying to accomplish. If you are trying to move data from your on-prem environment to Azure through Data Factory or Synapse pipelines then you can just use the self-hosted integration runtime. Thanks.
    4
  21. LOL. Allen I'm from the south. I mispronounce quite a few words. Just don't ask me to pronounce GIF. :) - Brian
    4
  22. This is pre-recorded and delivered as a premiere in YouTube so we can have higher quality!
    4
  23. I don't think that's possible unless they have developed malware to do so, which breaches all sorts of ethics and legality issues.
    4
  24. We are glad you liked, Sana. That means a lot to us.
    4
  25. Devin is constantly working on pronouncing it correctly. :)
    3
  26. They have recently removed it but we have a copy you can download: https://file.ac/WxkeUehjelM/DialGauge.1.0.1.pbiviz
    3
  27. Yep! Parallels is mentioned in this video here: https://youtu.be/qJUgovkG7Uo?si=xkriIsPR7GIwGiNY&t=210
    3
  28. Glad to help!
    3
  29. Thanks for the feedback!
    3
  30. Sure thing. The TEXT function can power that for you. https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text
    3
  31. Glad it was helpful!
    3
  32. Thanks so much for making our day!
    3
  33. Hey Edward, with data modeling it always depends on what your ultimate goal is. Adding the returns information to the sales information would create a "Consolidated" Fact table. Generally, I try to avoid this method. I would prefer to keep the returns table as a separate fact table. The sales and returns information would share a lot of the same conformed dimensions and therefore you could easily drill across and see the sales and returns by item. Hope this helps! -Mitchell Pearson
    3
  34. Hi Darshan, you don't need to watch any pre videos before this one.
    3
  35. Ideally, you would want to have a test SharePoint list and complete stack.
    3
  36. Dev is now an environment type you can choose for developing apps. You can run them here as well as long as they're just for testing. There's a big "Not for Production" banner going across. You can build here though and move to a different environment. The nice thing about dev environments is there's no cost behind them and you can use premium connectors without a charge while you're working. There's also no cost behind Dataverse there.
    3
  37. The Web API uses the same API the the UI uses so it would respect the user-level security.
    3
  38. Who are you referring to when you say "they"?
    3
  39. Great idea Daniel. Will do.
    3
  40. :) Start by turning off the self-service piece: Microsoft 365 Admin Portal > Settings > Services & Add-Ins > User Owned Apps and Services
    3
  41. Thank you for the suggestion! The video here https://www.youtube.com/watch?v=J4l34uUqHtw goes over using Copilot to help write DAX if you would like to learn more.
    3
  42. Microsoft does big releases twice a year of Power Apps (Wave 1 and 2) typically and lots of little releases. They're putting a LOT into making the platform more usable and helping with adoption for beginners. I only expect goodness to come :).
    3
  43. Hi Bryan! Thanks for the suggestions! Here is a link to purchase a monthly subscription prag.works/monthly
    3
  44. The new slicer is very similar (if not close to identical to the Chiclet slicer since they are both made by Microsoft). The main difference is that this slicer is now natively in Power BI and you will not need to go out to Appsource to get a custom one like the Chiclet slicer. This is great news for organizations that do not allow custom visual use!
    3
  45. Hi David, I was hoping to do that video as well next but Adi is right that its functionality is limited in a browser and you have to test it within the App on mobile. It does have some nice things though like its simplicity and its ability to easily wire into the OnVisible and closing events automatically.
    3
  46. Sure, you would import them into contacts through the Common Data Services Import. Then use something like a Power Automate flow to kick off an invitation for each person to login. - Brian
    3
  47. Thank you both for the feedback! We're working with some new editors and we asked them to up our game. In the process, we went too far it seems :)
    3
  48. Thanks Douglas! Glad your money is well spent! :) -Mitchell Pearson
    3
  49. You made our day!
    3
  50. Yes, we're still adding it to the rest of the site. I jumped the gun and pre-announced ahead of our marketing team :).
    3
  51. You're very welcome!
    3
  52. Hey Michael, you are correct, it would return an older date if you did not have sales on your last working date. If this were your situation you could definitely come up with other ways to handle this, like maybe storing working days vs. non working days in your date table and using that to create this calculated column.
    3
  53. It's included when you license Power Apps but you can also license it separately. Each user you license includes either 50 or 250MB of space based on the license you purchase.
    3
  54. Yes, fees apply for each retake attempt.
    3
  55. Creating a 4-4-5 fiscal calendar is something you would do in your data model. This particular visual just displays a traditional calendar. Misael, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    3
  56. Is it just that the upload button doesn't show up?
    3
  57. Yes!
    3
  58. Well that wouldn't be with any MS tool if that's the case. There are some monitoring tools that might be able to do it though. You can tell by going to your task manager to see if there are any odd apps running. The new co-pilot PCs might change that once they implement the timeline feature but that's on hold due to privacy concerns.
    3
  59. Everything I showed here wouldn't matter what OS you're on. Digital footprint is in the cloud, whether on a Mac or PC.
    3
  60. Bradd, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://success.pragmaticworks.com/ondemandlearning-free-trial
    3
  61. You can have two measures but it only allows one as a bar chart and one as a heat map.
    2
  62. Seems like something occurring locally on your machine that is causing the problem if the same problem occurs on the filled map. Perhaps try to send me your file and I can try it on mine. dknight@pragmaticworks.com
    2
  63. You're very welcome!
    2
  64. Thanks. We are glad to hear that you liked the video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our 7-day FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    2
  65. We've made it more generic since then and are building an accelerator. We haven't packaged it for download yet but we're almost complete with it. Feel free to reach out to me for more info bknight<at> pragmaticworks.com
    2
  66. You can make it a private portal where only certainly people with an invite are allowed to enroll. You can also restrict what IPs are allowed to even see the portal. Hopefully that solves it for you.
    2
  67. Typically a DBA or the Dynamics Developer or PowerApps developers.
    2
  68. You're welcome!
    2
  69. Great idea. I'll do that one this week.
    2
  70. Yes, that comes down to security. Checkout this video https://www.youtube.com/watch?v=FMv-Mbmz9o4&t=11s which shows you how to get over that. It's Table Permissions is what to fast forward to.
    2
  71. If I understand your questions correctly, yes you can collect on start of the application. The only worry is it might be stale data when there are multiple people using the app. Since you're in SharePoint, double-check for delegation warnings to see if that's causing your slow down.
    2
  72. Not yet but it's likely on the roadmap.
    2
  73. Thanks so much! Please subscribe to view more content like this one :)
    2
  74. Thanks! Glad you enjoyed.
    2
  75. Glad it was helpful!
    2
  76. There is a Power Platform Admin connector that might be able to do this but I haven't tried that before. If these users are in an AD group, it might be easier to do in a few clicks instead. .
    2
  77. There are other controls you can download to convert it instead to a drop-down box instead of a search that should fulfill the requirement.
    2
  78. Right now, full support of this feature is with SQL Server, Excel and SharePoint. Others are coming. You can u se Virtual Tables for Custom Connectors likely though.
    2
  79. I appreciate that!
    2
  80. If you're using a Patch, you would just have to place your variable setting around the patch syntax and then do an IfEmpty check to ensure it received a value.
    2
  81. Hi Jaclyn. Unfortunately Power BI dataflows are still pretty new so there are several things you will find SSIS can still do that isn't available in Power BI yet.
    2
  82. Hi! Because the data and the actual report are still securely housed in the Power BI Service, if you are presenting and do not have internet, you will not be able to click into the report to show any cross-filtering or cross-highlighting. Thanks for watching!
    2
  83. Glad you enjoyed it!
    2
  84. Make sure at the environment-level that TDS is turned on. You can do that in the Admin Center under environment features.
    2
  85. Great idea! 💡I added it to my queue - Brian
    2
  86. That's the plan! Thank you!
    2
  87. Thank you!!
    2
  88. Glad we could help!
    2
  89. No problem! Thank you for watching!
    2
  90. Hi there, it's no longer necessary to open the classic mode.
    2
  91. You can add a smart narrative visual to a drill through page or a tooltip page and it will adjust accordingly based on the visuals you have placed on your drill through or tooltip page. We recommend adding your other visuals first to the pages, then adding the smart narrative visual at the end. If you try to add the narrative as your first visual it will say the smart narrative visual doesn’t support any visuals on the page (since there are not any) so you won’t see any results.
    2
  92. I am not sure if you know, but we are offering a 1-day FREE "Understanding DAX Concepts with Power BI" event on October 8 from 11am-2pm EST. If you would like to learn how to create effective DAX formulas that will help you get the most out of your Power BI data, please visit: http://learnwiththenerds.com/
    2
  93. Thank you. Our Azure Every Day series has over 300 videos covering Azure Data Factory and Power BI along with many other topics. Be sure to check out the Azure Every Day playlist on our YouTube channel. You can also follow our Pragmatic Works blog http://blog.pragmaticworks.com/
    2
  94. With some additional prep it's the starting point. During the trial window check out the PL-300 class we have on our on-demand platform and CertXP to practice before going into the test.
    2
  95. You bet @Jason! - Brian
    2
  96. Dataflows currently uses the Import method. When you connect to Dataflows from within Power BI Desktop you don’t get the option like with other sources, but I did find a an idea that is requesting they add a DirectQuery option which you can vote on here.
    2
  97. You're very welcome!
    2
  98. Hi Zain, we got the date from: https://www.kaggle.com/kingburrito666/shakespeare-plays
    2
  99. That's a great question! There is some awesome conditional logic you can bring into a pipeline to only run activities upon the success or failure of other activities using precedent constraints. You can also use the expression builder in pipelines and utilize the outputs of activities that are further upstream in a pipeline. Those are two ways that you can automate your ETL and run large loads in one batch sequentially. For this specific instance though there was an error that needed to be corrected in order to rerun from the failed activity. Once a pipeline run fails you need to manually correct that issue before it can be rerun. Therefore, there would not be a great way to automate this specific process using that feature from the Monitor Hub.
    2
  100. Great questions @David. 1. If you're buildinig a dataverse solution, you can't join into a SQL Server table without replicating all the data. For example, you might want to create a Power App Portal and reference some of your existing tables as a lookup source. That can't be done without doublilng your tables. I see this scenario mostly with schools, hospitals and manufactoring sectors where we're having to replicate all the tables in dataverse. 2. Yes, it will work for a PA Portal, which really opens things up. Thanks for the question - Brian
    2
  101. More videos featuring him will be uploaded to the channel soon! You can also find his courses on our On-Demand Learning at https://pragmaticworks.com/pricing/
    2
  102. You're very welcome!
    2
  103. Glad I could help
    2
  104. Unfortunately, that has to be done via CSS alterations in the STyle tab.
    2
  105. Good idea!
    2
  106. You can do dataverse security roles on top of the table but that said, this will honor any security for any account it's logging in as.
    2
  107. YouTube will sometimes change URLs when you right click and copy them. Try instead to highlight the text of the URL and do CTRL + C to copy it then paste into Power BI.
    2
  108. Papa, we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    2
  109.  @papachoudhary5482  Thanks!
    2
  110. Hello Humair, Thank you for taking the time to watch the video and commenting to us. This presentation really was meant for focus on the design patterns uses within SSIS to manage dimension tables. It also is meant to showcase the features available within SSIS, the setup was done ahead of time and not provided for the webinar. What I would recommend is looking into our On-Demand Learning platform and checking out our Introduction to SSIS class which covers this concept in depth and has you build out the tables so you can run through the example. We as well cover more items in our Advanced SSIS class. Please let us know if you have any questions about our platform. This is the link for our On-Demand Learning courses free trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    2
  111. Yes! Every Tuesday! :)
    2
  112. Thanks so much! Glad people are using it! Ou of curiosity, how's our Hindi?? Hopefully it's not terrible!
    2
  113. We are glad to hear that. Nono, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    2
  114. Thank you!
    2
  115. Glad you enjoyed!
    2
  116. An alternative design could be to ship the contents of the gallery Gallery1.AllItems to a Flow to have it do the heavy lifting of going to the DB if you're trying to make 10k alterations in bulk. If you're trying to do an Upsert, you'll likely want to land the data into a temp table and use Merge to reconcile the changes.
    2
  117. To do that, you'll need to use JScript. I made a vid about how to do that here: https://www.youtube.com/watch?v=XKkyNgByqf4
    2
  118. Yes, the AI builder trial is more at a Tennant level, not environment level so your trial is only 30 days :(
    2
  119. Ah good point on the title. Yes, this is assuming you have AD sync with Azure. I'll change the title to be clearer too :)
    2
  120. Glad you like them!
    2
  121. I don't want to make any announcements for MS, but the groundwork for that has been entering the product (PCF) over the past 6 months and I think you'll be happy soon :).
    2
  122. For this in particular app, we use Power Automate for approvals and store the data in SQL Server for reporting. -Brian
    2
  123.  @bristol0397  Totally possible This one had 60 questions. The key is to make sure you pre-fill the inspection from yesterday's answers so you only answer the stuff that's different.
    2
  124. Hey @TammyToast! You could definitely do this in DAX, but we always recommend using Power Query Editor whenever possible as this is a best practice for creating tables or columns. This date table is Dynamic because anytime the report is refreshed either manually or automatically, the date table will be updated based on that M Code! - Mitchell Pearson
    2
  125. Glad it was helpful!
    2
  126. If you're using the Dynamics flavor of Project, then yes. It stores its data in Dataverse.
    2
  127. I agree. Right now, the managed solution optionis more about locking down the entities and not the applications, which breaks a lot of the ALM processes.
    2
  128. Yes, this is done with an Advanced Form, which is the next video in the series :). Good timing!
    2
  129. Yes, you can. If you log it into the solution, it will transport as well.
    2
  130. Each per app license gives you 50MB of Dataverse space allocated to the overall tenant, regardless of the environment. Ideally, yes, you should move those critical apps out of the default environment and into a prod environment though but that's a separate reason. -Brian
    2
  131. I personally use Power Automate to do that heavy lifting with a Relate Rows action in dataverse.
    2
  132. Glad it helped!
    2
  133. Thanks for the nice words, Kwame. We are glad to hear that you liked the video.
    2
  134. In case you don't know, we offer many On-Demand Learning courses, such as, Power BI, SSRS, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    2
  135. Thanks Papa!
    2
  136. Pages is the new option now that Power Pages is out. You might want to try the Power Page series instead. Exact same demos just against the newer platform.
    2
  137. LOL. Not sure if that's a good thing.
    2
  138. Thanks for the visit
    2
  139. It comes down to cost vs ease in many cases. SharePoint cost and Azure Blob Storage is much cheaper than Dataverse space. For ease of use, the dataverse is easier but Sharepoint makes those files a bit more discoverable where all the files are in a central easy to manage place. So, like any good ex-consultant the answer is "it depends" :). - Brian
    2
  140. Hello there! Thanks for taking the time to watch the video and comment. The main thing is understanding the architecture of the Power BI service and how the Data Gateway fits in when it comes to either DirectQuery or Live Connection. More specifically Live Connection needs the Data Gateway in order to communicate between the reports and that Analysis Services instance. When you define the Live Connection source in the Data Gateway this should be an Admin account for the Analysis services instance so that it can impersonate the user consuming the report and enforce and row-level-security that may be in place. Even though this is a Live source we need someway for the report to communicate to the server to pass the data over. Here is a link to a follow up video that Adam did explain this: https://www.youtube.com/watch?time_continue=91&v=Qb5EEjkHoLg&feature=emb_logo. Hope this helps!
    2
  141. Sure David. You would allow for multiple sessions at the Web Form (Advanced Form) level in the first screen config.
    2
  142. Sure thing. That video is already made here in a series of 8 vids: https://youtu.be/RiF--czZ7LM
    2
  143. Glad you enjoyed it!
    2
  144. My bad! Realized that afterwards but recording boo-boo :).
    2
  145. Absolutely can be done.
    2
  146. Thanks SashiKiran we added that to our list to do in the next 2 videos. Our next one is on data shaping, which will include a bit of M. Then DAX is right behind that.
    2
  147. Since making this video, the interface app will now give you the option to specify who is allowed to use the pipelines you created. These are using the Pipeline security roles like what you mentioned, so much easier to config. In addition, the solution artifacts are stored forever until you purge them. You can create a Dataverse purge process to remove old artifacts if you wish though.
    2
  148. Great question! Yes it does! It doesn't star it out but blanks it out if you don't have permission. You can then change to whatever masking you wish.
    2
  149. It's essentially a SQL Server database so you could connect to it like SQL (if that's enabled) or the API for full read/write.
    2
  150. Correct, if your app uses Dataverse, even through a virtual table, you would need a license. That said, if you're using a canvas app, why not go directly to SharePoint and bypass that.
    2
  151. Not yet but the plumbing is now in place to make that happen (very soon likey).
    2
  152. Glad you enjoyed!
    2
  153. You can integrate CDS as a source for Power BI as well. :)
    2
  154. Glad it was helpful!
    2
  155. Starting to film this week that series :)
    2
  156. Awesome, thank you!
    2
  157. Thanks. That means a lot to us. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    2
  158. Sure, you can purge that cached settings by going to File --> Options and Settings then Data Source Settings. Then purge whatever connection you want to kill. -Brian
    2
  159. Sounds like you've become a Power Automate ninja! Just remember, with great speed comes great responsibility... to automate wisely!
    2
  160. Thank you for your kind words! Your are very welcome.
    2
  161. Thanks Lucas, first, I don't totally disagree 😊. On point 2, only users with the proper permissions in a workspace can download the PBIX, so that typically isn't an issue. The issue comes after the download occurs because the PBIX has no security on it and we, as an organization, have no visibility now on where or how that information is used by the person who downloaded the file. So if that file, with very important information is downloaded and shared through email or onedrive, not only is there a security breach, we also don't even know it's happening since it's outside the Power BI Service. Point 3, analyze in excel, was regarding object level security specifically. If object level security has not been set up or not properly setup, then once in excel users may see data the developer did not want them to see. Agreeing with your point, as an organization, this comes down to a governance failure further up the line. However, in large organizations where self-service BI has gained a lot of adoption, this is extremely difficult to manage and oversee due to the number of data models being created and shared, so in that situation, disabling analyze in excel is a high level way to manage this. Of course, giving someone build permissions also gives them access to see all the objects if object level security has not been properly implemented, so that is a concern also!
    2
  162. Welcome!
    2
  163. Yes it can do it but not the best use of it likely. I'd lean more towards Wordpress at that point.
    2
  164. I wish I can say I haven't done that but been there countless times.
    2
  165. Yes, this session is at 11:00 AM EST today
    2
  166. Download the student files for today: https://prag.works/data-modeling-files
    2
  167. Glad you enjoyed!
    2
  168. Yeah, that was embarrassing after I found that in the recording. I thought that pipe | was my cursor and had a blind spot :).
    2
  169. Thanks for watching!
    2
  170. Yes, all of that is delegated to your SQL Server or SharePoint system. Dataverse maintains just that you have access or don't.
    2
  171. That's awesome, appreciate the positive feedback! We try to rerecord the classes quite often to keep them up to date with changes so a lot of time classes I recorded originally have been rerecorded by someone else on the team who was available to update the course :) Thanks again! -Mitchell
    2
  172. You will need the basic Power Automate license included with your Microsoft subscription to run.
    2
  173. Unfortunately, to move this, you'd have to venture outside the realm of standard forms and potentially use Liquid. Another option is to use a File Data type, which is now supported. You could put that wherever you want on the form.
    2
  174. We are glad to hear that you liked the video.
    2
  175. Thanks for watching!
    2
  176. Anyone using CDS does require a P1 license or a per user basis.
    2
  177. Hello, Unfortunately data flows can not be executed on self-hosted IR. However, you can use the managed VNET option in the Azure IR in order to open up data flows to data stores inside VNETs or on prem. I will include some Microsoft documentation on how to set that up as well as a YouTube video from one of our head trainers Mitchell that will hopefully better explain that process for you. Documentation: https://learn.microsoft.com/en-us/azure/data-factory/managed-virtual-network-private-endpoint YouTube: https://www.youtube.com/watch?v=TkLT4HWd558 Hopefully this helps!
    2
  178. Out now! :) Check out our page for the playlist!
    2
  179. Thank you for your interest in Pragmatic Works. The paid version includes much more content.
    2
  180. As of right now, the patch command can not update attachments. To accomplish deleting an attachment on a record you would have to edit the record in a form and remove the attachment from the form
    2
  181. Hi Daniel Thanks for your comment. We have just started this series but we will be releasing new Azure content every weekday. The best way to stay up-to-date is to subscribe to our YouTube channel and blog: http://blog.pragmaticworks.com/
    2
  182. One small correction: For the TemplateFill property, use this code to fix the jumpiness change it accordingly for your own component name (Component1) and field name (ScreenControl) If(ThisItem.ScreenControl=App.ActiveScreen, ColorFade(Component1.Fill,.4), Component1.Fill)
    2
  183. Great news! We are thrilled to be a part of your learning journey. 👨‍💻👩‍💻
    2
  184. Glad it was helpful!
    2
  185. The data from Power BI that is added to your PowerPoint using the Power BI add-in will stay in Power BI. There is no data that is exported from Power BI. This means that all of the data will follow Power BI permissions and data security. This also includes row-level security or RLS. Hope this helps!
    2
  186. Hi Erik, at the moment there is not but I would let the company that developed it know. – Hitachi Solutions.
    2
  187. Sure thing. One and the same. I spent the bulk of my career in SSIS/data but had to pivot after we sold the software product to Sentry One.
    2
  188. There was a visual that could do this called Filter by List but unfortunately it looks like it's no longer available. Here's a video we did when it was available. https://www.youtube.com/watch?v=GdJS25F2Xx8&t=118s
    2
  189. Hi Sandeep, you can watch our Nov 20 Power Bi updates from the link below - https://www.youtube.com/watch?v=_5hoI4dCV4k&feature=youtu.be
    2
  190. I appreciate that!
    2
  191. Depends on what you want from the account record. If you just want the Account ID, you'll find that in the contact Record. Try the parentcustomerid column, which stores the Account ID for a given Contact.
    2
  192. Glad it was helpful!
    2
  193. Thanks so much! Glad you enjoyed!
    2
  194. That's good to hear. We are here to help!
    2
  195. Glad you enjoyed!
    2
  196. Very true! Glad it was helpful!
    2
  197. The destination will take care of it and will only ever present one solution. At the source though, you'd see all the patches.
    2
  198. It is coming. They have to first support PCF components in Portals to host that File data type. The plumbing for the first step is coming very soon I believe.
    2
  199. No problem! Thanks for watching!
    2
  200. Thanks for making our day.
    2
  201. It's licensed by packs of views for anonymous users and logins. You don't have to name each external user outside of your organization that logs in. You're buying the capacity of those logins.
    2
  202. Sure, here's one I did about 6 months ago: https://www.youtube.com/watch?v=2EXSdJw1TEY
    2
  203. Entity lists are similar to data repeaters. You can also filter those lists. You can also use the Liquid language to target a single record to show it however you want.
    2
  204. Hi Jefferson, you can go to File --> App Settings to set a different mode there.
    2
  205. ​ @HarishKumar-cg7en ... we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg There... you will find very structured courses designed for this purpose. Hope this helps. Thanks!
    2
  206. Hi Jay, yes you can do that but it's not meant for production. The Portal will expire 30 days later and you'll have to drop and recreate it then. After you recreate it, it will keep all the settings and pages you created.
    2
  207. Here's a video comparing the different Project Plans https://youtu.be/q7w33bMBe20
    2
  208. Hi there. Here is a template to hopefully get you in the right direction. On your get items step for the Filter Query you would do something like the following. closeDate eq null and creationDate eq addDays(utcNow,-2,'MM/dd/yyyy') What I wrote in parentheses would be written in the expression builder and after you add it to the filter query input you would want to wrap single tick marks around it like 'Expression' Hope this helps.
    2
  209. You can use the Launch command and use TEL:55555555 to use the user's cell phone or soft phone.
    2
  210. This part was mentioned as optional and not needed to continue. There was no data pasted here but instead a bit of DAX code to potentially clean up the results. You can rewind a few seconds and see the before and after but again this is not needed to continue.
    2
  211. Thanks for watching!
    2
  212. Thanks! We are happy yo hear that. Sushmit, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    2
  213. LOL, I had forgotten about that one 😀 -Mitchell Pearson
    2
  214. Totally understand! We're already started ramping that back going forward but we had some videos like this one that were already scheduled. We agree!
    2
  215. Yeah, that's preferred if they're sharing data, just make sure you don't deploy important production apps to default environment.
    2
  216. Hi Troy, the learning curve really comes into play with security and some of the enterprise management. Besides that, it's very easy to learn I thought. BUT, I already had experience with CDS and model-driven apps so this was just an extension of that knowledge.
    2
  217. Hi Perry. That table in particular is a Linked table using a provider that might not be supported for SQL actions. Not 100% but I can replicate your issue too.
    2
  218. So anyone that opens your app will need a license. You can pick and choose though. For example, you can be licensed for the unlimited app plan as you're building a bunch of them. Your user though could be licensed by app since they only need one.
    2
  219. Coming soon! Thank you for watching!
    2
  220. Glad you like them!
    2
  221. Wow, thank you!
    2
  222. Wow, I love the idea of using Relative Data filters here, in fact... that will probably be one of my next videos! The only possible draw back with a relative date filter is when files aren't uploaded on time or on the correct date. Either way, this is a great suggestion! -Mitchell Pearson
    2
  223. Thank you!
    2
  224. Your app can ask for more but it goes through more FaceBook scrutiny and review at that point. .
    2
  225. On published reports the alt text will be read as a user navigates the report via the screen reader. But it can be viewed after pressing "edit".
    2
  226. Unfortunately, that person no longer works here and I don't know where the file is, sorry. I am not sure if you know, but we offer many On-Demand Learning courses, such as, SQL Server, Power BI, Azure, Data Science, Business Intelligence and much more. I think it will be very helpful. You should check out our FREE trial: https://success.pragmaticworks.com/ondemandlearning-free-trial
    2
  227. Great observation, will this be dynamic and always load the most recent file each time you refresh? I just clicked binary to test this out and it looks like it hardcodes the name of the current file.... But I am going to further test this! Thanks for following us and contributing to the video! - Mitchell Pearson
    2
  228.  @xMastJedi  Ah yes, grab the first item in the array. I like it! Thanks for sharing your solution! -Mitchell Pearson
    2
  229. Is the reader screen available? Keep in mind for the edit to work, you'll need to have db_datareader and db_datawriter rights or DBO.
    2
  230. Absolutely! Thanks for watching!
    2
  231. Hi Kay, thanks! The focus of the video is how to use the Database Migration Assistant. The latest version of the DMA tool can be downloaded for free from here. The cost of a migration is variable. It is dependent upon the resources and services needed in Azure to support the database(s), data, and applications being migrated. Additionally, the cost is also dependent upon the amount of data to be migrated and the organizational resources needed to support the migration effort. The Azure Pricing Calculator provides retail pricing of the various services within Azure. The cost going forward is based on the amount of Azure services consumed once the migration is complete. The Azure Resource Manager is a tool available to help manage the billing and cost management of the Azure Services. For large scale migrations, it is recommended that the following steps are taken: Pre-migration • Discover – Inventory your database assets and application stack • Assess – Assess workloads and fix any recommendations • Convert – Convert the source schema to work in the target Azure environment Migration • Migrate – Migrate the source schema, source data and objects to the target. • Sync Data – Sync the target schema and data with the source • Cutover – Cut over from the source to target environment. Post-Migration • Remediate Applications – Iteratively make any necessary changes to your application • Perform Tests – Iteratively run functional and performance tests • Optimize – Based on tests, address any performance issues and then retest to confirm the performance improvements. Thanks again and have a good day.
    2
  232. Hello, when you refresh your data model the dimensions will also be updated automatically. In the demo, we built the dimension tables and fact table from the single excel worksheet, when we refresh the power bi model, it will update all tables that are pulling from that worksheet.
    2
  233. Thank you Patrick, much appreciated! - Mitchell Pearson
    2
  234. Agreed Sharon! The nicest part about the notes part is if you want to append any extra metadata on the record. I think the Sharepoint method is an easier user interface for just bulk uploading files.
    2
  235. Glad to help (:
    2
  236. Yes, absolutely. You can use it on phone, tablet or desktops.
    2
  237. Glad you like them!
    2
  238. Glad it was helpful! Thanks for watching!
    2
  239. We have an entire playlist here: https://www.youtube.com/playlist?list=PLcwrIWK7WBcSYTQYUrtRkopzSKJ4SbYp4 Enjoy!
    2
  240. Thanks!
    2
  241. Glad it helped!
    2
  242. Best of luck!
    2
  243.  @LukaszKobierski  Looking into it now!
    2
  244. Sure, in Power Apps, use the Launch command like Launch(filename) to automatically download it. Hope that helps. -Brian
    2
  245. Thanks so much!
    2
  246. Hi there! That's an optional step. It really depends on if you think you'll need to columns individually or not
    2
  247. Sure, the long answer (8 mins) can be seen in this video. https://www.youtube.com/watch?time_continue=2&v=kX6tSpEftsk&feature=emb_title. The on demand gateway is not part of the Office 365 license for Power Apps is the short answer :). - Brian
    2
  248. One small correction: For the TemplateFill property, use this code to fix the jumpiness change it accordingly for your own component name (Component1) and field name (ScreenControl) If(ThisItem.ScreenControl=App.ActiveScreen, ColorFade(Component1.Fill,.4), Component1.Fill)
    2
  249. Yes, if you store files in SharePoint there are no additional licensing required if that's the question. Only if you use Dataverse/SQL/Premium connections, does it light up that requirement for an additional license.
    2
  250. Thanks! You got this!
    2
  251. It is! Thanks Junaid, thanks for the kind comments. -Mitchell Pearson
    2
  252. Great question! Authors and consumers will need a license of Power Apps in your scenario. If you're using CDS, then yes, everyone will need a pay plan also :(. - Brian
    2
  253. Glad you enjoyed it
    2
  254. We sure did. Here you go https://www.youtube.com/watch?v=ALeQurjn2QE&t=408s Glad you are enjoying the content.
    2
  255. Yes, if you check tables like a parent-child set of tables, it will take care of those relationships also. Thanks!
    2
  256. More coming on Feb 14!
    2
  257. Copilot in Power BI requires Power BI Premium or Fabric F64 capacity on a workspace. It sounds like the message is directing you to upgrade.
    2
  258.  @clairelucey2330  In the Power BI Desktop settings you'll also have to tell it which workspace you're using the F64 Fabric Capacity (make sure it's at least F64 because the lower ones don't include Copilot). You'll find the setting under File > Options and Settings > Options > Copilot. Additionally, there may be some Fabric/Power BI Tenant settings that may need to be adjusted.
    2
  259. Glad it was helpful!
    2
  260. The native scatter plot has a play access already but you can also use the Play Axis to animate anything. https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380981?src=office&tab=Overview
    2
  261. Yes, here's the link to the video: https://www.youtube.com/watch?v=y3D6DRX_XfE&index=11&list=PLcwrIWK7WBcQOIFCFPAIpQpWPBCj5BCab
    2
  262. With the content controls, you can change the Placeholder text by clicking the "Design mode" button. This will show the content controls with tags and the Placeholder text can be edited. The only way to "remove" placeholder text is to format the Placeholder Text style with "hidden". This style is always hidden in the list of styles, so... Click the dialog box launcher of the Styles group in the Home tab. At the bottom of the task pane, click the button at the right. In the "Edit" tab, select "Alphabetical" as the sort order. Look for "Placeholder text" in the list. Click "Modify". Click Format and choose "Font". In the Font dialog box, click the checkbox for "Hidden" until you see a checkmark.
    2
  263. Yes, you can. Suvedha, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    2
  264. If you’re using a live connection, then you create the row level security in your Tabular model instead of Power BI.
    2
  265. What you can do there is you can use something App.Name = ThisItem then change the fill color. I'll create a follow up on that for you.
    2
  266. Hi Barrie, I just added a view in my database and I could not see it so it must not have that functionality yet. This is still in preview and there's a lot more to come.
    2
  267. Glad I could help!
    2
  268. You can get Read/Write by using XRM Toolbox free too also.
    2
  269. Hi Lukasz. Sorry for the glitch there. This new link should work for you. Let us know how it goes if you don't mind and again thanks for your patience. https://tinyurl.com/58t695ej
    2
  270.  @LukaszKobierski  Good to hear! Thanks again for watching!
    2
  271. Thanks for watching!
    2
  272. You bet. You just have to disable it on the form first then it will no longer have that dependency.
    2
  273. Hello Mayank. Thanks for watching the video and taking the time to reach out to us. The quick answer to your question is No. They are not the same but it goes a little deeper. It is not uncommon to use the HASHBYTES function to create a column which can be used as a unique identifier but it has to be setup for that purpose. Remember we choose the columns that will be hashed using a certain algorithm. If the column chosen do not provide unique values for every row then it cannot be used as an Identifier column. So using the HASHBYTE function does not always output a value which can be used as a unique identifier but it CAN if you the user makes the right decisions on which columns to leverage. I hope this helps!
    2
  274.  @mayankchaubey5917 Here is the script for the source: SELECT C.CustomerKey as CustomerAK ,CAST(D.LastName as varchar(100)) as LastName ,CAST(D.FirstName as varchar(100)) as FirstName ,CAST(CO.CompanyName as varchar(500)) as CompanyName ,CAST(D.Address1 as varchar(400)) as Address1 ,CAST(D.Address2 as varchar(400)) as Address2 ,CAST(D.City as varchar(400)) as City ,CAST(D.State as varchar(4)) as State ,CAST(D.PostalCode as varchar(20)) as PostalCode ,CAST(D.WorkPhone as varchar(40)) as WorkPhone ,CAST(D.HomePhone as varchar(40)) as HomePhone ,CAST(D.CellPhone as varchar(40)) as CellPhone ,CAST(D.WorkEmail as varchar(512)) as WorkEmail ,CAST(D.HomeEmail as varchar(512)) as HomeEmail ,CAST(HASHBYTES('SHA1',ISNULL(CAST(D.LastName as varchar(100)), 'UNKNOWN') +' | '+ISNULL(CAST(D.FirstName as varchar(100)), 'UNKNOWN') +' | '+ISNULL(CAST(CO.CompanyName as varchar(500)), 'UNKNOWN') +' | '+ISNULL(CAST(D.Address1 as varchar(400)), 'UNKNOWN') +' | '+ISNULL(CAST(D.Address2 as varchar(400)), 'UNKNOWN') +' | '+ISNULL(CAST(D.City as varchar(400)) , 'UNKNOWN') +' | '+ISNULL(CAST(D.State as varchar(4)), 'UNKNOWN') +' | '+ISNULL(CAST(D.PostalCode as varchar(20)), 'UNKNOWN') +' | '+ISNULL(CAST(D.WorkPhone as varchar(40)), 'UNKNOWN') +' | '+ISNULL(CAST(D.HomePhone as varchar(40)), 'UNKNOWN') +' | '+ISNULL(CAST(D.CellPhone as varchar(40)), 'UNKNOWN') +' | '+ISNULL(CAST(D.WorkEmail as varchar(512)), 'UNKNOWN') +' | '+ISNULL(CAST(D.HomeEmail as varchar(512)), 'UNKNOWN') )as bigint) as Hash_Source FROM [PWInsurance].[People].[Customer] C JOIN People.Detail D ON C.DetailKey = D.DetailKey JOIN People.Company CO ON C.CompanyKey = CO.CompanyKey And this is the script for the lookup query: SELECT CustomerSK as CustomerSK_Destination ,CustomerAK ,CAST(HASHBYTES('SHA1',ISNULL(CAST(LastName as varchar(100)), 'UNKNOWN') +' | '+ISNULL(CAST(FirstName as varchar(100)), 'UNKNOWN') +' | '+ISNULL(CAST(CompanyName as varchar(500)), 'UNKNOWN') +' | '+ISNULL(CAST(Address1 as varchar(400)), 'UNKNOWN') +' | '+ISNULL(CAST(Address2 as varchar(400)), 'UNKNOWN') +' | '+ISNULL(CAST(City as varchar(400)) , 'UNKNOWN') +' | '+ISNULL(CAST(State as varchar(4)), 'UNKNOWN') +' | '+ISNULL(CAST(PostalCode as varchar(20)), 'UNKNOWN') +' | '+ISNULL(CAST(WorkPhone as varchar(40)), 'UNKNOWN') +' | '+ISNULL(CAST(HomePhone as varchar(40)), 'UNKNOWN') +' | '+ISNULL(CAST(CellPhone as varchar(40)), 'UNKNOWN') +' | '+ISNULL(CAST(WorkEmail as varchar(512)), 'UNKNOWN') +' | '+ISNULL(CAST(HomeEmail as varchar(512)), 'UNKNOWN') )as bigint) as Hash_Destination FROM DimCustomer The key thing here as you can see in both queries is that the same columns are used in both queries. The order and amount of columns must be exact or you will get incorrect results and everything will show up as being changes from the source. Hope this helps
    2
  275. Hi Priyanka, you have to point to a URL. Using a file on your local computer won’t work. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. I think its going to be very helpful to you. You should check out our FREE trial here: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg P.S. NO credit card required
    2
  276. Haha, yes, it's definitely not a mistake you make more than once. Thank you for pointing this out and I should have mentioned it in my video if I did not. The time and date dimensions should always be separate tables for the reasons you mentioned! -Mitchell Pearson
    2
  277. Are you referring to Power Apps or Power BI? If Power BI, the alternative solution is Power BI premium, which is going to be much, much more expensive than just licensing the 35 users. https://powerbi.microsoft.com/en-us/pricing/ has the pricing calculator.
    2
  278. I talked to the instructor, and he said to use this: https://github.com/deldersveld/topojson
    2
  279. You're welcome!
    2
  280. Sure, the concept is exactly the same. Your app would just need to point to a SP list instead of a SQL Server table. Only difference is you would use the Sharepoint Item ID. :)
    2
  281. You're very welcome!
    2
  282. You'll find the Power Apps app in the Play store. Once you install it, your app you built will show up after you sign in.
    2
  283. You can! Smartsheet should produce a link that you can then use in the web connector.
    2
  284. Yes, absolutely. You can send them in one approval or stack them.
    2
  285. Of course! Glad you enjoyed! 😊
    2
  286. Thanks for watching! :)
    2
  287. Thank you so much!
    2
  288.  @ChineduOnunkwo  Here you go! https://www.youtube.com/watch?v=qJUgovkG7Uo&t=1s
    2
  289. The 2000 record you're referring to is for delegation (when it can't figure out how to query the system). You're only limitted by the number of rows that are in your system.
    2
  290. Thank you for watching!
    2
  291. Sure that's all logged with the User().Email function.
    2
  292. Hi Hendrik, this would be a local setting for each user. They could set PDFs to open in MS word.
    2
  293. I'm a bit confused by those questions. Like any database with customer personal data, you own the database and you have to abide by your local and national laws around that database. I or MS don't have access to your database. Portals supports HIPPA and GDPR as long as you abide by those restrictions as the host of the data to purge the data yourself upon customer request. You're using the word "you" and I hope you understand that even though I built the solution and give it away, I don't host your customer's data, you do.
    2
  294. Which area in copilot are you in? I'm using images in my searches with prompts like "How to I get to this screen in XXXXX" while uploading a screenshot in areas like copilot in edge.
    2
  295. Glad it was helpful!
    2
  296. Currently, there is not a viable option to remove the copyright overlay due to the copyright requirements. To mitigate it, we usually try and resize the map a bit larger so it is not as impactful. Make sure to comment to the Power BI development team if you want to see that feature changed!
    2
  297. You're very welcome! Thank you for learning with us.
    2
  298. CONGRATS!!! Huge relief when you pass the exam! Glad we could be a part of your journey!
    2
  299. I think so. I've used it for wood pulp for example to see the differences between pine and other various types.
    2
  300. LOL. I'm not sure that's a good thing.
    2
  301. This video on updating data sources in power query should do the trick https://youtu.be/Fd2tU-qull8
    2
  302. Thank Jihwan! Glad you liked it.
    2
  303. Hi Hristo, no in this case it's not bringing any data over. More linking to the table and storing the primary key from the source system in the child table.
    2
  304. Much appreciated!
    2
  305. Sounds like no one has given you permissions to the company environment. You can create a personal environment by going here: https://powerapps.microsoft.com/en-us/communityplan/ and selecting Create Individual Environment. It will take you back to Power Apps and click Refresh after 10 secs or so to see your personal environment. - Brian
    2
  306. I'm writing one for Apress right now. We have a boatload of guided learning classes at https://www.pragmaticworks.com then click Training. That has a free App in a Day class as part of that on demand learning.
    2
  307. Sure, use the IsMatch function. You can find more about that here: https://www.youtube.com/watch?v=vOzvZI6tmzQ
    2
  308.  @Gius3pp3K  C O N G R A T U L A T I O N S ! ! 🎉🎉
    2
  309. Yes, that's correct. As I mentioned in the video, SSMS is at this time, only read only however you can also use XRMToolbox to read/write/delete. This free tool is similar to SSMS but is like a swiss army knife. Once you install the tool, look for SQL4CDS.
    2
  310. Unfortunately not yet. Business rules won't apply to Portals applications. This might come at a later date but good grief, that would make things so much easier!
    2
  311.  @AdiCristea  LOL. I'm sure it's coming but not yet.
    2
  312. Yes, there is a website we use called "Slack" which is basically a forum for discussion about different topics including Databricks, Delta, etc. https://slack.com/help/categories/360000049063?cvosrc=email.email.email_ntws&cvo_creative=&utm_medium=email&utm_source=email&utm_campaign=_email_ctrl_email____ob-_cr-_ym-#role-based-handbooks
    2
  313. Glad it was helpful!
    2
  314. The same technique works for that as well.
    2
  315. No, this property cannot be made dynamic.
    2
  316. Hi Zohar here is the link and it is place in the description above https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/Er8FvbvFYMRLr14rtuaDkjoBAkBo1Iqj4ARS5Nz6oStXUg?e=LVlKpV
    2
  317.  @BijouBakson  Of course, anytime!
    2
  318. I can totally see your point. The part I didn't see at first is the plumbing that comes with the Portals. It includes the database portion, login and row-level security plumbing and a lot more. In the big scheme of things, I could get a VM in the cloud for $50-$300/month based on performance and with this, you pay per 100K views. It's most certainly not for every use case. For a basic website, your logic makes WAY more sense. For a large data infrastructure, this might be a candidate.
    2
  319. The mapping feature that was discussed in this video is a premium feature (must have licensed app) but there are other techniques to do it with Google/Bing without this component. This just makes it a LOT easier.
    2
  320. Hi, thanks for watching this video. You can try this example with our database. The connection information for that is in the description of the video. A common question we have received is why is this feature so important. Previously, you would have to load the table into Dataverse on a periodic basis and the data would be stale. You would also have two copies of your data, one of which is stale. Thanks for watching! - Brian
    2
  321. As always, Thank you! -Mitchell Pearson
    2
  322. You sure could. You would make a bookmark with those filters you want in place applied. The only thing you would need to remember is when setting that bookmark up to uncheck the data section when creating the bookmark.
    2
  323. Adi, we found the issue and resolved it. You should be good to go! Sorry about that.
    2
  324. Notes do not since there's no model-driven app there but File data types are there. Your best bet might be to integrate with SharePoint for file storage though so you don't eat up your 2GB.
    2
  325. Sure, there's a delete file step in Power Automate to kill the temporary file :). Should have done that myself in the video so thanks for bringing it up.
    2
  326. Thank you. Be sure to check out my Part 2 on Data Governance. Hope it's helpful.
    2
  327. Hi there, It's been moved to the top of the screen near the attribute now.
    2
  328. Awesome, thanks for sharing, I definitely missed that!
    2
  329. Try using the class files download in the description instead. It will download a local copy of the files rather then using the web connector.
    2
  330. Wow, thank you!
    2
  331. Hey Adi, in my example I wanted the dates to also appear in the slicer so I could choose the latest working date and I could also choose other dates. To your point, if you only wanted the latest working date and were not going to use it in an interactive way, but simply to filter a report, then you could definitely just go with blank or something like non working date.
    2
  332. I just discovered a slight deviation of what I told you. You can indeed connect to PostgreSQL as well as MariaDB and MySQL. Here is a link to connecting to PostreSQL on premise or in the cloud…https://docs.microsoft.com/en-us/sql/azure-data-studio/quickstart-postgres?view=sql-server-ver15.
    2
  333. For sure.They've simplified the installation of these connectors now too. So you'll just point the connector to your Azure SQL DB or on-prem to do that. For your Web services, you'll need a more traditional virtual connector to OData for those I believe.
    2
  334. Ouch! Well hopefully you can use it going forward! Thanks for watching. -Mitchell Pearson
    2
  335. Hey Oscar, other than notebooks you can also take a look at Azure Functions which are prefect for running small pieces of code similar to script tasks in SSIS. - Mitchell
    2
  336. Hello and thanks for commenting on our video. I have reviewed the video and it is 100% correct and accurate. If you are in the table, on the one side of the relationship, for example a dimension table, related WILL NOT work to return information from the many side of the relationship. Related function only returns a single value and therefore will only work if you are on the many side of the relationship trying to return a single value from the one side. The code examples in the video back up the context provided. Similarly, relatedtable returns a table and therefore, if i'm in a dimension table and want to return a set of related rows from the many side of a relationship, I would use related table, since it can and will return a table expression. - Mitchell Pearson
    2
  337. ​ @statesman6379  Technically Yes, you can use RELATEDTABLE on either side... but relatedtable is more complex to work with because now you have a table expression and you need to perform an operation on that table to return a scalar value. In contrast, the related function will return a scalar value by default and will not require further manipulation and therefore if you are returning a single value from the one side of the relationship RELATED would be ideal. In the video, I probably use a sumx or equivalent type function on top of relatedtable to return a scalar value.
    2
  338. We are glad to help
    2
  339. Sure thing: Here's one I've done: https://www.youtube.com/watch?v=Dv_mGWwCiLU
    2
  340. Thanks Brad! -Mitchell
    2
  341. Hi. Unfortunately, We do not have it but I believe he references the sources in the recording. Please let us know if we can help further.
    1
  342. Paul, don't forget you can watch the full video on our website at http://pragmaticworks.com/Training/FreeTraining/ViewWebinar/WebinarID/514 Glad you enjoyed the video.
    1
  343. The feature is currently still in preview. You can learn more about it here: https://powerbi.microsoft.com/en-us/blog/integrate-power-bi-reports-in-sharepoint-online/
    1
  344. Unfortunately, it only accepts date fields.
    1
  345. There actually is data represented for them but the value is so low it's difficult to see. Because there's only 1 year of the LA Rams the summed up values are easily compared to the other teams for all years.
    1
  346. John Norris, SmartGuyLBC I am providing you with the direct link to the video on our website.  We look forward to seeing you in the next webinar.  @Training/FreeTraining/ViewWebinar/WebinarID/1717
    1
  347. I'm sorry you are having difficulty in viewing the video.  Please contact our support department so we can fully investigate what is going on and get some additional information from you.  You can email us at support@pragmaticworks.com
    1
  348. You should be able to find everything here: http://blog.pragmaticworks.com/power-bi-custom-visuals-kpi-indicator
    1
  349. Hi Irfan. Is there anything we can help you with?
    1
  350. You can find everything here: http://blog.pragmaticworks.com/power-bi-custom-visuals-globe-map
    1
  351. Is the date column stored as a true datetime value or is it text?
    1
  352. I think it was intentionally designed this way but this is a nice little hack for when you don’t want to drill to a lower report.
    1
  353. Unfortunately, that option is not available.
    1
  354. Not currently but it is coming soon.
    1
  355. It doesn't appear there is a way at this time.
    1
  356. Hi! You would have to schedule a data refresh through the Power BI Service to get those updates. Please let us know if we can help further.
    1
  357. Hi. Unfortunately, that doesn't exist yet but we suggest submitting your idea here: https://ideas.powerbi.com/forums/265200-power-bi-ideas
    1
  358. Is your text the same color as the scroller?
    1
  359. Hi. Unfortunately, there is nothing like this in Power BI.
    1
  360. Generally, this is something you would have in your dataset. It would define the thresholds for each value of Good/Bad.
    1
  361. Thank you, we appreciate the comment!
    1
  362. ​ @pedrin.p , We are glad the video was helpful! I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  363.  @toulasantha  Glad to help!
    1
  364. Yes, this solution uses Dataverse to store all the related data. As far as tracking the location of the item, there is a Many-to-one relationship between the “Asset Allocation” table and the “Asset Item” Table….. when a record is added to “Asset Allocation”, it goes into the parent record (“Asset Item”), and marks it unavailable….. once the Asset Allocation record is marked as returned, the Parent “Asset item” is switched back to Available!
    1
  365. You don't see the Solutions section at https://make.powerapps.com on the left?
    1
  366. What's not working for you?
    1
  367. Glad it was helpful!
    1
  368. So glad it could help!
    1
  369. I have another video in the play list that covers that: Hope this helps: https://www.youtube.com/watch?v=EsUlwBfqe68
    1
  370. Thank you! And thank you for learning with us!
    1
  371. Great to hear! Thanks for letting us know and making my day Adam - Brian.
    1
  372. No unfortunately, only a Dataverse feature baked in.
    1
  373. Glad you enjoyed!
    1
  374. Thank you so much 😀
    1
  375. You're welcome! Glad you enjoyed!
    1
  376. Happy to help!
    1
  377. Thank you too!
    1
  378. Sure, the the advanced properties of the form, there is an Attach File checkbox.
    1
  379. Our pleasure!
    1
  380. Many many thanks
    1
  381. Most welcome!
    1
  382. Thanks, will do!
    1
  383. Those Teams environments are more personal or small team by nature and don't kill your overall DV space. So you can be a little more siloed on those.
    1
  384. When you create the app, you specify the type of app you want to build - Brian
    1
  385. Great to hear! Thanks for watching!
    1
  386. This is high praise! Thank you for sharing (:
    1
  387. You're welcome!
    1
  388. Glad you think so!
    1
  389. I there. This vid should help you as it shows this : https://www.youtube.com/watch?v=8zCcIQ_gpB8&t=1s
    1
  390. Thanks for watching!
    1
  391. Unfortunately, it is no longer available but we do have a wide variety of free recordings here: http://pragmaticworks.com/Training/Courses#type=Free
    1
  392. Glad it helped!
    1
  393. Thanks!
    1
  394. Thank you! We are glad it was helpful for you.
    1
  395. You can absolutely do that as well.
    1
  396. Glad it was helpful! Thanks for learning with us!
    1
  397. Hi there, the same rules apply to these lookups that do to them in model-driven apps. Your best way to implement this though is to create a table and join them that way with a subgrid. Similar to a relationship between what classes a student is taking, it's a many to many relationship. These M2M relationships can be done automatically.
    1
  398. You're welcome!
    1
  399. Thanks!
    1
  400. You can set that in the inline CSS in the HTML. I would typically create a parameter to pass in so the using developer can set that also.
    1
  401. Our pleasure!
    1
  402. You're welcome (:
    1
  403. Will do!
    1
  404. Glad you liked it!
    1
  405. Thanks for watching!
    1
  406. Glad it helped!
    1
  407. Thank you for your kind words!
    1
  408. Would you want to use it to backup Dataverse? In that example, it's done automatically for you. If you're looking at it to backup SQL Server or similar platforms, there would be less expensive alternatives.
    1
  409. Glad you enjoyed!
    1
  410. Thanks for watching!
    1
  411. Sure, I can focus on that next week.
    1
  412. Welcome
    1
  413. Glad you enjoyed it
    1
  414. Glad it was helpful!
    1
  415. You are welcome!
    1
  416. You're so welcome!
    1
  417. Creating a distribution list directly using the Microsoft Graph API is not supported
    1
  418. Glad you enjoyed!
    1
  419. Glad it was helpful!
    1
  420. You're welcome!
    1
  421. What is your email? I am going to forward the file to you.
    1
  422.  @adibogodi  Hi... we have many courses on our On-demand learning that will be very helpful for you. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  423. Glad you enjoyed the video. In this app we used Dataverse as our source.
    1
  424. You bet. It's honored by all app types.
    1
  425. You're right! Thanks for sharing that information! - Mitchell
    1
  426. Glad you enjoyed!
    1
  427. Thanks for watching!
    1
  428. Sure the typically way you're going to want to do that is with a multi step form. That's the next video in this series :).
    1
  429. Yes, that one is a great one in XRM Toolbox. That one is kept up to date more too.
    1
  430. It operates much the same way as Excel in Onedrive where you can have multiple editors. The last in wins. That said, it sometimes leads to errors and that's why you may want to consiider SharePoint or SQL Server.
    1
  431. Thank you so much 😀
    1
  432. In the Format pane, open the Buttons section and turn on the Accent Bar. You are able to set the bar position to left, right (what you are looking for), bottom, or top.
    1
  433. You are so welcome!
    1
  434. We are glad to help!
    1
  435. We are glad to help!
    1
  436. Glad it was helpful!
    1
  437. Glad I could help! This one might get you started and answer your other questions in your chat. It's a longer video though :https://www.youtube.com/watch?v=PEM5f9Xvn4g
    1
  438. You can with Virtual Connectors, but it does require a license at that point since it's still using Dataverse.
    1
  439. Glad it helped!
    1
  440. Hi Alfred, we are glad to hear that you were able to learn great and new tricks with this video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  441. Thanks! Glad you liked it!
    1
  442. Thanks for watching!
    1
  443. Thank you! I appreciate you taking time to comment! -Mitchell
    1
  444. Hi Srinivas, thanks for the feedback. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  445.  @SrinivasChintakindi  Anytime
    1
  446. Glad it was helpful!
    1
  447. Thanks for watching!
    1
  448. Thank you! Glad you enjoyed!
    1
  449. Your next stop is the PL-300 test. That test will require a bit more prep but we have that prep on our on-demand platform for free this week. Also try CertXP to get some practice.
    1
  450. Thank you!
    1
  451. Thanks, Ravi. We are happy to help. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  452. Likely using Azure Data Factory would be the most efficient way to move the data.
    1
  453. Likely what would make sense for such a small use case is to store your data in SharePoint or in Power Apps for Teams. All you would need for that then would be the copy of Power Apps for Office 365 (included w/ O365).
    1
  454. Thank you for subscribing!
    1
  455. If you create the community plan, your IT group can still manage it for you but it gives you more independence. No wrong answer on either way there but you're creating one more password to remember if you create a fake tenant :)
    1
  456. Glad it was helpful!
    1
  457. So a $10 user can do the same stuff as a $40 user in the present license. That would have been different before October of 2019. Now, the price difference is all around do your field people only need one app or are they going to need more than 4 apps. If you think that they only need one app, then license them by app. If you think you're building many applications, then the unlimited might make more sense. Hope that clears it up. -- Brian
    1
  458. OK That's the code for sure so it's likely something else. One thing to try before debugging is to Save the app, close it and open it again to see if it's just evaluating things inappropriately. -- Brian
    1
  459. You're welcome!
    1
  460. Glad it helped!
    1
  461. Yes, you can show instead of File Locations, show Documents (Regarding)
    1
  462. Thank you so much!
    1
  463. You're very welcome!
    1
  464. Glad you enjoyed!
    1
  465. Glad this helped!
    1
  466. Hello Sunwayr, It totally depends on what components you’re actually using but the best way to get pricing for any components is to use the Azure Pricing Calculator and specify the compute and resources needed for the Data Factory Pipelines: https://azure.microsoft.com/en-us/pricing/calculator/ Thanks Chris
    1
  467. Glad it was helpful! Thanks for learning with us!
    1
  468. Glad it was helpful!
    1
  469. Glad it was helpful!
    1
  470. You sure can Jatin. That's generally the way I do things but i figured for this example, most people would have a OneDrive folder with Windows. - Brain
    1
  471. You're welcome!
    1
  472. Glad you enjoyed :)
    1
  473. Thanks for watching!
    1
  474. You are very welcome Emilio. -Mitchell
    1
  475. Thanks!
    1
  476. While you can do it for anonymous users, it might not make sense from a security side.
    1
  477. Good question, I don't think the default field parameters support this functionality, however, you could possibly try creating a prior year calculation through a calculation group and that could change dynamically based on the "SelectedMeasure". Therefore, you would choose Cost to add to your chart and the prior years measure would automatically show prior year Cost. -Mitchell Pearson
    1
  478. Unfortunately not automatically. You could do that with a canvas app if you know it's an image. You can also try a PCF components from PCF.Gallery to see if there's a component that would give you that functionality.
    1
  479. Thank you for watching! If you are interested in more Pragmatic Works training, please feel free to email training@pragmaticworks.com :)
    1
  480. Thank you! -Mitchell
    1
  481. You could share .pbix files on a shared drive but all the benefits you get from the service (scheduling refreshes, row level security, subscriptions, Q&A, etc..) would not be available. The Power BI Report Server does not currently have the ability to create dashboards to that can only be done at PowerBI.com
    1
  482. You're very welcome! Glad to help!
    1
  483. Security to your datasets is managed in your Power BI Workspace. So any permissions you set there are carried over to the dataset. Hope it helps
    1
  484. You can see the limitations of SharePoint as a source here: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/limits-tshoot-virtual-tables?tabs=sharepoint. I'm surprised to see that Lookups are supported based on that doc for SharePoint. Person pickers are not for example. I haven't tried the lookup though for Sharepoitn personally.
    1
  485. Glad it was helpful!
    1
  486. Glad you enjoyed it! Thank you for learning with us.
    1
  487. We are glad you liked it!
    1
  488. Glad to hear that. Messay, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  489. Sure, you can actually integrate the records with SharePoint to give you that feel.
    1
  490. Sure, when you use CDS, you can add business rules there for validation. Any app will comply with those rules at that point.
    1
  491. Thanks for the visit
    1
  492. Typically the reason it won't work on a subgrid is the visible option. Pay special attnetion to that in the video as it nails me every time too.
    1
  493. J.D., we are glad you were able to learn new things. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://success.pragmaticworks.com/ondemandlearning-free-trial
    1
  494. You're very welcome!
    1
  495. Glad you enjoyed it!
    1
  496. Glad it was helpful!
    1
  497. Absolutely! Thanks for watching!
    1
  498. De nada!
    1
  499. The pipeline feature is isolated to a given tenant so you'd have to do the traditional export / import option for your client. Depending on your customer relationship, you could import unmanaged into their dev and let pipelies take over from there. - Brian
    1
  500. Glad to hear that
    1
  501. Thanks for watching! -Brian
    1
  502. Your best bet is to use Power automate to add that functionality (at this time). There are some components being built that will output CSV so that will be much improved later.
    1
  503. You are most welcome
    1
  504. Glad it helped!
    1
  505. Glad I could help!
    1
  506. By default, it is not secure. But when you check "Enable Table Permissions" on the list, it will use the table permissions area to lock it down.
    1
  507. I appreciate that! Thanks for watching!
    1
  508. Thanks for watching!
    1
  509. No problem! Thank you!
    1
  510. Glad it helped!
    1
  511. 🤣
    1
  512. We are glad you liked the video! Have a good day
    1
  513. It depends on where you put the OnSelect code. In most cases, you'd be able to click anywhere in that cell if you use the default scenario.
    1
  514. LOL. That's a great analogy.
    1
  515. Glad to help! I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  516. You're on the right path. The Sum function can do that and should be able to avoid performance issues since you're in a collection.
    1
  517. Thank you for watching!
    1
  518. You're very welcome!
    1
  519. Glad it was helpful!
    1
  520. Oh yes, you bet.
    1
  521. 🤭 Thank you for learning with us! 👨‍💻👩‍💻
    1
  522. Thank you for learning with us!
    1
  523. Glad you liked it. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  524. You'll find it under Addiitonal Options in the Basic or Advanced Form Step.
    1
  525. More to come!
    1
  526. You can still see the data in the table if needed just not on the website. You can see it in Power BI or in traditional SQL Server tools.
    1
  527. Glad you think so!
    1
  528. Your only limitation is datasources that PowerApps can access so that leaves you wide open :).
    1
  529. Hi RJ, you're trying to submit to a group of what? SubmitForm is typically how you're do that but just want to make sure I understand what you're going for?
    1
  530. Glad you enjoyed it
    1
  531. You're welcome!!
    1
  532. Glad it was helpful!
    1
  533. My pleasure!
    1
  534. Is the image file going to be a link or a binary file that you upload? You can either use a File Data type to upload the binary. There's also a PCF control you can get from https://pcf.gallery to show a preview of the image after upload too. Hope that helps! -Brian
    1
  535. Thank you!
    1
  536. Thank you!!
    1
  537. Thanks Mr. Work Stuff!, I should have named it [Total Profit]!! -Mitchell Pearson
    1
  538. Thank you!!
    1
  539. Glad it was helpful!
    1
  540. Glad it was helpful!
    1
  541. Hi Hemant, the use of the Azure Data Migration Services would be advisable for large scale migrations. At the time the video was published, Azure Data Migration Services was not the focus for this particular short video.
    1
  542. In Dataverse there are a few mechanisms you can use for that. You could use in a form a QuickView or Subgrid to show a 1:1 or 1:M relationship of records in the form. In a view, you could do this with Related columns area of the view creation. Lastly if you want to just run a query, you can connect an do the join in Power BI, Management Studio or XRMToolkit for example. I hope this helps - Brian
    1
  543. Tejas, we are glad you enjoyed our learning webinar. Our on-Demand Learning has courses on Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. It's a great way to learn at your pace, on any device! Check it out with our FREE trial: https://success.pragmaticworks.com/ondemandlearning-free-trial
    1
  544. Thanks!
    1
  545. Glad you liked it. Tarcisio, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  546. We are glad you liked the video. Have a good day, Dean!
    1
  547. Glad it was helpful!
    1
  548. Sure, you just have to model the database accordingly to support it.
    1
  549. Stick with solutions and add an Environment Variable. Then, configure your flows to use that variable. This allows you in each environment to externalize the configuration of those secret IDs. When you promote, the admin can then just change it without opening a flow. Hope this helps. - Brian
    1
  550. Glad you enjoyed!
    1
  551. I just double-checked and it is still there. Make sure you go to https://make.poweapps.com to see that option. You'll then select Excel Online.
    1
  552. No storage required (other than for the metadata). No data actually lives in DV. :) - Brian
    1
  553. Nothing better yet but hopefully we eventually get business rules there (no word there yet on this from MS).
    1
  554. Glad it was helpful!
    1
  555. Glad you liked it!
    1
  556. We are happy to hear that this course helped renew your hope in Power Automate!
    1
  557. Thank you for watching!
    1
  558. Glad to help!
    1
  559. Hi Mahesh, thanks for the feedback. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  560. Sure, it's a connector like anything else so sure thing.
    1
  561. Glad it was helpful!
    1
  562. Glad it was helpful!
    1
  563. Glad you enjoy it! Thanks for spending the time to make my day with your comments! - Brian
    1
  564. Great tip!
    1
  565. Glad it was helpful!
    1
  566. Glad it helped!
    1
  567. No problem! Glad you liked it.
    1
  568. Thanks for watching!
    1
  569. Happy to help!
    1
  570. Just use the free version here: https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15
    1
  571. Thanks for the feedback
    1
  572. Glad you enjoyed!
    1
  573. Certainly! You can make map regions interactive by overlaying buttons or shapes that are linked to bookmarks. First, create bookmarks for each target page, then place shapes or buttons on your map and configure their actions to navigate to these bookmarks.
    1
  574. Glad it helped!
    1
  575. Glad you enjoyed it
    1
  576. Hi Wellington, we are glad to hear that you liked the video. Our On-Demand Learning has many courses on SQL Server, Power BI, Azure, Data Science, Business Intelligence and much more. It's a great way to learn at your pace, on any device! Check it out with our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  577. Exactly, it would all have to go there or in the page itself for larger examples.
    1
  578. Thank you for watching!
    1
  579. I’d recommend viewing this playlist for installing SQL Server https://www.youtube.com/watch?v=wJ1qg5X09rE&list=PLcwrIWK7WBcS6yAJb-FjYMndzWPxmbQ0_
    1
  580. You'll find those in the description of the video under STudent Files.
    1
  581. You are welcome!
    1
  582. Awesome! Glad it helped Patrick - Mitchell Pearson
    1
  583. This is something you can change in the model itself.
    1
  584. Create another duplicate column with the value in the model and change the formatting on the duplicate field.
    1
  585. Thanks. We do have a few more planned in this series. Nice to know it will be received.
    1
  586. If you've only used SharePoint as your data source and no premium connectors your trial for the per plan will expire and the O365 license will take over if you have that. You can select your app at make.powerapps.com and select Details. At the bottom, it will say Premium or Standard. If it says Standard, nothing in the app will require the per app plan. Hope that helps - Brian
    1
  587. Glad it helped!
    1
  588. Mitchell Pearson
    1
  589. You're very welcome!
    1
  590. I appreciate that!
    1
  591. Hi @Melwyn, did is the business process just not showing up after you connect it?
    1
  592. Glad it was helpful! Thank you!
    1
  593. Thanks for letting us know! Playlist has been updated.
    1
  594. Thank you for watching our content, glad you enjoyed it!
    1
  595. Glad you think so!
    1
  596. You're welcome!
    1
  597. You nailed it @Mike. So now, it's just a matter of it rolling out to your tenant. Note that it's not planned for Europe/Asia for a bit longer also. They haven't deployed Azure OpenAI to those areas yet.
    1
  598. Sure thing, you can find that by clicking the gear box in the app and going to user preferences.
    1
  599. Totally understand. A bit of a different statement in what Azure / MS tracks as far as telemetry and what they expose to our companies and bosses.
    1
  600. My pleasure!
    1
  601. Glad it was helpful!
    1
  602. Hi there, you'll just need to add a Navigation in front of the Select code and you're ready to rock! - Brian
    1
  603. I am glad you liked it! Gavin, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://success.pragmaticworks.com/ondemandlearning-free-trial
    1
  604. You bet
    1
  605. Most welcome!
    1
  606. Glad it was helpful!
    1
  607. Thanks for the feedback! Interesting and glad people are trying the other languages as we put a lot of work into them. We'll work on the literal translations.
    1
  608. Glad it helped!
    1
  609. Glad you liked it!
    1
  610. Very welcome
    1
  611. No, you can continue to publish using pipelines for updates if you wish.
    1
  612. You're welcome! Glad to help (:
    1
  613. Glad you enjoyed it!
    1
  614. Glad you liked it!
    1
  615. Glad you enjoyed it!
    1
  616. Glad you enjoyed it!
    1
  617. Glad you enjoyed it!
    1
  618. Thank you! Glad you enjoyed!
    1
  619. Glad you enjoyed!
    1
  620. Wow, thanks!
    1
  621. Glad you enjoyed!
    1
  622. Glad it was helpful!
    1
  623. Hi Amina. I believe your best way to tackle that issue is incorporate a Power Automate flow to handle the update of the Excel row and to send different forms for your users throughout the stages.
    1
  624. Glad you enjoyed!
    1
  625. Hello KESAVANAND! If you are looking to learn more about Power BI then we can offer you more Power BI courses if you register for our On-Demand Learning membership. With this membership, you'll get full access to all our Power BI courses, quizzes, and labs. You can find more information by visiting our website https://pragmaticworks.com/pricing/. Don't hesitate to contact us if you have any additional questions.
    1
  626. You are welcome!
    1
  627. Hi Gregg, the feature we're talking about is in the thumbnail and in the description of the video.
    1
  628. With Patch, you have to specify a record you want to update. If the record is an insert try using the Defaults() function to specify no record.
    1
  629. You can use whatever connections you want in that one. Full Power Apps for the most part other than the restrictions I listed in the video.
    1
  630. You are so welcome!
    1
  631. Glad you enjoyed!
    1
  632. Thanks! We are happy to help. I am not sure if you know, but we offer many On-Demand Learning courses, such as, SQL Server, Power BI, Azure, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  633. Thanks.. we are glad to hear that. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  634. Great point!
    1
  635. That's going to have to be done with Power Automate after file upload.
    1
  636. Thank you! Glad to hear it was helpful (:
    1
  637. You're very welcome!
    1
  638. Glad to hear it!
    1
  639. Hi Lee, you would just re-import it into the corporate tenant using the solution. You can see how to import and export in this video I made right after this one: https://youtu.be/bAootc3AF4Y
    1
  640. Glad you enjoyed!
    1
  641. Thank you!
    1
  642. Yes, you can do that.
    1
  643. Thank you for watching
    1
  644. Glad it was helpful!
    1
  645. Thank you! Glad you liked it.
    1
  646. Glad it helped! Thanks!
    1
  647. Thanks for the feedback!
    1
  648. The Q&A visual has been out for many years now. It is not a premium feature.
    1
  649. Thank you for watching!
    1
  650. Glad it was helpful!
    1
  651. Glad it helped! Thanks for watching!
    1
  652. Hi Jagath, we are glad to hear that you liked this video. Also, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  653. Thanks for watching!
    1
  654. Hi @Michael, good point! I think I even warned in the video about your statement there too. For Excel, you can absolutely risk a collision if multiple people have that screen at the same time open. That said, Excel would also likely giving you a sharing violation error. That's why it would likely make sense to use SharePoint or SQL Server instead and use their autonumber functions like Identity.
    1
  655. That's awesome, glad you found my video helpful! -Mitchell
    1
  656. Yes for sure. One of the options is what Mime Types you want to allow for the upload. You'll find that in the same tab where i enabled the uploads. - Brian
    1
  657. Yes it does. The biggest issue that people might do is not scroll down, be logged in with VPN or mistype something.
    1
  658. Glad it helped!
    1
  659. Thanks. We are glad to hear that. Mike, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  660. You're very welcome!
    1
  661. Glad it was helpful!
    1
  662. Glad it was helpful!
    1
  663. Happy to help!
    1
  664. Yes I will
    1
  665. You can't do that presently.
    1
  666. Glad it helped!
    1
  667. Glad it was helpful! Thanks for learning with us!
    1
  668. Funny, now i have to watch that show. - Brian
    1
  669. Yes it's tied to the Excel spreadsheet so as you add data, it shows here as well as it refreshes. It will not account for a new column added though.
    1
  670. There is the ability now with Git and ohter tools to use see the raw code behind a canvas app now.
    1
  671. Hi! Thanks! 😄
    1
  672. You are very welcome!
    1
  673. This course starts at the beginning so you should be good!
    1
  674. Thanks for watching!
    1
  675. No, I don’t believe this is possible.
    1
  676. Happy to help! 🙂
    1
  677. Thank you for sticking around for multiple videos! We are so happy they have been helpful for you.
    1
  678. While you can't package the sharepoint list into the solution, you can package the reference to it and variables that point to where the prod/dev list is. To do that look inside your canvas app settings and scroll to the bottom. You'll see where it creates two variables for you to the sharepoint list.
    1
  679. Glad you enjoyed it!
    1
  680. Glad you like them!
    1
  681. You're welcome!
    1
  682. That's due to a delegation error likely. Something in your code is not parsing. You can changing your delegation setting under File --> Settings --> Advanced Settings but you want to fix the code likely so it doesn't cause that.
    1
  683. Thank you! Glad you enjoyed!
    1
  684. Currently, to get the refreshed data, you will need to close and reopen the report.
    1
  685. Glad you enjoyed it so much!
    1
  686. It's now called Multi-Step forms or you might also see it called Advanced Forms. I have an updated version of this if you're using Power Pages also.
    1
  687. Dev=Sandbox usually and the ohters would be Production. You could also use the developer environment for dev but that would give each dev their own environment, which might not be ideal for a large environment.
    1
  688. Hi Louis, it was released before the video was posted. You can go download it now here: https://aka.ms/pbiSingleInstaller
    1
  689. Sure, on the first screen of the advanced form (called Web Form in this video as it was an earlier release) there's an option for your starting step. Once you create your first step, just set that property.
    1
  690. We are glad to help!
    1
  691. Glad it was helpful!
    1
  692. You're welcome! Glad you enjoyed it!
    1
  693. You're welcome!
    1
  694. Glad you liked it!
    1
  695. Glad you like it!
    1
  696. Hi, our free Power Virtual Agent In A Day course is already live on our website. You can sign-up by clicking here: https://www.pragmaticworks.com/product/power-virtual-agent-in-a-day/
    1
  697. You're so welcome!
    1
  698. You're very welcome!
    1
  699. Glad you liked the video
    1
  700. Hi Deb. You could add a column to your data source that has the record you are doing an approval on. The values of the column could be set to False by default. On the button you click for the approval you could add a PATCH command that changes the value of the column from false to true. Then, on the button's visibility property you could use a Formula like If(ThisItem.ColumnName = false, true,false) I know that might be hard to execute just by reading this but feel free to email me at mpeterson@pragmaticworks.com
    1
  701. Glad you enjoyed
    1
  702. Thank you!
    1
  703. Yes of course. Totally customize the pattern to your own business case but you're right.
    1
  704. Thanks for watching!
    1
  705. Hey Sztale, the filter context of the total row would be all years (2005-2010) and sales only go through 2008.
    1
  706. Hi Justina, we are glad to hear that. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  707. You're welcome (:
    1
  708. Does the form show up for a Model-Driven app? That would be the first step to debug to rule out the form and rule in Portals.
    1
  709. Glad it helped!
    1
  710. Thanks! We are glad to hear that you liked the video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Azure, Power BI, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  711. Glad you enjoyed it!
    1
  712. My pleasure!
    1
  713. Glad it was helpful! Thanks for learning with us Karan!
    1
  714. Thanks!
    1
  715. Glad you liked it!
    1
  716. Glad you enjoyed it!
    1
  717. Please see response to your question in the video "Advanced Power BI: Solving the hard problems". With the data model properly setup and configured these results would be very easily attainable with Power BI. If the response provided is not detailed enough we may be able to help you with our DAX Boot Camp course or 1 on 1 virtual mentoring. Please take a look at all our training opportunities at www.pragmaticworks.com.
    1
  718. Glad it was helpful!
    1
  719. Thanks a lot!
    1
  720. No problem! Thanks for watching!
    1
  721. When it prompts me, there's a Stop Recommendations.
    1
  722. If you go to the settings of the Design Studio, search for Ideas in the upcoming features section, then turn off the Enable Ideas Panel
    1
  723. You can. https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-personalize-visuals
    1
  724. Thanks, Rati. We are happy to help. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  725. Yes that is correct. Once you save the record it created the folder necessary to save the files but it has to have a record to map that folder to.
    1
  726. LOL. Yeah, that was a big boo-boo. :). Can't believe I hit publish before checking that. Sorry about that! - Brian
    1
  727. You can use roll ups and calculations on your columns within your Dataverse column settings for model driven apps
    1
  728. Thanks. We are glad to hear that.
    1
  729. We offer it on-demand at http://www.pragmaticworks.com/training
    1
  730. Since you're in India you can take it here: https://pragmaticworks.co.in/
    1
  731. Yes there is a method to do that as well but not sure of the number of items it would return. Worse case you can integrate Azure Automation into it to get a list using Power Shell and return that to the Power App.
    1
  732. Glad it was helpful! Thanks for learning with us!
    1
  733. You are very welcome! Glad it helped!
    1
  734. Great to hear! Thanks for watching!
    1
  735. Yes, the name has changed but largely the same. :)
    1
  736. Glad it was helpful!
    1
  737. You are welcome
    1
  738. Welcome
    1
  739. You're welcome
    1
  740. Glad you enjoyed it!
    1
  741. Hi Nasar, You'll just need to use the On Prem Data Gateway (same service that Power BI uses) to connect to an on-prem data source.
    1
  742. An MS requirement rule but you shouldn't put your main production environment as your default env. Typically this is like the "junk drawer" for most organizations and should be used for Personal Productivity projects. - Brian
    1
  743. They have discontinued that one template but if you use the default template, it should work as well.
    1
  744. This Session is being recorded and will be available on YouTube.
    1
  745. 😀
    1
  746. Glad you like them!
    1
  747. Thanks Gopi.
    1
  748. Sounds like you might not have saved the table after checking Column Security on the field level.
    1
  749. Glad it was helpful!
    1
  750. Here's the link to the other more recent series: https://www.youtube.com/watch?v=JutfjRVWrog
    1
  751. It's considered a premium connector so unfortunately the appropriate license is required.
    1
  752. Ideally, you would place all those users into a business unit and do business unit level security (fill that bubble up half way).
    1
  753. Glad it helped!
    1
  754. You are correct. I couldn't find a way to add any overwriting CSS. It had to be inline the component.
    1
  755. You are welcome!
    1
  756. Only a few reasons why that could occur. Usually delegation or a filter syntax on it.
    1
  757. Glad you liked it, Thank you! -Mitchell
    1
  758. You're welcome!
    1
  759. You're welcome!
    1
  760. Thanks for the feedback.
    1
  761. Thank you!!
    1
  762. So glad you liked the video Jerome, thank you for learning with us!
    1
  763. Glad you enjoyed :)
    1
  764. Our On-Demand Learning has courses on Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. It's a great way to learn at your pace, on any device! Check it out with our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  765. Unfortunately that can't be done yet.
    1
  766. Hi Julia, you can pay per use $10/user/month or a Dynamics license would also work for unlimitted apps.
    1
  767. Glad it was helpful!
    1
  768. We appreciate that. Thanks for watching!
    1
  769. Sure thing. Those have been built as well now too and I'm about to add those to the solution. I'll be happy to email those to you. My email is bknight<AT>pragmaticworks.com.
    1
  770. Thanks!
    1
  771. I've already uploaded them to the cloud to simplify the example.
    1
  772. You can make it show up in Teams and also in a company internal store (Dynamics)
    1
  773. Great to hear! Thanks!
    1
  774. Glad it was helpful!
    1
  775. You're welcome!
    1
  776. The world may never know. :)
    1
  777. Thanks for watching my video Micaela! Actually, they’re different things and both a good step for securing your SQL Server environment. Virtual accounts came out with SQL Server 2012 and gave the DBA an option to have a system-managed account where they did NOT know the password. But, it was limited to only that server. sMSA (single Managed Service Account) and gMSA (group Managed Service Account) are designed to allow the password of the account be “auto-magically” handled by AD so it is changed every thirty days (default AD – can be changed). sMSAs also came out with SQL Server 2012 and were the first attempt to allow these service accounts be managed by AD. Unfortunately, they were still tied to the single server and were not a real Enterprise level tool. gMSAs came out in SQL Server 2016 and truly allow a domain approach and way to better deal with Kerberos issues. In addition, they will work well with Always On Availabiity Groups. All of these were attempts to keep from using a single domain account across the enterprise on all SQL Server instances. Feel free to email me directly at mwall@pragmaticworks.com with any other questions! Thanks, Mike
    1
  778. Micaela, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  779. Thanks!
    1
  780. Happy to help!
    1
  781. Sorry about that. Here you go: https://powerapps.microsoft.com/en-us/blog/powerapps-ten-reusable-components/
    1
  782. Glad you enjoyed it
    1
  783. You're welcome!
    1
  784. You're welcome
    1
  785. Glad it helped!
    1
  786. Glad it was helpful!
    1
  787. Glad you think so!
    1
  788. I tried to cover everything to give you the most complete overview. but we do have shorter videos that are less end to end.
    1
  789. Glad it was helpful!
    1
  790. A news slider? To do that you'll need a PCF component. You can see more about those at https://pcf.gallery. You can also simulate it with a gallery and some animation on a timer.
    1
  791. Thanks, John. We are glad to hear that! I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  792. On-Demand Learning Courses FREE Trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  793. Full playlist can be watched here https://youtube.com/playlist?list=PLcwrIWK7WBcSWpF3lWSz0-rGNjE3I6_9E&si=9QXfRTYnUo1vw6Tm
    1
  794. You are most welcome
    1
  795. Hi There. Just trying to make sure I answer properly. Are you asking a question about a different video?
    1
  796. Glad you enjoyed!
    1
  797. Glad you liked it!
    1
  798. You are most welcome
    1
  799. You're welcome!
    1
  800. Thanks, Renato. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  801. Glad you enjoyed!
    1
  802. Glad to hear that!
    1
  803. You're most welcome!
    1
  804. Yes, they're all treated the same.
    1
  805. Are you wanting to create an active directory Group/User or are you referring to a workgroup in something like Teams? The AzureAD connector can create users/groups if that's what you're looking for. -Brian
    1
  806. It's much easier now than it used to be. Now, you just click Edit Code and it opens up a web flavor of VS. Prior though you're right!
    1
  807. Hi there. I'm not quite sure why you don't see the bubbles... Feel free to email me a screen shot of what you see/don't see to mpeterson@pragmaticworks.com
    1
  808. Hi @Jason, you can place this in any order but I would have normally put it into the OnSuccess event instead of where we put it in this video for demonstration purposes. THe NewFOrm function resets the form back to newform mode but if you cancelled, your data will still be there. The way around that is to do a ResetForm when you click Cancel
    1
  809. You are very welcome!
    1
  810. Thanks for the feedback. I am not sure if you know, but we offer many On-Demand Learning courses in case you need more training. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  811. Thank you. Glad you enjoyed it!
    1
  812. Glad it was helpful!
    1
  813. Glad you enjoyed!
    1
  814. You are correct about Multi-Step forms. Check out the Power Page series to show those pieces. You're also correct that step two should be Results from a Prev Step where Step 1 is an Insert.
    1
  815. Hi, you will need a license of Power Apps to use the application above the free Office 365 license since it uses CDS to store the data for dev and use. No license cost from Pragmatic Works though! We're giving it away to help customers. -Brian
    1
  816. Glad it was helpful!
    1
  817. Are you speaking of a bit column or one that's a varchar column that literally says Yes and No? Either one can be done.
    1
  818. Thanks so much
    1
  819. Glad it was helpful!
    1
  820. Brian, it's for the same reason one keeps the web cam on during meetings. Non-verbal communication is important and is a way to keep your attention while I look you in the virtual eye. - Brian
    1
  821. Glad you like our videos. We are here to help!
    1
  822. Glad it helped
    1
  823. Coming soon!
    1
  824. You are most welcome!
    1
  825. Appreciate it!
    1
  826. Are you thinking of a choices field? If so you have to pack fields into a curly brace to accomplish that and pass int he fields that were selected. Patch(‘Employee Information’,Defaults(‘Employee Information’),{Title:”test Choice”,’Job Title’:Dropdown1.Selected})
    1
  827. No problem 👍
    1
  828. Glad it was helpful!
    1
  829. Glad it was helpful!
    1
  830. Glad you enjoyed!
    1
  831. :) I feel ya.
    1
  832. LOL. I forgot I had that test record in there :). Got me - Brian
    1
  833. You can. There's an option in a list to do that. You'll have to go to Portal Management to enable it though.
    1
  834. Thanks
    1
  835. Thanks. We've tried quite a few but the Yeti mic is our fav :).
    1
  836. LOL, that's EXACTY why I made it. I was shocked that even the MS docs for a simple installation were no bueno. Thanks for the comment. - Brian
    1
  837. Glad you like them!
    1
  838. It sure can ;)
    1
  839. You are very welcome!
    1
  840. Glad you found it helpful :)
    1
  841. Here's a great introduction to Excel to help you get started! https://www.youtube.com/watch?v=dxKK3rbubvo
    1
  842. Great question! In this case, you would need to edit the GEOjson file directly. In our example the contents would look something like this: "fillColor":"#41b6c4","strokeColor":"black","strokeWidth":"1". From here you can edit the Hex Code of the map fill and additional settings. All will be recognized when you reapply your reference layer file!
    1
  843. Thank you for watching and subscribing! Glad you enjoyed.
    1
  844. Hi Said. Did you hit the ellipses next to the "app" control in your tree view, and then click Run On Start?
    1
  845. Thank you! Glad you enjoy them.
    1
  846. Hi Terry, this course is part of our Elite Package. However, you can watch the first 3-4 videos for free on our 7-day free trial. To sign-up for our free trial, please visit: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg . We also offer more than 60+ courses in Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You don't need to enter your credit card and you will get instant access for the free trial. Please, let me know if you have any additional question. Thanks and have a great day.
    1
  847. Glad it was helpful!
    1
  848. You're welcome!
    1
  849. That’s because YouTube is altering the text of the URL when you right click and copy it. Try highlighting the text of the URL and copy just the text.
    1
  850. Glad you enjoyed it!
    1
  851. Thanks for watching!
    1
  852. You bet!
    1
  853. Thank you for sharing! Good memories indeed!
    1
  854. LOL. I wish I had his money and friendship with Brian Cranson.
    1
  855. We are glad to hear that you liked this video, Aditya. Also, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  856. It will not unfortunately. External source tables are not included other than dataverse.
    1
  857. Glad it was helpful! - Brian
    1
  858. Glad it was helpful!
    1
  859. Glad to hear that!
    1
  860. Glad it was helpful! Thank you for learning with us.
    1
  861. Glad you enjoyed!
    1
  862. You're welcome!
    1
  863. You're welcome!
    1
  864. Thanks for alerting me. The link has been fixed.
    1
  865. Sure, you can most certainly do that. There's an option to override any field and an option to add extra metadata like instructions. There are a few places to add instructions but you'll find it in the web form.
    1
  866. Glad it helped!
    1
  867. Thanks!
    1
  868. Thank you 👍
    1
  869. Yes you can group your tasks together in the admin app and you can groups of delegates where they can control your tasks and vice-versa. We're now adding the ability to group individuals together to where you assign those tasks to people and not just individuals also. Let me know if you have any other requests too! - Brian
    1
  870. Glad it was helpful!
    1
  871. Now, VS is integrated right into the designer so you just have to click Edit Code and it launches a slim version of VS.
    1
  872. Glad you enjoyed it!
    1
  873. You're welcome!
    1
  874. Thank you!
    1
  875. Hi, you can still find this visual here: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380771?src=office | Hope it helps!
    1
  876. Great Question! This is a bit more involved, but basically you'd need an dataverse "Action" which calls a classic workflow to grab the pre-deleted values from the record. Then your Cloud flow's trigger would be "When an Action is performed" as opposed to "When a row is Added, Modified, or Deleted". There's a great step by step blog on how to accomplish this here: https://forwardforever.com/power-platform-and-classic-workflows/
    1
  877. Sure, it's available now. It can be found under Advanced Settings in the gear cog in the upper-right.
    1
  878. Glad it was helpful!
    1
  879. You are very welcome!
    1
  880. You're very welcome!
    1
  881. Hi @Junior, you can fix this by going to the Portal Management app and modifying your Basic Form there. Hope that helps! - Brian
    1
  882. Glad it helped!
    1
  883. Good morning! You can read more about on thought on Azure versus AWS here: http://blog.pragmaticworks.com/why-choose-azure-over-aws Thanks!
    1
  884. Glad it was helpful!
    1
  885. Thank you 🙂
    1
  886. Love the idea Sara. Generally, I make a model-driven app to manage all of that. I'll make that one next (likely tomorrow).
    1
  887. We're making an accelerator of it now. The goal here was to show the art of the possible :). I do have another video where I walk through how we made it. You can also feel free to reach out to me if you want and we can help you implement something like this. I'm at bknight<at>pragmaticworks.com.
    1
  888. Glad you like them!
    1
  889. Glad it was helpful!
    1
  890. Wow, thanks!
    1
  891. We are glad to hear that.
    1
  892. No problem! Thanks for watching!
    1
  893. Hi Michael. Please, reach out to Devin (dknight@pragmaticworks.com). He will be able to share the file via email
    1
  894. You bet.
    1
  895. Thanks!
    1
  896. Yes absolutely. If it's not a M:M table, you can use a Patch to accomplish this likely most effeciently.
    1
  897. Thanks! Glad you enjoyed!
    1
  898. Thanks!
    1
  899. Noted!
    1
  900. You should be able to find what you need here: http://blog.pragmaticworks.com/power-bi-custom-visuals-box-and-whiskers
    1
  901. I believe it did.
    1
  902. Hi Marlon, model-drive apps can be accessible to external users through Portals typically. You can also invite guests into PowerApps as of October.
    1
  903. Glad you liked it!
    1
  904. Glad we could help!
    1
  905. You are welcome!
    1
  906. Sure thing. YOu can see a video i made about that here: https://www.youtube.com/watch?v=ukFsdsBEZBU. SharePoint be much slower as a data source though so make sure it's only used for small data sets under 5000 rows or so. - Brian
    1
  907. You're welcome!
    1
  908. We are glad to hear that you liked the video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  909. Our pleasure!
    1
  910. Sure do. Check out our Learn Power Apps playlist on our channel.
    1
  911. Thank you! 😃
    1
  912. Since I've filmed this, they've altered it slightly. You'll need to modify your form for the model-driven app. When looking at it, go to Components and add a Timeline control wherever you want. After that, you're golden.
    1
  913. Glad it helped!
    1
  914. Thanks for watching!
    1
  915. Glad you enjoyed it!
    1
  916. Happy to help!
    1
  917. If you Google it, you can find some great ones. :)
    1
  918. Thank you for watching and commenting! -Mitchell
    1
  919. Hi Daniel. Here are a couple of recommendations from Brad: https://docs.microsoft.com/en-us/azure/active-directory/ https://docs.microsoft.com/en-us/azure/active-directory/active-directory-how-subscriptions-associated-directory
    1
  920. Thank you for bringing this to our attention Richard. We are in the process of solving the issue now!
    1
  921. You can reach out to Power On BI. Thanks!
    1
  922. Glad to help!
    1
  923. Happy to help!!
    1
  924. You are welcome!
    1
  925. There is a distinct clause inside of Power Apps but if the data is in SQL Server, you would likely want to build a view that did that grouping of data there instead.
    1
  926. If you want to use my dataset, you can use this vid: https://www.youtube.com/watch?v=PEM5f9Xvn4g. Bad Gateway is usually a connection issue.
    1
  927. haha, awesome and thanks :) -Mitchell Pearson
    1
  928. Of course! Thanks for watching!
    1
  929. :) I'm just the messenger there my friend. If it's any consolation, it is on sale now for $3/user/month/app or $13 for unlimited.
    1
  930. Sure thing!
    1
  931. Thanks!
    1
  932. We are glad to hear that!
    1
  933. Thanks for watching!
    1
  934. Sure, check out this video on styling the portal: https://www.youtube.com/watch?v=OqXUG4Mykr4
    1
  935. OK that's strange. Can you email me what error you're seeing. TYpically it's a permission issue.
    1
  936. Glad it was helpful!
    1
  937. Yeah we had to cut that section due to time constraints but that follow on vid was posted today here: https://www.youtube.com/watch?v=LBsP6dauHeY
    1
  938. which email did you send to?
    1
  939. Yes, users can do this from the Power BI Service as well.
    1
  940. Sure thing. I talk about that exact thing in a follow up video here: https://www.youtube.com/watch?v=MrJnOnpf0Po
    1
  941. Load form refers to the dataverse form that we created in the first video in this series. The Tab is a single tab in that form that you can call out. Hope that helps. - Brian
    1
  942. They will not because there's no data being stored in dataverse.
    1
  943. You bet.
    1
  944. Agreed. The next one I'm working on is styling followed by SSO. Thanks!
    1
  945. Glad it was helpful!
    1
  946. We use OBS and there's a filter there to key out the green screen.
    1
  947. You are welcome!
    1
  948. Thanks for watching!
    1
  949. Glad I could help!
    1
  950. Thank you!
    1
  951. Glad you enjoyed it!
    1
  952. Happy to hear the video was helpful, thank you for the comment!
    1
  953. You'd have to use a PCF component to do that. You can download those at https://pcf.gallery then install it as a solution. Once installed, you can change nearly anything. - Brian
    1
  954. To do this, you'd want to use some Liquid code to make the table feel like whatever you want.
    1
  955. Glad to hear it!
    1
  956. Not yet but its coming
    1
  957. Thank you! Glad to hear that we were of help!
    1
  958. Hey Kashif, Thanks for watching. Here is the link to the course: https://pragmaticworks.com/product/modern-excel-analyst-in-a-day/
    1
  959. Great to hear!
    1
  960. You are so welcome!
    1
  961. Thanks for watching!
    1
  962. Glad you enjoyed!
    1
  963. Hi, this video is part of a series where these items are covered.
    1
  964. We have it as a free download on GitHub here if it helps get you started. https://github.com/Pragmatic-Works/Pragmatic-Works-K12-Platform
    1
  965. Hi Mark, the QuotaID is an identity column so it automatically is generated and added in SQL Server. - Brian
    1
  966. Hey there! Would need to see a bit more, great use-case for our virtual mentoring service :) - There are a number of DAX functions that could assist like VALUES. Another idea could be a Custom Tooltip to assist.
    1
  967. That's awesome Gerald. Thanks for the comments. - Brian
    1
  968. Thanks for the input!!
    1
  969. Glad to hear that
    1
  970. I don't believe that's supported yet for MDAs :(.
    1
  971. It does the work automatically for you. The switch was solely to simulate going offline.
    1
  972. Glad you enjoyed :)
    1
  973. Glad you enjoyed!
    1
  974.  @SparklingSaraStar  Thank you for being an advocate. We don't see your comment, not sure if it was removed by YouTube?
    1
  975. Thanks so much!
    1
  976. Thanks for watching!
    1
  977. Great to hear!
    1
  978.  @disturbedcarrot  No, the entire point is to learn without causing "damage" to the overall company environment. They're managed in the corporate environment but don't eat up your quota :).
    1
  979. Hi Sumit, thanks for the great feedback. That means a lot to us. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  980. Thanks for watching!
    1
  981. Glad you enjoyed it
    1
  982. Hi Noah, as per the Microsoft documentation we have look over, Insights is supported for reports in Premium and Premium Per User (PPU) workspaces. You can also use this capability in non-premium workspaces if you have a PPU license. However, we are also having the similar issue when accessing on our Premium tenant and it looks like, right now, Insights is only available for PPU licenses.
    1
  983. Glad you enjoyed!
    1
  984. Glad you think so! Thanks!
    1
  985. Thank you so much 😀
    1
  986. I am glad you liked it
    1
  987. We are glad to help. Carlos, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  988. My pleasure
    1
  989. You're very welcome!
    1
  990. Glad it helped!
    1
  991. Thank you! Glad it helped.
    1
  992. I'm afraid you can't convert it. If you'd like that, you can setup a trial environment that can be converted to production. Instead, you use this environment to develop and then export the apps out to be imported into QA/Dev/production.
    1
  993. Thank you!
    1
  994. Thank you for your recommendation, Azam. We have a playlist containing a majority of our videos on DAX in Power BI at https://www.youtube.com/watch?v=ckB93I3GpcQ&list=PLcwrIWK7WBcSCg1lCl-mY2AYT6FXYy119.
    1
  995. Thanks for subscribing!
    1
  996. Check out this video: https://youtu.be/-MFpKx5QdrY?si=nv3QDO_8I9mH13UD
    1
  997. Thanks!
    1
  998. Glad it could help!
    1
  999. Thanks. We are glad to help. If you need more training, we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1000. Glad you liked it! Thanks!
    1
  1001. Hey Nasar, the Pipelines and Data Flows in Synapse are sufficient for doing the ETL even if you don't need the other parts in Synapse Analytics.
    1
  1002. Thank you. Hope it was helpful.
    1
  1003. Glad you think so!
    1
  1004. Until my next video, here's the ALM Guide from MS: https://docs.microsoft.com/en-us/power-platform/alm/
    1
  1005. What you are looking for is Row Level Security. Here is a video link to help https://www.youtube.com/watch?v=onhPjPFW0oo
    1
  1006. Hi Derek, check out this cheat sheet I wrote that hs the SharePoint variants near the bottom of it: https://pragmaticworks.com/resources/cheat-sheets/power-apps-cheat-sheet-page/ I think it answers that question for you. Brian
    1
  1007. More to come soon!
    1
  1008. Sure, by default, the only providers turned on for logging in are Internal and Azure AD. You can turn off registrations and turn off Internal to prevent anyone outside your AD to log in. - Brian
    1
  1009. Just don't look at the Tesla Bot's browser history. :)
    1
  1010. They can as long as the app doesn't use a premium connection.
    1
  1011. Hi! It appears to be working on our end. Please try using a different browser and downloading again! https://pragmaticworks.com/downloads/
    1
  1012. Glad it was helpful! Thank you!
    1
  1013. Thanks for watching!
    1
  1014. Hi there! The Student Number and Student ID columns actually do store the same data so it's ok that the relationship is built on these two. Surrogate keys are a great option to consider but since this is more of a beginner class than the Data Modeling one it wasn't covered here.
    1
  1015.  @babatundeolamideogunkoya3909  The StudentID column should not have a value higher than 1000. It sounds like you may be having an issue with the delimiter between the columns next to it. Each column has a comma separator delimitating where one column starts and stops.
    1
  1016. Thanks so much. You rock. - Brian
    1
  1017. Ficamos felizes que voce gostou!
    1
  1018. I'd recommend reviewing our PL-300 playlist if your goal is to pass the exam. https://www.youtube.com/playlist?list=PLcwrIWK7WBcSCcdFkFBftOjqli_yi9Zti This video is more about practical Power BI development.
    1
  1019. Do you see entities and stuff in that menu under data?
    1
  1020. It should work with percentages too but you have to be careful with how you aggregate percentage values.
    1
  1021. Thank you!
    1
  1022. Glad I could help!
    1
  1023. Glad it helped! Thank you for learning with us.
    1
  1024. Exactly. Since you're not using an official form, you have to rely on other means to trap errors with Patch.
    1
  1025. You are welcome!
    1
  1026. Sign up for a community plan of our On-Demand Learning and you can watch this session today! https://learning.pragmaticworkstraining.com/course/learn-with-the-nerds-copilot-studio-beginner-to-pro
    1
  1027. Hi Renata... Thanks!! I am glad you liked it. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1028.  @recalesi  Of course. Anytime!
    1
  1029. Thanks for watching
    1
  1030. I appreciate that!
    1
  1031. Glad it was helpful!
    1
  1032. They're cloud services. Linux/Apple or PC, it's just data.
    1
  1033. You would have to create a new onmicrosoft.com tenant with nothing inside of it.
    1
  1034. You're welcome!
    1
  1035. You would use the Relate and UnRelate functions to add or remove from the intersection table.
    1
  1036. Thank you!
    1
  1037. Glad it helped!
    1
  1038. Glad it was helpful!
    1
  1039. Hi Henry, thank you so much for your question! It looks like you have a nicely designed report showcased on GitHub, as well as project information contained in your README.md file. I liked how you have described the sources of your data, the schema layout description, the methodology you have used for combining source data, as well as the schema model that you’ve used. Depending on the needs of your audience and your requirements, this may be just enough. As I was saying in my webinar, there is no “golden template” when it comes to documentation, and since this is a showcase – I presume that you are the one driving the level of detail you want your audience to see. From my perspective, you’ve done a good job with documenting your project for its intended purpose. My only suggestion comes more from a visualization perspective, rather than documentation. I would suggest adding a title to each of your slides, so it is clear what the audience is looking at, as well as to each of your visuals (including the map on the first page and the decomposition tree on the second page). Great job! I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1040. Glad you enjoyed it!
    1
  1041. Glad I could help
    1
  1042. You'll find those in the description
    1
  1043. Thank you!
    1
  1044. Glad it was helpful!
    1
  1045. Try just copy and pasting the text of the link into Power BI instead of clicking the link and opening it in your browser.
    1
  1046. You are so welcome!
    1
  1047. Glad it was helpful! Thanks for watching!
    1
  1048. Chris, we are glad to hear that you liked the video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1049. Yes, I think the next video in this series is security based. It will walk you thru that. :)
    1
  1050. Glad you enjoyed it!
    1
  1051. Glad you enjoyed it!
    1
  1052. Hey Chris, this video is a bit old so it's possible some UI stuff has changed around a bit, if you email me directly and maybe provide screenshots of what you're looking for I can do my best to help! mpearson@pragmaticworks.com - Mitchell
    1
  1053. So glad it was helpful! Was hoping others didn't have the save learning curve i went through.
    1
  1054. Glad you enjoyed!
    1
  1055. Glad it was helpful!
    1
  1056. Thank you for watching!
    1
  1057. Hi There, check out the rest of our channel and search for PL-300 to find more on certification prep videos. This was filmed in late 2024 so is still fully accurate to what you see today.
    1
  1058. Do you want to export it to a SQL Server or a CSV perhaps? You can use the COLLECT or PATCH to do some of that heavy lifting.
    1
  1059. Glad you enjoyed! Thanks for watching! :)
    1
  1060. Hey, thanks!
    1
  1061. Thanks, Simran. We are happy to help. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1062. Glad it was helpful!
    1
  1063. It's a canvas application in this case but components do work in model drive apps.
    1
  1064. Glad it was helpful!
    1
  1065. Great to hear!
    1
  1066. No you can most certainly put column level security on custom dataverse tables. Maybe that's an older requirement I haven't heard of but most of examples i use are custom tables.
    1
  1067. Glad you like it!
    1
  1068. Hi Max, Power BI Premium does not include a license to SQL Server.
    1
  1069. Max, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1070. Glad it was helpful!
    1
  1071. Sure, you would have to determine the file type first and if it's a PDF for example, you can use the PDF viewer control, image control or whatever.
    1
  1072. Thank you!
    1
  1073. Thanks, Cameron!
    1
  1074. Glad you think so!
    1
  1075. glad we could help!
    1
  1076. For that, you can use the Power Apps Notification connector and have it open the app with parameters as shown in this video.
    1
  1077. Thanks for watching
    1
  1078. You are welcome!
    1
  1079. Hmm.. not sure what could be causing this. I would suggest re-starting PowerPoint and trying another report. Let me know if this works!
    1
  1080. Thanks!
    1
  1081. We think so!
    1
  1082. Thanks ✌️
    1
  1083. You could if you query the tables that store the approval.
    1
  1084. Thank you! - Mitchell
    1
  1085. Glad it helped!
    1
  1086. Good Morning Harish, there is no dataset for this video.
    1
  1087. No problem! Thank you for the support!
    1
  1088. Glad you enjoyed!
    1
  1089. Thank you!
    1
  1090. Glad you enjoyed!
    1
  1091. Hi Mrinal... I am sorry, but we no longer have this PPT. Have a good day and stay safe!
    1
  1092. Glad it helped!
    1
  1093. OK that is an odd one. The Liquid code is pointing to a form or list that has been deleted or that i thinks has been deleted. I would remove the form and re-add it and it should relink.
    1
  1094. Thanks! Glad you enjoyed!
    1
  1095. Glad you enjoyed!
    1
  1096. Thanks for watching!
    1
  1097. Glad it helped!
    1
  1098. Thank you for the feedback! I am glad you liked it.
    1
  1099. Sorry Tim, that is the only way to proceed or you can create a new test tenant to try in with a new domain but that requires more work.
    1
  1100. Hi Riaz, getting a month over month difference is pretty easy with DAX and time intelligence. The current month payroll would simply be: Payroll = SUM('TableName'[PayrollAmount]). The prior Month Payroll would be something like: Prior Month Payroll = CALCULATE( [Payroll], DATEADD('DateTable'[DateColumn], -1, Month) ) If you want to see the difference you could then create a third measure: Month over Month Diff = [Payroll] - [Prior Month Payroll] Hope this helps!
    1
  1101. Glad to hear it!
    1
  1102. Glad you enjoyed it!
    1
  1103. Yes, it can support hundreds of languages on forms and on various pages. The users can select a language in the upper right once you turn this on or can set a default profile.
    1
  1104. Glad it was helpful!
    1
  1105. The Patch command is essentially the same for either either source. For scale generally choose SQL Server.
    1
  1106. Glad it was helpful!
    1
  1107. Glad it helped!
    1
  1108. You're very welcome!
    1
  1109. Glad you liked it!
    1
  1110. No problem
    1
  1111.  @CevicheChessSalsa  You're welcome!
    1
  1112. Thank you for learning with us!
    1
  1113. No problem!
    1
  1114. Glad it was helpful!
    1
  1115. Welcome!
    1
  1116. Glad it was helpful! Thanks!
    1
  1117. Much appreciated!
    1
  1118. Glad it was helpful!
    1
  1119. Sorry, I need some sort of error to debug that one.
    1
  1120. Appreciate it!!
    1
  1121. You are welcome
    1
  1122. It will not show up on old rows unless you enroll those old records in the process. To do that, you can click Switch Process and select your BP
    1
  1123. Glad it was helpful!
    1
  1124. Thank you!
    1
  1125. You're welcome!
    1
  1126. Joe, so glad it was helpful!
    1
  1127. That's strange. That could be a video driver. I have only seen that once and when I updated my windows driver it killed that issue for me personally. - Brian
    1
  1128. Sure, you would essentially do a ForAll loop to loop over the items selected .
    1
  1129. Thank you! Glad you enjoyed :)
    1
  1130. Thanks for the note!
    1
  1131. Glad you found this helpful!
    1
  1132. Thanks!
    1
  1133. You're very welcome!
    1
  1134. Yes. :)
    1
  1135. You can delay the load to happen at a different time or just create the schema if you wanted.
    1
  1136. Glad it helped!
    1
  1137. You're welcome! Thank you for your comment (:
    1
  1138. Thanks a bunch!
    1
  1139. Yes, the minimum requirement for working with Copilot in Power BI is a Fabric enable workspace. Learn more here: https://www.youtube.com/live/J4l34uUqHtw?si=JB0H1XAjtdYi7X4n
    1
  1140. Glad it was helpful!
    1
  1141. You are welcome!
    1
  1142. Glad it helped!
    1
  1143. Glad to help!
    1
  1144. The video quality appears to be high definition. You may need to manually change the default settings in the youtube video player to adjust the quality.
    1
  1145. Thanks, will do!
    1
  1146. Thanks! I realized that shortly after filming this video. The first few times I did it, it took about 10 mins to show up so I was making the assumption a restart was needed but as you can see in this video, it instantly showed up for me too. Must have been a transient behavior.
    1
  1147. Glad it was helpful!
    1
  1148. Glad you enjoyed it
    1
  1149. Glad you liked it!
    1
  1150. Haha! Yes, yes it is :) - Mitchell
    1
  1151. FREE DAX Conference on October 8 from 11am-2pm EST. Learn how to create effective DAX formulas that will help you get the most out of your Power BI data during this FREE event. If you want to learn how to master DAX concepts and calculations, this event is for you. Sign-up now: http://learnwiththenerds.com/
    1
  1152. Thank you for watching and subscribing!
    1
  1153. Glad you enjoyed (:
    1
  1154. Are you using the Relate/Unrelate function to add the relationship?
    1
  1155. Glad it was helpful!
    1
  1156. Glad it was helpful!
    1
  1157. Thanks!! CDS can be tough to learn since the screens are constantly changing as they morph from all Dynamics screens to a blend to a final modern interface. --Brian
    1
  1158. Thank you!
    1
  1159. Unfortunately not yet but you can see hints of where they're going to allow that in things like Dataverse in Teams, where you can see relationships.
    1
  1160. Here you go https://support.microsoft.com/en-us/office/send-a-form-and-collect-responses-381935d9-ba9c-429e-b8cb-2de6714a75a0
    1
  1161. Glad it was helpful!
    1
  1162. Glad you enjoyed it
    1
  1163. Ideally once you're ready, you'll want to migrate that into production. For dev, you might want to backwards migrate to a developer environment so your trial doesn't run out during dev.
    1
  1164. Welcome aboard! Thank you!
    1
  1165. Any time
    1
  1166. Hi there. You would need to contact the creator of this visual. Thanks!
    1
  1167. You're so welcome!
    1
  1168. Yes, its been tweaked quite a bit and is easier. When you create a table in dataverse now, you now will select New --> Table --> External Table.
    1
  1169. Glad it was helpful!
    1
  1170. Thanks for the feedback
    1
  1171. Thank you for watching!
    1
  1172. Thanks a lot! -Mitchell Pearson
    1
  1173. You are most welcome!
    1
  1174. Glad you liked it!
    1
  1175. You bet. Most people have a Client Portal button on their site and just link to it.
    1
  1176. There's an option to see notes under metadata or you can also use a file data type to just show it natively :).
    1
  1177. Check out video 3 in the series on how to fix that. :)
    1
  1178. Great to hear!
    1
  1179. Yes, absolutely. You can set any field with JScript. The code of course would look different for other fields.
    1
  1180. I downloaded the icons. You’ll find lots of websites that have these available if you search. The resolution will depend on your canvas size and machine that it’s presented on so it’d be difficult for me to answer that for you.
    1
  1181. Hi there. Our consultants suggested trying to figure out what logging service is used to log this information and then start there with debugging. If you need further help, please reach out to sales@pragmaticworks.com.
    1
  1182. You're very welcome
    1
  1183. Thanks a million!
    1
  1184. I'm afraid not at this point. It can be a lookup column though.
    1
  1185. Glad you like them! Thank you!
    1
  1186. Thank you Martin, we are glad you think so!
    1
  1187. Hi there. This video may help out https://www.youtube.com/watch?v=m0XLY8wqJas&t=14s&pp=ygUZaHRtbCBwb3dlciBhdXRvbWF0ZSBlbWFpbA%3D%3D
    1
  1188. You're welcome!
    1
  1189. Sure, that warning means that the form is in Edit mode instead of New mode. So, click on the form, and change the Form MOde (Default MOde) from Edit to New. You might have to flip back and forth to make it fly.
    1
  1190. Thanks for watching!
    1
  1191. Thanks!
    1
  1192. Glad you enjoyed!
    1
  1193. No problem
    1
  1194. When the column name = the table name, that's your primary key and you can look in the URL when selecting a record to see that GUID.
    1
  1195. You are welcome!
    1
  1196. Thanks for watching!
    1
  1197. .PBIX for PBI files.
    1
  1198. Hi Samantha, we are glad to hear that. I am not sure if you know, but we are offering a 1-day FREE "Understanding DAX Concepts with Power BI" event on October 8 from 11am-2pm EST. To sign-up, please visit: http://learnwiththenerds.com/
    1
  1199. Yes, I cover that topic quite often. SQL Server - Pro : Cheap, flexible and can be scaled to whatever you want. Con: Requires more dev work to build what you can in Dataverse. Dataverse - Pro: Included in your plan, scales well, lots of plumbing built in, auditing, attachments Con: After you go over your plan's quota, it's expensive, must have for model driven apps and portals
    1
  1200. The workaround I'll typically do is create a view in SQL Server on those tables. For Dataverse, you can do subreferences or create collections to make it work.
    1
  1201. Glad you enjoyed it!
    1
  1202. I've done a ton of videos in our play list about making apps just like it but not this app in particular. - Brian
    1
  1203. You are welcome!
    1
  1204. Hi Samidurai, the issue seems to be connectivity to the source database on his laptop. Not sure if this is permissions related or something else. I would try connecting to the database locally using SQL Server Management Studio. If this is successful, that is the method and credentials that should be used for the “source” database step. A couple of clarifying questions are: • What is the source SQL Server version? • What permission level do you have on the SOURCE database (the one on your laptop). - In the example used in the video, my login was part of the sysadmin Server Role - Database role membership was db_owner, public • What permission level do you have on the Azure SQL DB side? - On the Azure side, I was Server Admin. Samidurai, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://success.pragmaticworks.com/ondemandlearning-free-trial
    1
  1205. :) The pressure of live vids gets me.
    1
  1206. You are welcome!
    1
  1207. Hi, we are glad to hear you liked this video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1208. We are glad to help! I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1209. Thanks for watching!
    1
  1210. Its free forever :)
    1
  1211. Glad it was helpful!
    1
  1212. Thank you!!
    1
  1213. :) THanks!
    1
  1214. Thanks again!
    1
  1215. Glad to hear it!
    1
  1216. Not sure why they are slow but check our videos and classes on Azure Data Factory! :)
    1
  1217. I haven't tried Oracle Fusion but check out any limitations in the docs. It should work with nearly any connector that you can get to work in Power Apps/Power Automate. So if you are able to build basic apps against your Fusion system, you should be golden.
    1
  1218. You can find the file here: https://mitchellpearson.com/2017/08/04/power-bi-problem-design-solution-text-search/
    1
  1219. Thanks so much! - Brian
    1
  1220. Glad it was helpful!
    1
  1221. You would need a license of each of the tools to make this work.
    1
  1222. Thanks for watching!
    1
  1223. Thanks for watching!
    1
  1224. Awesome, thanks for watching and commenting! - Mitchell
    1
  1225. For me, it was fixed with the default property so when you hit the screen, it knew where to go. I could also have fixed it with TemplateFill to give the illusion it's been clicked earlier. Ultimately, I created a lot of output properties to hold the row that was selected.
    1
  1226. Thanks James, glad this video was helpful!
    1
  1227. You can. You can build out the tabs based on a collection or table which honors that condition you have.
    1
  1228. We are glad you enjoyed the video! Thank you.
    1
  1229. Glad you enjoyed it!
    1
  1230. Glad it helped!
    1
  1231. It will show up in the outbox of whoever runs the flow.
    1
  1232. Hi John. I was surprised by that as well but yes, I didn't have to set permissions. I did have to set the connection permissions though at make.powerapps.com. - Brian
    1
  1233. In this example it would create a new account upon doing that. Their best bet is to authenticate with their regular account and then add the other form after the fact under External Providers.
    1
  1234. Hi Noah, I'd recommend posting or upvoting the idea here. https://ideas.powerbi.com/ideas/
    1
  1235. Thanks for watching!
    1
  1236. Happy to help! - Brian
    1
  1237. You're welcome!
    1
  1238. Thank you for the feedback!
    1
  1239. Glad you liked it! Thanks!
    1
  1240. Yes. :)
    1
  1241. Thanks, Jim. We are glad to hear that! I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1242. Thank you so much 😀
    1
  1243. Glad it helped!
    1
  1244. So nice of you! Thanks!
    1
  1245. Thank you too!
    1
  1246. You can unselect the gallery and reselect the entire gallery again typically. Alternatively, just select the data source on the right pane.
    1
  1247. It would be your list rows action.
    1
  1248. That would have to be automated with PowerShell scripts.
    1
  1249. Glad you enjoyed it!
    1
  1250. You are correct ;)
    1
  1251. Make sure you're not patching into the currency field that has Base in the name. This is for multi-currency and should not be used. "It's not about that base, about that base, about that base" :). -Brian
    1
  1252. You’re welcome 😊
    1
  1253. Hayden, if you look at the video 3 minutes in you can see that the data needs to be stored in a parent-child relationship for it to be used within this video
    1
  1254. Hi @Antony Saputra, no worries about questiosn! If I understand your question correctly, you can place any icon, button or whatever or on the screen and then the OnSelect event would be something like Navigate(ScreenName) to push users to the other screen. For full details, you can see this one document: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-navigate
    1
  1255. Glad you enjoyed it!
    1
  1256. You're welcome!
    1
  1257. There are a few ways to accomplish this depending on your system setup. We would be happy to help in a virtual mentoring session, please email training@pragmaticworks.com for more information! Thank you for watching! 🙂
    1
  1258. Glad you enjoyed!
    1
  1259. Many thanks!
    1
  1260. Glad you liked it!
    1
  1261. You're welcome! We are happy to help!
    1
  1262. Thanks for the input, Joes.
    1
  1263. Glad it was helpful!
    1
  1264. FREE DAX Conference on October 8 from 11am-2pm EST. Learn how to create effective DAX formulas that will help you get the most out of your Power BI data during this FREE event. If you want to learn how to master DAX concepts and calculations, this event is for you. Sign-up now: http://learnwiththenerds.com/
    1
  1265. Glad you enjoyed it!
    1
  1266. Hi @Jimbo, the owner of records created through Portals is System because logins to Portals are Contacts and not Users (they don't have a license technically). That said, the Vaccine system uses a column called Contact to log the Portal user who owns the vaccine card/test. Hope that helps! -- Brian
    1
  1267.  @disturbedcarrot  Thanks!
    1
  1268. Glad it was helpful!
    1
  1269. Thanks!
    1
  1270. Sure, I built that a while ago: https://www.youtube.com/watch?v=9x3aJkV0s1Q
    1
  1271. Glad you found it useful!
    1
  1272. That should be something you do in Dev.
    1
  1273. Glad it was helpful!
    1
  1274. Glad you enjoyed it!
    1
  1275. Glad to hear that
    1
  1276. Glad it was helpful!
    1
  1277. Happy to hear you enjoyed it (:
    1
  1278. Not that I'm aware of.
    1
  1279. Glad it was helpful!
    1
  1280. It does not yet since it only passes the query through to the underlying data source.
    1
  1281. You can go to File --> Setting --> Screen Layout Orientation. There you can change how it's sized but if you built the app with a wizard, the options you see here might be more limited.
    1
  1282. You're very welcome!
    1
  1283. Thanks for the comment. We are glad the video was helpful. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1284. Hi there. I believe it is not selected correctly because this is a pretty standard configuration you must do to use this.
    1
  1285. True, as of right now it's only available for organizations with Copilot for Microsoft 365.
    1
  1286. Glad you enjoyed!
    1
  1287. You can access the full course here https://pragmaticworks.com/courses/pl-300-microsoft-power-bi-data-analyst-review
    1
  1288. Unfortunately, not at this time. Mainly because a portal is a collection of records it has to be packaged differently.
    1
  1289. Thanks!
    1
  1290. Thanks, Manish! We are glad to hear that you liked our video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1291. Thank you. It means a lot!
    1
  1292. Yes, there would still need to be at least one Power BI Pro license to share solutions in event if you have Power BI Premium. Philippe, we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://success.pragmaticworks.com/ondemandlearning-free-trial
    1
  1293. Thank you!
    1
  1294. Glad it helped!
    1
  1295. You bet since itt's the same database behind the scenes.
    1
  1296. Glad you liked it!
    1
  1297. Glad you enjoyed!
    1
  1298. The Advanced DAX course has been published - https://pragmaticworks.com/product/advanced-dax
    1
  1299. Glad you enjoyed (:
    1
  1300. Glad it was helpful!
    1
  1301. Typically Business RUles can solve that problem for you if it's a conditional rule. You can also create two forms and secure each one based on role.
    1
  1302. You'd have to use variables to drive that. So, wire which variable is "lit up" based on the variable and pass in that variable to the Navigate function.
    1
  1303. Fantastic! Thanks for the comment. - Brian
    1
  1304. Glad you liked it!
    1
  1305. Glad it helped!
    1
  1306. Yes, you will need to set up and configure a Self-Hosted Integration runtime so you can create a linked service to your on-prem environment.
    1
  1307. Thank you!
    1
  1308. Hi Rafael, thanks for the feedback. That means a lot to us. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1309. You can create Dark themes today but Dark mode to the entire Power BI Desktop is coming as well very soon.
    1
  1310. Our pleasure!
    1
  1311. Most welcome!
    1
  1312. Glad you liked it
    1
  1313. Obrigado! I'm glad you enjoyed it!
    1
  1314. The data presented is dictated based on row-level security implemented as part of the deployment of Power BI Embedded, plus any slicers or filters you apply to the reports themselves. Your scenario would require a specific user account for the customer-facing application for each unique data set you’d like to present. If it’s ok for one store to see another store’s data, then you could use slicers to do that filtering, if not, you should use unique logins.
    1
  1315. The user credentials used to authenticate are passed via token from the application to the Power BI report with Azure active directory giving access to the row-level data. More information can be found here: https://docs.microsoft.com/en-us/power-bi/developer/embedding
    1
  1316. What's your data source in your case?
    1
  1317. Great to hear!
    1
  1318. You're welcome!
    1
  1319. Glad it can help hopefully.
    1
  1320. Hi Joel, thank you! Please, fill out the contact us form on our website and someone from our team will be reaching out to you. https://www.pragmaticworks.com/about/contact-us/
    1
  1321. My pleasure!
    1
  1322. It's coming very soon but will free forever.
    1
  1323. Thank you for watching!
    1
  1324. Thank you!
    1
  1325. Thanks! Glad you enjoyed, definitely more to come!
    1
  1326. Glad you enjoyed!
    1
  1327. It does auto save / publish. At this time, there's no manual way of doing it. I've put that as a feature request too :)
    1
  1328. Glad to hear it!
    1
  1329. Sure, you could read from a view and write to another table using the Patch command.
    1
  1330. You're welcome!
    1
  1331. Yeah, I'm afraid they'll need either a Dynamics license or a paid Power Apps license to accomplish that. The other option is a Portal.
    1
  1332. With PowerApps it can be saved wherever you wish. You can create an action that would save to the underlying tables or you could save to a completely different area like a one-off table or staging.
    1
  1333. Glad you enjoyed!
    1
  1334. Thank you, glad you have been enjoying them!
    1
  1335. The behavior you're speaking about is delegation. There are a ton of vids on it but by default it will pick the first 500 rows but can be increased to 2k. This only occurs when the query like a Search can't be translated. So it can see beyond 2K rows if you manipulate your queries to be accepted by SharePoint.
    1
  1336. Consulting Data Help Desk service - it will help you https://www.pragmaticworks.com/consulting-services/data-help-desk/
    1
  1337. Glad it was helpful! Thanks for learning with us!
    1
  1338. Our pleasure!
    1
  1339. Wow, thank you!
    1
  1340. https://devinknightsql.com/2015/06/16/creating-a-date-dimension-with-power-query/
    1
  1341. Great feedback Ahmed, I'm glad you like the videos! -Mitchell
    1
  1342. Glad you enjoyed it!
    1
  1343. Glad you enjoyed it!
    1
  1344. Glad it was helpful!
    1
  1345. Glad it was helpful!
    1
  1346. Glad it was helpful!
    1
  1347. It is in the description and it's the pinned comment here as well.
    1
  1348. It is called Zoomit! Thanks for watching!
    1
  1349. Thanks! -Mitchell Pearson
    1
  1350. Sure thing. You'll just need to change the forms to edit mode and set the item property from each form to the record you want edited.
    1
  1351. You're welcome!
    1
  1352. You would do a Filter command to connect those two table. So something like in Gallery2 Filter(DataTable2, YourPrimaryKeyColumn = Gallery1.Selected.ForeignKeyColumn)
    1
  1353. Hi Ram... thanks for the feedback. We are glad to hear that this video was helpful to you. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1354. Glad you enjoyed!
    1
  1355. Glad you liked it!
    1
  1356. You cannot wrap a Power BI item into solutions at this point. Always an opportunity to change later though.
    1
  1357. Glad you enjoyed!
    1
  1358. Thanks!
    1
  1359. Here’s a reference link to learn more. https://docs.microsoft.com/en-us/learn/modules/logic-apps-and-custom-connectors/
    1
  1360. Glad you liked it!
    1
  1361. LOL Living in FL i can fill ya. Thanks!
    1
  1362. Glad it was helpful!
    1
  1363. You are welcome!
    1
  1364. Thank You Tina! -Mitchell Pearson
    1
  1365. Unfortunately at this time no. However you can use XRM Toolbox (free tool) and a feature called SQL 4 CDM that can read/update/delete. You can download it from https://www.xrmtoolbox.com.
    1
  1366. You're welcome! Thanks for watching!
    1
  1367. We are glad to hear that you liked this video.
    1
  1368.  @bnemetchek  As of today (still preview status), you have recreate the dataverse entity by going to the advanced view to create the entity. - Brian
    1
  1369. You bet! One of the properties is the view you want to use.
    1
  1370. Strange, I'll dig into it but I film video at 4k and screen cap at 1080. So something must be going off in the encoding process I guess.
    1
  1371. Unfortunately you cannot do Copilot Studio with a personal account.
    1
  1372. Thanks for the feedback.
    1
  1373. Thank you for your kind words!
    1
  1374. Yes it will
    1
  1375. Hey Rodrigo, Dustin and I had a lot of fun doing this webinar, glad you enjoyed it!
    1
  1376. If you're going to try to build a Power Apps Portal, you'll need a Portals license for anonymous users and one for authenticated users. In the US that's a total of $300/month for the first batch of 100K viiews with daily logins.
    1
  1377. You can merge that into a single screen or different screens, it's completely up to you.
    1
  1378. You're welcome!
    1
  1379. Glad you enjoyed it (:
    1
  1380. Awesome, thank you!
    1
  1381. You're very welcome!
    1
  1382. It is definitely an awesome tool, hope you enjoy it! - Mitchell
    1
  1383. Thanks for watching!
    1
  1384. Glad it was helpful!
    1
  1385. Glad you enjoyed!
    1
  1386. Glad you enjoyed it!
    1
  1387. That GUID is the ID for the row you're looking at so that's how it links to it automatically.
    1
  1388. That's strange. No I only encountered that in the early days of Dataverse connectors for Power BI.
    1
  1389. Thank you for watching!
    1
  1390. Glad it was helpful!
    1
  1391. Glad it was helpful!
    1
  1392. Glad you enjoyed!
    1
  1393. Glad it was helpful!
    1
  1394. Thanks for your input!!
    1
  1395. Thanks for the feedback. I am glad you liked it!
    1
  1396. Solutions can do that across multiple apps, flows etc.
    1
  1397. Thanks for watching!
    1
  1398. Thanks John!
    1
  1399. Thanks for watching!
    1
  1400. Thanks for watching!
    1
  1401. Glad we were able to help!
    1
  1402. Glad it helped!
    1
  1403. Thanks Tim, glad you enjoyed it!
    1
  1404. Hi Mohammed, we are glad to hear this video was helpful to you. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1405. Glad you enjoyed!
    1
  1406. No, you can actually make this driven by your data model. Checkout this longer webinar for how to solve this scenario. https://www.youtube.com/watch?v=8d_YQKRpJEY&t=2017s
    1
  1407. Makes sense!
    1
  1408. Glad it was helpful!
    1
  1409. Welcome!!
    1
  1410. It's whatever permission you wish them to do. So reader/writer rights like you did should be enough. Try this one video where you can build an app from scratch using my DB: https://www.youtube.com/watch?v=Dv_mGWwCiLU&list=PLcwrIWK7WBcRyFBAFeC-Ws8kJYAGTc8Qi
    1
  1411. Sure thing @Henk here you go: https://powerapps.microsoft.com/en-us/blog/powerapps-ten-reusable-components/
    1
  1412. Hi Abednego, Yes. If you double click on the field name in the field list for the visual you can rename it. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1413.  @abednegosantoso  That's great to hear! We are glad to help.
    1
  1414. Hi Vasilisa, we are glad you liked the video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1415. Thank you for your kind words!
    1
  1416. Glad you enjoyed it!
    1
  1417. Thanks so much! You made my day.
    1
  1418. Glad you enjoyed it!
    1
  1419. To achieve the same thing in a Power App Portal you want to use Portal Management app and an Advanced Form.
    1
  1420. Make sure the field is unlocked. You can right click on the card to do so.
    1
  1421. Thanks for visiting
    1
  1422. You should be able to find everything here: http://blog.pragmaticworks.com/power-bi-custom-visuals-drilldown-cartogram Thanks!
    1
  1423. Glad you enjoyed!
    1
  1424. Have fun! It's a great tool.
    1
  1425. Awesome, thank you! - Brian
    1
  1426. Hi! The duplicate key value error you are getting is related specifically to the column you are building your relationship on. Your dimension table can have duplicate values, for example on Country or in the case of Date on the Year, Quarter and Month. However, the relationship from the date table to the fact table isn't on Year or Quarter, it's on Date or DateKey and the datekey is unique in that table. Hope this helps. -Mitchell
    1
  1427. FREE DAX Conference on October 8 from 11am-2pm EST. Learn how to create effective DAX formulas that will help you get the most out of your Power BI data during this FREE event. If you want to learn how to master DAX concepts and calculations, this event is for you. Sign-up now: http://learnwiththenerds.com/
    1
  1428. Much appreciated!
    1
  1429. Hi, this course is already available on our Elite Package. Please, visit: https://www.pragmaticworkstraining.com/?add-to-cart=208573 to sign-up.
    1
  1430. You can also sign-up for our 7-day free trial. With the free-trial you will be able to watch the first 3 videos of the Advanced Azure Data Factory Class. To sign-up for our free trial, please visit: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg . We also offer more than 60+ courses in Azure, Power BI, SQL Server, Data Science, Business Intelligence and much more with the Elite Package. You don't need to enter your credit card and you will get instant access for the free trial. Please, let me know if you have any additional question. Thanks and have a great day!
    1
  1431. Glad to help, Victor. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1432. Works either way. For example, you might want an anonymous form for a contact us form.
    1
  1433. Thanks for watching!
    1
  1434. You are so welcome!
    1
  1435. Glad it was helpful!
    1
  1436. Glad you enjoyed this!
    1
  1437. Many thanks!
    1
  1438. Glad it helped!
    1
  1439. Can you post your code. We might be able to help.
    1
  1440. Hi Cecilio, we are glad to help! I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1441. Glad I could help!
    1
  1442. Glad you enjoyed :)
    1
  1443. Thanks for the feedback, Kashif. I just mentioned above to Mahesh that we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more in case you are interested. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1444. Thanks!
    1
  1445. My pleasure!
    1
  1446. Thank you 🙂
    1
  1447. Are you in Europe? If(ThisItem.Price>1000,OrangeRed,Gray) or for alternate/European locales: If(ThisItem.Price>1000;OrangeRed;Gray). You can end the semicolon in EU with a double ;;
    1
  1448. Glad you enjoyed!
    1
  1449. You might not have admin rights in the environment to import perhaps. I do have a SharePoint version of this too if that would help? It requires less access to perfrom.
    1
  1450. Glad it was helpful!
    1
  1451. Our pleasure!
    1
  1452. Awesome, thank you! We already have a bunch of series like this you can find ono our channel based on what you're looking for. Thanks!
    1
  1453. Glad you like them!
    1
  1454. Hi Charles. You can find it here: http://blog.pragmaticworks.com/power-bi-custom-visuals-heatmap Thanks!
    1
  1455. You're so welcome!
    1
  1456. Glad it was helpful!
    1
  1457. It hasn't been announced yet by MS but will do!
    1
  1458. Oh wow, you might take the award :)
    1
  1459. Prakso, we are glad to hear that you liked the video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://success.pragmaticworks.com/ondemandlearning-free-trial
    1
  1460. Glad it helped!
    1
  1461. Yes of course you can build an Excel spreadsheet faster but the point is presenting it as an interactive app on the web so it's a bit of apples and oranges.
    1
  1462. Bom dia Paulo. Que bom saber que o video te ajudou. Obrigada!
    1
  1463. Glad it was helpful!
    1
  1464. Most welcome!
    1
  1465. Thank you!
    1
  1466. No, the only way to see live updates on a Power BI Report would be with Direct Query. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://success.pragmaticworks.com/ondemandlearning-free-trial
    1
  1467. Of course! Thanks for watching!
    1
  1468. You shouldn't need to sign in to save your Power BI Desktop file. You can save it locally as a .pbix file.
    1
  1469. Thanks! We are glad you liked it.
    1
  1470. Glad you liked it!
    1
  1471. Thanks. We are glad to hear this video was helpful to you. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1472. Glad it was helpful!
    1
  1473. Yes... they would need either a Power BI Pro license or Premium to cover them.
    1
  1474. Glad you enjoyed it!
    1
  1475. We do have a 9 hour PL-300 course found on our On-Demand Learning platform here: https://learning.pragmaticworkstraining.com/checkout
    1
  1476. Here's a better link: https://pragmaticworks.com/pl-300-microsoft-power-bi-data-analyst-review?guid=aebf63ad-a394-4e57-82d9-0302ae0903d2
    1
  1477. Glad you enjoyed!
    1
  1478. Sure, you can string approvals together at "this time" however more coming soon to help that scenario.
    1
  1479.  @Oseking_01  Try copy and pasting the text of the link. YouTube unforunately changes the links we've shared when you just left-click on them. Grab the text of the link. Copy it and paste it.
    1
  1480. Thanks for watching!
    1
  1481. Any time
    1
  1482. Sweet! Glad we could help!
    1
  1483. Glad you enjoyed (:
    1
  1484. We do have that today. We have the DP-600 CertXP exam prep as well. Austin has an end to end class and Manuel just released one for Databricks too. Hope that helps! You can use AUSTIN40 for a 40% discount.
    1
  1485. Wow, thanks! Glad you enjoyed it!
    1
  1486. We are glad to hear that. Kaushik, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1487. Unfortunately no.
    1
  1488. FREE DAX Conference on October 8 from 11am-2pm EST. Learn how to create effective DAX formulas that will help you get the most out of your Power BI data during this FREE event. If you want to learn how to master DAX concepts and calculations, this event is for you. Sign-up now: http://learnwiththenerds.com/
    1
  1489. Hi @nepe1024, it supports read/write/delete/insert. You can also use a Patch command to update/insert.
    1
  1490. Good to hear! Thanks for watching!
    1
  1491. Hi Ben, anyone that logs in must have a contact record I'm afraid. Even if you log in with Azure AD, it creates a stub record in the table for you. That said, you don't have to log that the logged in user saved a record. It could be saved anonymously if that helps. - Brian
    1
  1492. Thanks so much! Stay tuned for the rest of the series!
    1
  1493. Thank you!
    1
  1494. Sure, I'm making one today on the Facebook authentication and I'll include it in that one.
    1
  1495. That's all out of the box with Pages. What are you wanting to customize?
    1
  1496. Thank you! Will do!
    1
  1497. Glad to hear that
    1
  1498. Glad to help!
    1
  1499. I'm afraid all the platforms like Google have similar reports.
    1
  1500. Glad you liked it!
    1
  1501. Thank you for watching!
    1
  1502. Glad you enjoyed!
    1
  1503. Hi Ahmad, thanks for the feedback. We are glad to hear that you liked this video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1504. Glad it was helpful!
    1
  1505. Done: https://www.youtube.com/playlist?list=PLcwrIWK7WBcT8lGkj6cCeNh9Eilmltu_k
    1
  1506. You're welcome!
    1
  1507. Please, check this website: https://poweronbi.com/
    1
  1508. You are very welcome!
    1
  1509. Glad you enjoyed it!
    1
  1510. You'll see these a number of ways but a common one is a project that has sub-projects.
    1
  1511. Great to hear!
    1
  1512. Thanks Gregory! -Mitchell Pearson
    1
  1513. Hey Aneel, any specific topic you're looking for :) -Mitchell
    1
  1514. Yes 2 ways: if the user doesn't have permissions to it in their security role, it will hide. You can also use the Ribbon Workbench in XRM Toolkit application to hide those.
    1
  1515. We are glad to hear that this video was helpful for you! Tiago, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1516. When you say link, do you mean a hyperlink? To do that, you'd use the Launch command.
    1
  1517. Thanks!
    1
  1518. Great to hear!
    1
  1519. That's awesome Steven, I will check this out and thanks for sharing! -Mitchell Pearson
    1
  1520. I assume you created the Students web role. If not, please review the previous video in this series to create that. If you have, click the magnifying glass next to the search to see all the roles.
    1
  1521. Awesome, thank you!
    1
  1522. Looking into it now!
    1
  1523. Thanks for watching!
    1
  1524. Glad to hear that!
    1
  1525. We will!
    1
  1526. Glad it was helpful!
    1
  1527. Glad you enjoyed!
    1
  1528. You're welcome (:
    1
  1529. Absolutely. I have a follow up video in this series about that.
    1
  1530. Glad I could help!
    1
  1531. Glad it helped
    1
  1532. My pleasure
    1
  1533. We are glad you liked it. Raju, our On-Demand Learning has courses on Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. It's a great way to learn at your pace, on any device! Check it out with our FREE trial: https://success.pragmaticworks.com/ondemandlearning-free-trial
    1
  1534. Unfortunately, you'd have to check of the related tables to get them and it would not be selective about what records it pulled in those tables. --Brian
    1
  1535. You can see how to dialog boxes here: https://www.youtube.com/watch?v=SaDEVOgOlYY&
    1
  1536. Glad it helped!
    1
  1537. Glad it was helpful!
    1
  1538. We are glad to hear that. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1539. Thanks, Suraj. We are glad you liked our tutorial. About your question, yes. This is supported. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1540. Glad you like them!
    1
  1541. Awesome, thank you!
    1
  1542. Thank you!
    1
  1543. Glad it was helpful! Thanks for learning with us!
    1
  1544. Yes, you're correct! Great job there.
    1
  1545. Great! That's one of my next two videos. I'm still exploring that feature myself.
    1
  1546. Thanks for watching!
    1
  1547. We have a vid on how to upload content but not how to download. I'll add it to my list :). BK
    1
  1548. You're welcome, thanks for watching! -Mitchell
    1
  1549. If you want a full walkthrough on creating a Power BI report, this course covers everything you need to get started! https://youtu.be/Dk25lwdTKow
    1
  1550. You're very welcome!
    1
  1551. Thank you, I will :)
    1
  1552. No problem!
    1
  1553. I'm about to start a series on that as well. I have 5 or so videos and they start here: https://www.youtube.com/watch?v=2EXSdJw1TEY&t=1s
    1
  1554. You would just import each sheet in the connectors area. To update both sheets at the same time you can use SubmitForm or Patch
    1
  1555. My pleasure!
    1
  1556. Glad it was helpful!
    1
  1557. Hi Stalin, this is part of a series I believe that you can find in the Playlist but it starts here I believe: https://www.youtube.com/watch?v=rkPVrrA-qFQ&list=PLcwrIWK7WBcRyFBAFeC-Ws8kJYAGTc8Qi&index=6
    1
  1558. You can download the free Power BI Desktop here. https://www.microsoft.com/en-us/download/details.aspx?id=58494
    1
  1559. It might require some reformatting but yes that would work. I did it that way to make sure that my spell checker was run :)>
    1
  1560. They just deployed a big change this week so it might be in that process.
    1
  1561. Glad it was helpful! Thanks for learning with us!
    1
  1562. Try just copy and pasting the text of the link into Power BI instead of right-clicking the link. YouTube sometimes adds their own things into links when you just right-click and copy.
    1
  1563. Thanks! We are glad to hear that you liked our video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1564. THanks! You made my day . Makes it worth building these. - Brian
    1
  1565. Glad you liked it!
    1
  1566. You got this!
    1
  1567. Glad it helped!
    1
  1568. Glad it was helpful!
    1
  1569. Hey John, sorry about that! I added it to the description. My apologies.
    1
  1570. Thank you for the kind words!
    1
  1571. Melissa, we are so glad you found the video helpful! Thank you for watching and commenting.
    1
  1572. Hey Daniel, my apologies! I added a link to the book on Amazon.
    1
  1573. For Power Apps Portals, you buy a login pack if you want users to be authenticated. You can also invite a user to your non portal app if you wish. Here you have to license each user vs a pack of thousands of logins.
    1
  1574. For HTML, yes. If you're comfortable here for CSS, it won't matter. I typically do in the designer so i don't have to sync :).
    1
  1575. Awesome! Glad you enjoyed our videos! -Mitchell Pearson
    1
  1576. My pleasure!
    1
  1577. Thanks for watching! Glad you enjoyed.
    1
  1578. Glad to be of help!
    1
  1579. Thanks for the feedback! Just to clarify, do you envision the ability to load a dataset of all offices/cubes and slot people into those spots by day?
    1
  1580. Glad it helped!
    1
  1581. You're very welcome!
    1
  1582. Glad you enjoyed it!
    1
  1583. Glad you enjoyed it!
    1
  1584. Glad it helped!
    1
  1585. Thanks, Cecilio. We are happy to help. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1586. Hi Dev. Are you asking for if our company does end to end projects with data that you provide? If so, we do offer that service and they are referred to as hackathons. Feel free to email me at mpeterson@pragmaticworks.com if you want to talk about that.
    1
  1587. Thank you! Glad it was helpful!
    1
  1588. You are very welcome!
    1
  1589. Thanks for watching!
    1
  1590. FREE DAX Conference on October 8 from 11am-2pm EST. Learn how to create effective DAX formulas that will help you get the most out of your Power BI data during this FREE event. If you want to learn how to master DAX concepts and calculations, this event is for you. Sign-up now: http://learnwiththenerds.com/
    1
  1591. You are welcome
    1
  1592. No problem!
    1
  1593. Try just copy and pasting the text of the link into Power BI instead of right-clicking the link. YouTube sometimes adds their own things into links when you just right-click and copy.
    1
  1594. Thanks!
    1
  1595. Here are the attached student files to help you follow along! 🙂https://tinyurl.com/5dwnbrje
    1
  1596. Glad you enjoyed the video! Thanks for learning with us.
    1
  1597. Glad it was helpful!
    1
  1598. Licensing was JUST released so good timing! Here's the info on that: https://powerapps.microsoft.com/en-us/blog/new-licensing-options-for-powerapps-and-flow/. It's based on consumption.
    1
  1599. Unfortunately no. It's essentially HTML but you could build a custom command that linked to those external systems as an alternative.
    1
  1600. Nick, we are glad you liked the video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1601. Glad it helped!
    1
  1602. We are glad we were able to help! Bijou, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://success.pragmaticworks.com/ondemandlearning-free-trial
    1
  1603. Thanks! We are glad to hear it!
    1
  1604. Hi John! No, in this case, I started from scratch in this video. Once you have those two items pasted in the site settings it should just show up. You could try to restart the service but that shouldn't be needed. Generally it shows up in less than a minute though.
    1
  1605. The table is a physical table you can use in Power BI or in Power Apps, I use Power FX to do something like CompanyGallery.Selected.Contacts (where it pulls the middle table to find what contacts are at what company.)
    1
  1606. My pleasure!
    1
  1607. It sure would. Unfortunately, this is a beginner video to get people started. We have other videos in the playlist though that cover components and responsive apps.
    1
  1608. Glad to hear it!
    1
  1609. Glad to be of help!
    1
  1610. Glad you enjoyed it!
    1
  1611. You're welcome! Glad you enjoyed it!
    1
  1612. Best of luck! Thank you for watching!
    1
  1613. Sure ,reach out to me in email bknight<AT>pragmaticworks.com. It's probably in your junk folder.
    1
  1614. It's now called Tables and Connections are seperate.
    1
  1615. Hi, the SubmitForm function can submit to either one of those two. Check out this playlist to see a video on exactly what you're looking for: https://www.youtube.com/watch?v=CubdnBklOzg&list=PLcwrIWK7WBcRyFBAFeC-Ws8kJYAGTc8Qi
    1
  1616. I just retried and it now looks like there's been a slight alteration. The message now states "Target environments must be managed". So it might have let you work this on the source system but when it comes to the targets, they'll all need to be managed. Hope that clarifies . --Brian
    1
  1617. My pleasure!
    1
  1618. Not at this time I'm afraid.
    1
  1619. Glad you liked it!
    1
  1620. Thank you!
    1
  1621. Of course! Thanks for watching!
    1
  1622. There's quite a few ways you can implement that. You can use the built in charting to count to build the bar chart you're looking at and counting the rows or you can get a more boring view by doing a rollup column that respects the hierarchy. You can also use a custom PCF component to visualize that. You can find those components at https://pcf.galleries
    1
  1623. Yes, you can download the Power BI Desktop for free here: https://www.microsoft.com/en-us/download/details.aspx?id=58494
    1
  1624. Glad you enjoyed!
    1
  1625. One branch is asking for the approval and the other parallel is doing reminding. If you merged it, it wouldn't fire the right timing on the reminders.
    1
  1626. Hi, this course is offered on our On-Demand Learning Platform. You can start your free trial by signing up through this link https://tinyurl.com/4xyed4wv :) Thanks for watching!
    1
  1627. Yes this is recorded.
    1
  1628. Most certainly still relevant and more so now. They made a major update about 7 months ago which made it even better. https://github.com/microsoft/powerapps-tools/tree/master/Tools/Apps/Microsoft.PowerApps.CodeReview
    1
  1629. I just checked and if you're signed in the class appears to be working here. That said, I don't want to give you the "works on my box excuse" :). Shoot us an email at ondemandtraining@pragmaticworks.com and we can troubleshoot it for you.
    1
  1630. Thanks!
    1
  1631. Our pleasure!
    1
  1632. Yes, there's an Adobe Signature connector for that. You can see more info here: https://acrobat.adobe.com/us/en/business/integrations/microsoft-powerapps-flow.html
    1
  1633. A power app can use a sproc via a Power Automate flow. It can also be called ini Power BI. I have a few videos on both of those in the playlist.
    1
  1634. Wow, thanks!
    1
  1635. That diagram type visual is not available in Power Apps / Dataverse.
    1
  1636. Glad to hear you enjoyed!
    1
  1637. Glad it was helpful!
    1
  1638. Yes correct. Now Table Permissions are turned on by default. Checkout the next video in this series where it shows how to fix that for you. Let me know if that doesn't answer it though!
    1
  1639. Welcome!
    1
  1640. Hi Mohanad, There is no version-history feature built into the deployment pipelines feature. We recommend saving the underlying Power BI Desktop files to Onedrive for Business or Sharepoint – where versioning is available. From this environment you are able to restore previous versions of the PBIX file if the need arises.
    1
  1641. Mohanad, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
    1
  1642. Glad it helped!
    1
  1643. Thank you!!
    1
  1644. It could be a sharing violation where the spreadsheet is still open.
    1
  1645. Hi Vishvesh, 1. Yes it works for on-prem datasources. It's just passing the queries through to the underlying connector. 2. One of the largest use cases is to relate to reference data like transactional data without having to duplicate the tables. So for me, linking to a system that's your system of record for customers, students, patients is key. Then Dataverse extends those tables with children tables to those reference tables. - Brian
    1
  1646. Sure, you can use something like PAC utility or the api to do a lot of this for you as well.
    1
  1647. The nice thing about Power Apps is you can mash the data together in the app. To your second question, if the app is just using SharePoint, then nothing more than O365 Power Apps license is required but the minute you add a premium connection, the same app now needs a premium license.
    1
  1648. Thank you!
    1
  1649.  @asueilouakuru7674  YouTube comments are generally not a place to expect fast service since this is all free. If you have a more urgent need I'd recommend our Virtual Mentoring service - https://pragmaticworks.com/virtual-mentor
    1
  1650. You're welcome!
    1
  1651. This is very kind feedback Kon, thank you! -Mitchell
    1
  1652. Glad to hear you found it helpful :)
    1
  1653. You're welcome!
    1
  1654. So glad you found the video useful Joseph, thanks for learning with us!
    1
  1655. No problem! Glad you enjoyed!
    1
  1656. Here is what he is referring to. https://docs.microsoft.com/en-us/visualstudio/rtvs/?view=vs-2017
    1
  1657. Glad it was helpful!
    1
  1658. FREE DAX Conference on October 8 from 11am-2pm EST. Learn how to create effective DAX formulas that will help you get the most out of your Power BI data during this FREE event. If you want to learn how to master DAX concepts and calculations, this event is for you. Sign-up now: http://learnwiththenerds.com/
    1
  1659. I've been wondering the same thing, it's one of the great unsolved mysteries :) -Mitchell
    1
  1660. Yes, you can create a solution per customer and they can live on the same site or in different environments. It depends on how you want to segment the data. If they can't share any Dataverse data, then separate environment. You can segment by account/contact where they can only see their own data but anything you want segmented would need a segmenting id in them
    1
  1661. Mark, Azure Data Studio is designed to work only with Microsoft SQL Server or Azure SQL Database or Data Warehouse. It cannot connect to other database systems like Oracle or MySQL. Thanks for your question! I am not sure if you know, but we offer many On-Demand Learning courses, such as, SQL, Power BI, Azure, Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: https://www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
    1
  1662. Mark, I should also say that with SQL Data Warehouse you can create External references to Oracle and other database systems using a Wizard. It’ really pretty cool and it allows you to create something called a data hub with your data warehouse. This is a preview feature in studio and you can access it via the External Table Wizard.
    1
  1663. Glad you enjoyed (:
    1
  1664. Hi @Marlon, any user would need the appropriate license for the app type. Nowadays, they have changed their license to where you can pay a lower price but then pay per app.
    1
  1665. Hi, it was released before the video was posted. You can go download it now here: https://aka.ms/pbiSingleInstaller
    1
  1666. I've seen some quirks sometime where you'll need to add the Timeline component manually in the form designer when this happens.
    1
  1667. You're very welcome!
    1
  1668. You are very welcome!
    1
  1669. Sure. You can bring in another numeric column you want to base the sort order on. So a new column where the value of 1 = Prospecting, 2 = Demo Schedule, etc…
    1
  1670. Thanks Subhasis! Glad you liked it.
    1
  1671. Glad you enjoyed it!
    1
  1672. You're welcome!
    1
  1673. My pain can be your gain :).
    1
  1674. Great to hear!
    1
  1675. Your best bet is using containers to show and hide objects.
    1
  1676. Our pleasure! - Brian
    1
  1677. You turn it on at a table level and can tell it where to go at an environment-level under Advanced Settings. I show turning that on at 7:03.
    1
  1678. I apologize for the late response. I would suggest using a column and call it FY and then use a Power Automate to use the current date to populate that field.
    1
  1679. Glad you think so!
    1
  1680. Glad you enjoyed!
    1
  1681. Glad you think so!
    1
  1682. Glad you enjoyed!
    1
  1683. Thanks so much for the feedback!
    1
  1684. You are welcome! Glad we could help provide a solution for you!
    1
  1685. Our pleasure!
    1
  1686. Welcome!
    1
  1687. Glad it was helpful!
    1
  1688. The Advanced DAX course has been published - https://pragmaticworks.com/product/advanced-dax
    1
  1689. If you use a premium connection in that app, then the app will need a $10/app pass or $40 unlimited license for the app at that point. OR, they could have a Dynamics license.
    1
  1690. Unfortunately that control doesn't respect the cascade for some reason. I've reported it also.
    1