business intelligence
99 TopicsJoin the Fabric Partner Community for this Week's Fabric Engineering Connection calls!
Are you a Microsoft partner that is interested in data and analytics? After a two-week break for Ignite and Thanksgiving, be sure to join us for this week's Fabric Engineering Connection calls! Yitzhak Kesselman will be presenting on the brand-new Microsoft Fabric IQ, just announced during Ignite, followed by Shuaijun Ye with Environment Best Practices. The Americas & EMEA call will take place Wednesday, December 3, from 8-9 am PT and the APAC call is Thursday, December 4, from 1-2 am UTC/Wednesday, December 3, from 5-6 pm PT. This is your opportunity to learn more, ask questions, and provide feedback. To participate in the call, you must be a member of the Fabric Partner Community Teams channel. To join, complete the participation form at https://aka.ms/JoinFabricPartnerCommunity. We look forward to seeing you at the calls!22Views1like0Comments“8152 String or binary data would be truncated” error while running select query on a view
I have a complex view (it’s organisational so i cannot paste it here) that joins multiple tables, uses CTEs, performs logical calculations and then provides for multiple columns over which we can select. This view is based on top of multiple master tables and a transactional table. It was performing fine until today morning. But then it started throwing 8152 error. I’m assuming it’s started happening only after certain values got written to the transactional table. The funny thing is, that the view is still executing fine if I remove just one column from the select query. If i include that one column in the select query, it throws 8152 error. I spent my entire day trying to troubleshoot, but couldn’t. Unable to understand how the view is running fine but the including a column in the select query causes it to malfunction. Any insights would be much appreciated.Solved60Views0likes1CommentJoin the Fabric Partner Community for this Week's Fabric Engineering Connection calls!
Are you a Microsoft partner that is interested in data and analytics? Be sure to join us for the next Fabric Engineering Connection calls! 🎉 Sujata Narayana will be sharing a recap of Power BI announcements from FabCon Europe, followed by the latest updates on AI Functions from Virginia Roman. The Americas & EMEA call will take place Wednesday, October 15, from 8-9 am PT and the APAC call is Thursday, October 16, from 1-2 am UTC/Wednesday, October 15, from 5-6 pm PT. This is your opportunity to learn more, ask questions, and provide feedback. To join the call, you must be a member of the Fabric Partner Community Teams channel. To join, complete the participation form at https://aka.ms/JoinFabricPartnerCommunity. We look forward to seeing you later this week!41Views1like0CommentsPartner Know Before You Go to the 2025 European Microsoft Fabric Community Conference!
We can’t wait to see you at FabCon Europe 2025, taking place 15-18 September at the Austria Center Vienna in Vienna, Austria! With more than 130 expert-led sessions over three days, plus workshops 15 September, this is the largest Microsoft tech conference in Europe! Our team has been hard at work planning several partner-exclusive activities throughout the event, to help ensure the best experience possible for you, our valued partners. This Know Before You Go guide will provide all the details on how to participate in: Partner Day Partner Happy Hour 1:1 Meetings Partner Booth at Ask the Experts Partner AMA Partner Photo Scavenger Hunt Cvent Event App If you have any questions, please feel free to reach out to our team at mailto:FabricPartnersTeam@microsoft.com or through the Cvent app. See you very soon! Complete details and entry form are available at https://aka.ms/FabConEuropePartnerPhotoHunt.548Views2likes1CommentJoin the Fabric Partner Community for an AMA with Arun Ulag!
🚨 Mark your calendars now! 📅 New this year in the Fabric Partner Community, an AMA (Ask Me Anything) call series with members of the Fabric Leadership Team! 🥳 Arun Ulag, CVP of Azure Data, will kick of this new call series Thursday, September 25, from 8-9 am PT. You will not want to miss this opportunity to ask all your questions, including those related to the announcements made at #FabConEurope, provide your feedback, and more! 👏 To join theses calls, you must be a member of the Fabric Partner Community Teams Channel. Not yet part of the Fabric Partner Community? Join now by submitting the form at https://aka.ms/JoinFabricPartnerCommunity.54Views1like0CommentsSQL Server 2017 – CLR was loaded in an unsupported manner (All SSIS jobs failed)
Hi, We are facing a critical issue in our SQL Server 2017 instance. When trying to use a built-in CLR function or running SSIS-related jobs, we are getting the below error: The Common Language Runtime (CLR) was loaded in an unsupported manner. This can occur if an extended stored procedure or OLE Automation object running in SQL Server calls into managed code before the CLR integration runtime host loads the CLR. You need to restart SQL Server to use CLR integration features. Steps tried so far: Restarted SQL Server service Restarted the entire Windows Server Verified .NET Framework version (4.7.03062 installed) Confirmed CLR integration is enabled (sp_configure 'clr enabled', 1) All SSIS jobs are failing due to this issue. Any suggestions, please?109Views0likes0CommentsJoin us for the FY26 Fabric Engineering Connection Kick Off calls
Are you a Microsoft partner that is interested in data and analytics? 🚨 Then, mark your calendars now to join us for the FY26 Kick Off Fabric Engineering Connection calls, taking place Wednesday, September 3, from 8-9 am and 5-6 pm PDT and Thursday, September 4, from 1-2 am UTC. 📅 You don't want to miss all the invaluable updates and exciting announcements from Tamer Farag, Global Partner Ecosystem Lead – Microsoft Fabric, that will be provided during these calls. We've been working hard the past couple months to ensure you get all the latest and greatest info, an enhanced experience in the Fabric Partner Community Teams channel, and more! 🥳 Topics covered will include: 🙌 Improvements made to the Fabric Partner Community Teams channel 🙌 Azure Accelerate 🙌 European Microsoft Fabric Community Conference 🙌 Upcoming Partner Project Ready Workshops 🙌 Updates on partner incentives/programs 🙌 And more To join the call, you must be a member of the Fabric Partner Community Teams channel. To join, complete the participation form at https://aka.ms/JoinFabricPartnerCommunity. We look forward to seeing you in a couple days!53Views1like0CommentsJoin us for the FY25 recap and final Fabric Engineering Connection call of the fiscal year
Are you a Microsoft partner that is interested in data and analytics? Be sure to join us for the final Fabric Engineering Connection call of this fiscal year, taking place this Wednesday, June 25, from 8-9 am PDT and Thursday, June 26, from 1-2 am UTC/Wednesday, June 25, from 5-6 pm PDT. Please plan to join us as Tamer Farag, Global Partner Ecosystem Lead – Microsoft Fabric, recaps the partner news and accomplishments from FY25, along with providing some FY26 updates. Topics covered will include: 🙌 Year in review 🙌 Results of the year-end Fabric Partner Community Satisfaction Survey 🙌 Partner of the Year Awards 🙌 Microsoft Start 🙌 European Microsoft Fabric Community Conference 🙌 Upcoming Partner Project Ready Workshops 🙌 Updates on partner incentives/programs 🙌 And more The Americas/EMEA Fabric Engineering Connection call will take place Wednesday, June 25, from 8-9 am PDT. The APAC Fabric Engineering Connection call will take place Thursday, June 26, from 1-2 am UTC/Wednesday, June 25, from 5-6 pm PDT. There will be no Fabric Engineering Connection calls during the months of July and August. Our FY26 Kick Off call will take place Wednesday, September 3/Thursday, September 4. To join the call, you must be a member of the Fabric Partner Community Teams channel. To join, complete the participation form at https://aka.ms/JoinFabricPartnerCommunity. We look forward to seeing you in a couple days!82Views1like0CommentsProject Online - Business Drivers matrix table in Power BI
Hi! After classifying our ongoing projects we could get to this matrix table in Project Online: There are 6 Business Drivers where each project contributes on a rating scale (None, Low, Moderate, Strong, Extreme) I am stuck on Power BI to find the relation between each Project, the rating scale and each Business Driver to be able to build the same matrix table in Power BI: Any help would be much appreciated!353Views0likes6Comments