business intelligence
80 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? Be sure to join us for this week's Fabric Engineering Connection call, now offered at two different times! 🎉 The Fabric Engineering Connection call, taking place Wednesday, March 5, from 8-9 am PST, and the APAC Fabric Engineering Connection call, taking place Thursday, March 6, from 1-2 am UTC/Wednesday, March 5, from 5-6 pm PST, will feature presentations from Matthew Hicks on Iceberg Virtualization in OneLake; Diana Tram Nguyen and Andrew Boe on SMB Paths to Azure Solutions Partner Designations & AMM and Azure Innovate Access; and Sanaullah Sanai and Rita ABDELLATIFI on Sustainability Data Solutions in Fabric. 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 can't wait to see you tomorrow/Thursday!12Views1like0CommentsJoin 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 this week's Fabric Engineering Connection call, now offered at two different times! 🎉 The Fabric Engineering Connection call, taking place Wednesday, February 26, from 8-9 am PST, and the APAC Fabric Engineering Connection call, taking place Thursday, February 27, from 1-2 am UTC/Wednesday, February 26, from 5-6 pm PST, will feature presentations from Salil Kanade and Venkata Satya Pradeep Srikakolapu on Data Warehouse Developer Experiences and Ted Vilutis on Spark RLS/CLS. 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 can't wait to see you Wednesday/Thursday!29Views1like0CommentsJoin us at the Microsoft Fabric Community Conference in Las Vegas, NV from March 30 - April 2, 2025!
FabCon offers you the chance to learn the latest from Microsoft when it comes to Fabric product features and allows you and your teams to get hands-on with the product through workshops on March 30 and April 3. Throughout FabCon, there will be opportunities for you to connect with Microsoft executives, meet with customers, and connect with peers. On March 30, Microsoft will be hosting the FabCon Partner Pre-Day. This is a special day dedicated to our Microsoft partners and is free for registered FabCon attendees. Our Partner Pre-Day will feature keynotes by Wangui McKelvey and Ashley Asdourian and afternoon breakouts for both systems integrator and software company attendees. We are also offering a 48-hour group discount window exclusively for customers through our partners from Feb 18-19. For questions about available discount codes that you can send directly to your 5 selected customers, please reach out to the fabricpartnersteam@microsoft.com. Register for FabCon and join the FabCon Partner Pre-Day today!165Views1like0CommentsJoin 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 this week's Fabric Engineering Connection call, now offered at two different times! 🎉 The Fabric Engineering Connection call, taking place Wednesday, February 12, from 8-9 am PST, will feature Teddy Bercovitz discussing ISV Workloads in Fabric, followed by Idris Motiwala presenting on SQL DB in Fabric. Idris Motiwala will return with his presentation for the APAC Fabric Engineering Connection call, followed by Sanjay Soni presenting on Dream Demos. The APAC Fabric Engineering Connection is taking place Thursday, February 13, from 1-2 am UTC/Wednesday, February 12, from 5-6 pm PST. 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://lnkd.in/g_PRdfjt. We can't wait to see you Wednesday/Thursday!35Views1like1CommentJoin 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 this week's Fabric Engineering Connection call, now offered at two different times! 🎉 The Fabric Engineering Connection call, taking place Wednesday, February 5, from 8-9 am PST, will feature Varun Jain and Dandan Zhang presenting on Workspace Monitoring and Workspace Private Links. Amir Netz will be hosting his very first AMA (Ask Me Anything) session with the APAC Fabric Engineering Connection call, taking place Thursday, January February 6, from 1-2 am UTC/Wednesday, February 5, from 5-6 pm PST. Join the call to personally ask Amir your Fabric related questions! 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://lnkd.in/g_PRdfjt. We can't wait to see you on the call!23Views1like0CommentsOpen reportserver webservice URL with https leads to an ERR_HTTP2_PROTOCOL_ERROR
We have installed on a Windows Server 2022 the latest version of PowerBI Reporting Server. We have bound a wild card certificate to the PBRS webservice and PBRS portal site. We have also added the FQDN cname to the PBRS reportingserver config file. We have used to deploy any reports by URL's like https://reports.contoso.com/ReportServer/Pages/ReportViewer.aspx?/Invoice/InvoiceReport. Opening with Microsoft Edge we get the error: Hmmm… can't reach this page It looks like the webpage at https://reports.contoso.com/ReportServer/Pages/ReportViewer.aspx?/Invoice/InvoiceReport might be having issues or it may have moved permanently to a new web address. ERR_HTTP2_PROTOCOL_ERROR On the other hand when opening the URL https://reports.contoso.com/Reports/Invoice/InvoiceReport we will be asked to login with the user credentials. Afterwards calling the webservice runs fine. Does anybody had already the same error and how we can avoid it?5.9KViews3likes11CommentsProject web app- No up to date data via OData feed
Hi all, we are working with the project web app. The Data stored in the project web app is pulled via the OData feed connector into a PowerBI report. The project web app is hosted on https://company.sharepoint.com/sites/pwa, the data is pulled from https://company.sharepoint.com/sites/pwa/_api/projectdata. The connection and data refresh was working for months without an issue, last week I have added two enterprise custom fields in the PWA and made some changes to the Enterprise Global. When opening the enterprise global a cache limit error appeared in Project Desktop, which was resolved by deleting the cache. I had to do a forced check in of the enterprise global in the PWA settings. I also got an error when loading the "Tasks" table in Power BI, an issue with one of the newly added enterprise custom fields was reported. This issue just appeared once, seems now to be resolved. Since then, I have not gotten any up to data from the PWA via the OData feed into PowerBI. When looking directly in the PWA the data gets updated, but gets not submitted via the OData feed anymore, some "old" versoin of the data gets submitted, I can run the data refresh against the OData feed without any issue but returns only "old" data. I also have 2 "Project Save from Project Professional" jobs under "Manage queue jobs" with job type "Cancelled" which I cannot remove / cancel from the list. How can I solve this? Thanks in advance152Views0likes14CommentsJoin 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 this week's Fabric Engineering Connection call, now offered at two different times! 🎉 Tamer Farag will be joining both calls to discuss the latest and greatest related to partner offerings and updates, including certifications, Fabric Featured Partners, trainings, incentives, and more. The Fabric Engineering Connection call taking place Wednesday, January 15, from 8-9 am PST. The APAC Fabric Engineering Connection call taking place Thursday, January 16, from 1-2 am UTC/Wednesday, January 15, from 5-6 pm PST. 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 can't wait to see you this week!36Views1like0Commentsduplicate nodes for XML Auto
Hi, I have this xml in SQL Server 2022. select cust.cust_Id, id, timestamp, uid, [user], visible, [version], changeset, [action] , (SELECT distinct ref FROM [nd] as nd where nd.cust_Id = cust.cust_Id and tag.cust_Id = ND.cust_Id FOR XML raw('nd'), type ), k , v from cust as cust join [dbo].[nd] as nd on ND.cust_Id = cust.cust_Id join cust_tags as tag on tag.cust_Id = cust.cust_Id where cust.cust_Id=23165 for xml auto and it gives me this result. As you can see it get duplicates. Apart from the dups in <tag> it''s fine. <cust cust_Id="23165" id="1132454103" timestamp="2023-01-16T14:25:54" uid="5612131" user="k" visible="1" version="1" changeset="131338301"> <nd ref="10239832277" /> <nd ref="10559433751" /> <nd ref="10559433752" /> <nd ref="10559433753" /> <tag k="highcust" v="residential" /> <tag k="highcust" v="residential" /> <tag k="highcust" v="residential" /> <tag k="highcust" v="residential" /> <tag k="name" v="Artemis" /> <tag k="name" v="Artemis" /> <tag k="name" v="Artemis" /> <tag k="name" v="Artemis" /> <tag k="source" v="maxar" /> <tag k="source" v="maxar" /> <tag k="source" v="maxar" /> <tag k="source" v="maxar" /> </cust> Now I have modified it like this: select cust.cust_Id, id, timestamp, uid, [user], visible, [version], changeset, [action], (SELECT ref FROM [nd] as nd where nd.cust_Id = cust.cust_Id FOR XML raw('nd'), type ) , (SELECT k , v FROM cust_tags as tag where tag.cust_Id = cust.cust_Id FOR XML raw('tag'), TYPE ) from cust as cust join cust_tags as tag on tag.cust_Id = cust.cust_Id join [GIS].[dbo].[nd] as nd on ND.cust_Id = cust.cust_Id for xml auto This gives me the structure I want but the node appears multiple times as a duplicate , 5+ times due to the joins <cust cust_Id="23165" id="1132454103" timestamp="2023-01-16T14:25:54" uid="5612131" user="k" visible="1" version="1" changeset="131338301"> <nd ref="10239832277" /> <nd ref="10559433751" /> <nd ref="10559433752" /> <nd ref="10559433753" /> <tag k="highcust" v="residential" /> <tag k="name" v="Artemis" /> <tag k="source" v="maxar" /> </cust> <cust cust_Id="23165" id="1132454103" timestamp="2023-01-16T14:25:54" uid="5612131" user="k" visible="1" version="1" changeset="131338301"> <nd ref="10239832277" /> <nd ref="10559433751" /> <nd ref="10559433752" /> <nd ref="10559433753" /> <tag k="highcust" v="residential" /> <tag k="name" v="Artemis" /> <tag k="source" v="maxar" /> </cust> <cust cust_Id="23165" id="1132454103" timestamp="2023-01-16T14:25:54" uid="5612131" user="k" visible="1" version="1" changeset="131338301"> <nd ref="10239832277" /> <nd ref="10559433751" /> <nd ref="10559433752" /> <nd ref="10559433753" /> <tag k="highcust" v="residential" /> <tag k="name" v="Artemis" /> <tag k="source" v="maxar" /> </cust> Any idea how i can get rid of the duplicates. Either in the fist sql or the second. Thank you!Solved38Views0likes2CommentsJoin the Fabric Partner Community for this Week's Fabric Engineering Connection!
Join us this Wednesday, October 30, from 8-9 AM PT for the weekly partner community call, Fabric Engineering Connection! This week's call will feature presentations on Admin & Security from Varun Jain and Rick Xu, followed by Data Protection with Anton Fritz. The Fabric Engineering Connection is a weekly call held in the Fabric Partner Community Teams Channel exclusively for partners. Hear directly from Fabric product engineering teams about upcoming features, ask questions, and provide feedback. To join these calls (as well as watch recordings of previous calls), please join the Fabric Partner Community Teams Channel by completing the participation form at https://aka.ms/JoinFabricPartnerCommunity.94Views0likes0Comments