Unable to Connect we encountered an error while trying to connect with Microsoft SQL
Hello Guys, while i am trying to connect to SQL Server, it was showing some error message. The content of the error message can be found below in bold.. Details: "Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)" For reference please check with the screenshot of the error message which was attached to this post or message.. Kindly put down the solution(s) in step by step manner as it would be helpful to me and the PBI community as well...
Global Fabric Day 2026 - Toronto
Please read the registration instructions very carefully to make sure you can attend the event: How to Secure Your Spot (by Tue Jun 23): To attend, please complete all the following steps: 1- Click the green “Register” button on this event page above. (Note: You may need to first join the Microsoft Fabric Community and then the Toronto Fabric & Power BI User Group before registering). 2- Fill out this mandatory registration form: Global Fabric Day 2026 - Toronto Sat Jun 27, 2026 Conference Registration Form 3- Add the event to your calendar. Completing these steps (step 1-2) are mandatory to receive your QR access code in your email for the venue by Tue Jun 23. Important Notes: - Limited capacity: The registration will be closed on Tue Jun 23 or by reaching the max capacity limit. - Please register only if you are certain about your participation to avoid wasting space and food. ------------------------------------------------------------------------------------------------------------------------ Hello TFPUG Members, We’re super thrilled to announce Global Fabric Day 2026 - Toronto, our third annual full-day conference dedicated to all things Microsoft Fabric, happening on Sat Jun 27, 2026 at the Microsoft Toronto office! This year, Global Fabric Day 2026 - Toronto is the local edition of the second annual Global Fabric Community that is coordinated globally and hosted locally across multiple cities around the world during the weekend of Jun 27-28, 2026. This is a free, in-person event bringing together data professionals, developers, and enthusiasts to explore the latest in Microsoft Fabric through demo-rich sessions, expert talks, and community networking. Agenda & Format: Global Fabric Day 2026 - Toronto We are privileged to have Kim Manis, Microsoft Corporate Vice President of Fabric & Power BI as the keynote speaker in-person this year in Toronto. A big thank you to our sponsors and volunteers for helping make this event possible and for their ongoing support of the local data community. Looking forward to seeing you all on Sat Jun 27 at 9 am sharp. TFPUG Team Toronto Fabric & Power BI User Group | Microsoft Fabric Community Toronto Fabric & Power BI User Group | LinkedIn Toronto Fabric & Power BI User Group | Meetup
Calculate: A table of multiple values was supplied where a single value was expected.
Hi guys, Last year my collegue wrote a dax formula for my BI report. Unfortunately he is no longer working at my firm. Couple of days ago the datasource of my report was moved into the cloud. I already changed the location of the datasource in my report, but the Dax formula he wrote for me doesn't work since then. I tried a couple of things but it wouldn't work. The error is: A table of multiple values was supplied where a single value was expected. Can someone help me? Thank you! The dax formula: EmployeeKey = CALCULATE( DISTINCT('DimEmployee'[EmployeeKey]), FILTER('DimEmployee', 'FactActualHoursAll'[TT_EMP_ID] = 'DimEmployee'[EmployeeId] && 'FactActualHoursAll'[TT_date] >= 'DimEmployee'[RowEffectiveDate] && 'FactActualHoursAll'[TT_date] <= 'DimEmployee'[RowExpirationDate] ) )
Transforming Text to SQL: Harnessing OpenAI for Efficient Data Insights
AI expert Rob Kerr will delve into the innovative realm of transforming text into SQL queries using Azure OpenAI's advanced capabilities. He'll explain the challenges and methodologies involved in developing a robust text-to-SQL solution, emphasizing the integration of natural language processing (NLP) and machine learning techniques. Through practical examples Rob will demonstrate how Azure OpenAI's technology can streamline data extraction and query generation, empowering businesses to unlock valuable insights from unstructured textual data with unprecedented efficiency and accuracy. Join us to learn about the future of data analytics through the fusion of AI-driven text understanding and database querying. You will learn: The fundamentals of text-to-SQL transformation using OpenAI technology How to apply various techniques such as Prompt Engineering, Model Fine-Tuning and Retrieval Augmented Generation Techniques for integrating natural language processing (NLP) with SQL query generation How to overcome challenges in interpreting and structuring unstructured text data Rob Kerr is Vice President - Artificial Intelligence at DesignMind. He is a well-known leader in technology consulting, IT management, and software engineering circles. Rob has served in consulting roles with startup and Fortune 1000 companies, and is a Microsoft Certified Azure Solutions Architect, AI Engineer and Data Scientist.
Error while connecting PostGres to Power BI
I'm trying to connect my Power BI Desktop to Post Gres SQL. I get the following error when I tried to connect. Details: "Loading assembly file 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'PostgreSQL'" With the same credentials, im able to connect to the MY SQL workbench
