Category: Microsoft
Category Archives: Microsoft
Formula error
What is wrong with this formula? =SUM(DATEVALUE(G2))-TODAY() it returns #VALUE ??
What is wrong with this formula? =SUM(DATEVALUE(G2))-TODAY() it returns #VALUE ?? Read More
Tracking changes to measure expressions in a SSAS multi-dimensional model
Hello, all!
I have a stakeholder for whom we have built a SSAS multi-dimensional model. I recently built a Power BI report to document the model (tables, fields, measures) using SSAS Dynamic Management Views (DMVs). This data dictionary report has been extremely helpful for stakeholders who build reports against the model (de-centralized BI structure where users can build their own reports).
We’ve recently run into a challenge when the naming convention or definition (expression) of measures within the model change. Our stakeholders want visibility into that process and would like a history of those changes in the dictionary. My data dictionary report relies on the DMVs, which capture current state metadata from the SSAS cube.
My question then is, what is the best way to track changes to a table (specifically, the measures table) within the model so that the data dictionary reflects when and how a measure definition (expression) was changed? Is there a way, using DMVs or another route, to track what the measure was, when it changed, and what it now is?
Thanks in advance for your input!
Hello, all! I have a stakeholder for whom we have built a SSAS multi-dimensional model. I recently built a Power BI report to document the model (tables, fields, measures) using SSAS Dynamic Management Views (DMVs). This data dictionary report has been extremely helpful for stakeholders who build reports against the model (de-centralized BI structure where users can build their own reports). We’ve recently run into a challenge when the naming convention or definition (expression) of measures within the model change. Our stakeholders want visibility into that process and would like a history of those changes in the dictionary. My data dictionary report relies on the DMVs, which capture current state metadata from the SSAS cube. My question then is, what is the best way to track changes to a table (specifically, the measures table) within the model so that the data dictionary reflects when and how a measure definition (expression) was changed? Is there a way, using DMVs or another route, to track what the measure was, when it changed, and what it now is? Thanks in advance for your input! Read More
WiFi problem after upgrade to v24H2 release preview
I have a Dell Inspiron laptop which has a Qualcomm QCA61x4A 802.11ac wireless card
I installed v24H2 Release Preview and Network services could not run thus no WiFi available and no internet.
The card driver is the original 12.0.0.953 – no updates are available
I had to roll back to W11 23H2
Do I report this and if so how? Any suggestions how to fix? On the face of it it looks like the driver for this network adapter is nof compatible with v24H2.
Thank you
I have a Dell Inspiron laptop which has a Qualcomm QCA61x4A 802.11ac wireless card I installed v24H2 Release Preview and Network services could not run thus no WiFi available and no internet. The card driver is the original 12.0.0.953 – no updates are available I had to roll back to W11 23H2 Do I report this and if so how? Any suggestions how to fix? On the face of it it looks like the driver for this network adapter is nof compatible with v24H2. Thank you Read More
Business Applications Partner News: Week of June 3
Check out this week’s top resources to stay up-to-date on the latest Business Applications Partner News. Remember to sign up for the monthly Dynamics 365 and Power Platform partner pulse newsletters.
What to register for:
THIS WEEK! June 4-7 (IST), (BST): Accelerate Business Process Automation using Microsoft Power Platform Workshop
June 14: Partner Activities Office Hours
Sep 18-20: Microsoft Power Platform Conference
What to download:
Partner Value with Power Platform Guide – IDC whitepaper
Updated Partner Activities POE templates:
Envisioning
Business Value Assessment
Solution Assessment
Tailored Demo
Microsoft Copilot for Finance Partner Opportunity Deck
Copilot in Dynamics 365 Customer Service Features deck
What to review/like/share:
Partner case study: RSM creates winning playbook for midmarket ERP cloud migration
Partners delivering customer impact with Copilot Studio: LinkedIn | blog post
What to watch:
Build and scale your ERP migration strategy using this new video series:
Program series overview
Build your high-volume migration framework
Develop your migration go-to market strategy
Accelerate your migration sales
Reminders: Register for the upcoming partner events!
Events:
July 22: Microsoft Partner FY25 GTM Launch Event for Business Applications
Save the date: Join us on July 11 for MCAPS Start for Partners
Trainings:
June 11 (IST) (BST): Dynamics 365 Supply Chain Management – Demand Planning Workshop
Level Up Copilot Sales Champion training course (access code: MOKC-MCJB)
Check out this week’s top resources to stay up-to-date on the latest Business Applications Partner News. Remember to sign up for the monthly Dynamics 365 and Power Platform partner pulse newsletters.
What to register for:
THIS WEEK! June 4-7 (IST), (BST): Accelerate Business Process Automation using Microsoft Power Platform Workshop
June 14: Partner Activities Office Hours
Sep 18-20: Microsoft Power Platform Conference
What to download:
Partner Value with Power Platform Guide – IDC whitepaper
Updated Partner Activities POE templates:
Envisioning
Business Value Assessment
Solution Assessment
Tailored Demo
Microsoft Copilot for Finance Partner Opportunity Deck
Copilot in Dynamics 365 Customer Service Features deck
What to review/like/share:
Partner case study: RSM creates winning playbook for midmarket ERP cloud migration
Partners delivering customer impact with Copilot Studio: LinkedIn | blog post
What to watch:
Build and scale your ERP migration strategy using this new video series:
Program series overview
Build your high-volume migration framework
Develop your migration go-to market strategy
Accelerate your migration sales
Reminders: Register for the upcoming partner events!
Events:
July 22: Microsoft Partner FY25 GTM Launch Event for Business Applications
Save the date: Join us on July 11 for MCAPS Start for Partners
Trainings:
June 11 (IST) (BST): Dynamics 365 Supply Chain Management – Demand Planning Workshop
Level Up Copilot Sales Champion training course (access code: MOKC-MCJB)
2.236 – sensor fails to start
Is anyone else seeing the Azure ATP Sensor service fail to start on 2.236? I have delayed update on half of our sensors; all those running 2.235 are OK.
Machines running 2.236 are not OK (“Failed to communicate with configured domain controllers” in Microsoft.Tri.Sensor-Errors.log)
Also interested on how I can block auto-update on the machines still running 2.235 while I open a support ticket.
Is anyone else seeing the Azure ATP Sensor service fail to start on 2.236? I have delayed update on half of our sensors; all those running 2.235 are OK. Machines running 2.236 are not OK (“Failed to communicate with configured domain controllers” in Microsoft.Tri.Sensor-Errors.log) Also interested on how I can block auto-update on the machines still running 2.235 while I open a support ticket. Read More
Dialpad Support for Azure Virtual Desktop MMR
Hi! My team is currently working on the support of Azure Virtual Desktop MMR, and I’d like to connect to understand how we can get Dialpad whitelisted ( Websites that work with multimedia redirection).
Thank you! @TianchengXu
Hi! My team is currently working on the support of Azure Virtual Desktop MMR, and I’d like to connect to understand how we can get Dialpad whitelisted ( Websites that work with multimedia redirection).Thank you! @TianchengXu Read More
Windows Server 2022 DNS Issues?
Hello,
After upgrading to Windows Server 2022, we’re experiencing errors with net.tcp/C# applications not being able to resolve host names as quickly as before, which is causing this error: “The remote name could not be resolved: ‘<hostname>’
Has anyone else experienced this type of issue? I don’t see this issue in other servers that have been upgraded to Windows Server 2022. DNS is configured correctly. Running ping or nslookup through powershell results in immediate responses from the DNS server.
Thanks for help in advance!
-Dusty
Hello, After upgrading to Windows Server 2022, we’re experiencing errors with net.tcp/C# applications not being able to resolve host names as quickly as before, which is causing this error: “The remote name could not be resolved: ‘<hostname>’ Has anyone else experienced this type of issue? I don’t see this issue in other servers that have been upgraded to Windows Server 2022. DNS is configured correctly. Running ping or nslookup through powershell results in immediate responses from the DNS server. Thanks for help in advance!-Dusty Read More
Exchange On prem 1 parent 3 child domains
Hello all I have question and I hope I can articulate this as clear as possible. Our set up consist of 4 domains. One is the parent and the other are child domains. Exchange servers are built in each of the child domains, 1 per child domain and none in parent domain. Everything works however security is asking about why does an outlook client that is on child domain 1 trying to connect to the exchange server of child domain 2 and sometimes child domain 3?(almost like a round robin effect) I would like to explain to them in confidence rather just saying… that’s just the behavior of the forest.. Even if it is just would like to explain it better. When I log into the EAC of child domain 1 i see servers for child domain 2, and 3 and if I change any settings it changes them across the servers. We are in closed environment but they want the environments isolated. I looked online but I have not found anything in regards to this type of set up.
Hello all I have question and I hope I can articulate this as clear as possible. Our set up consist of 4 domains. One is the parent and the other are child domains. Exchange servers are built in each of the child domains, 1 per child domain and none in parent domain. Everything works however security is asking about why does an outlook client that is on child domain 1 trying to connect to the exchange server of child domain 2 and sometimes child domain 3?(almost like a round robin effect) I would like to explain to them in confidence rather just saying… that’s just the behavior of the forest.. Even if it is just would like to explain it better. When I log into the EAC of child domain 1 i see servers for child domain 2, and 3 and if I change any settings it changes them across the servers. We are in closed environment but they want the environments isolated. I looked online but I have not found anything in regards to this type of set up. Read More
Copilot- Tips, Tricks and Lessons Learned from Customers
First off, let me say Copilot is a game changer. It has really helped me to focus on tasks that leverage my skillsets and reduce time consuming or repetitive tasks.
As I continue to help customers ramp up on Copilot, I keep seeing similar trends (below). Would love to know if you all see/hear the same as well as what else your seeing/hearing?
Good Teams Usage = Good Copilot Usage- Customers not using Teams as a collaboration tool (but rather just for chat and calling) are far more difficult to to drive adoption with than those that are.Customers turning off transcription- I have several customers refusing to turn on transcription over possible legal retention issues and complaining that too many recap features are reliant upon it.Customer with E5 not turning on labeling because they feel that the effort is greater than the value.End users wanting more prompts to help them understand how and when to engage with Copilot.
What are you seeing/hearing from your orgs/customers around Copilot?
Stephen
First off, let me say Copilot is a game changer. It has really helped me to focus on tasks that leverage my skillsets and reduce time consuming or repetitive tasks. As I continue to help customers ramp up on Copilot, I keep seeing similar trends (below). Would love to know if you all see/hear the same as well as what else your seeing/hearing? Good Teams Usage = Good Copilot Usage- Customers not using Teams as a collaboration tool (but rather just for chat and calling) are far more difficult to to drive adoption with than those that are.Customers turning off transcription- I have several customers refusing to turn on transcription over possible legal retention issues and complaining that too many recap features are reliant upon it.Customer with E5 not turning on labeling because they feel that the effort is greater than the value.End users wanting more prompts to help them understand how and when to engage with Copilot.What are you seeing/hearing from your orgs/customers around Copilot?Stephen Read More
Outlook Rules on Server not sufficient
I use mail rules every day. Until MS started forcing everyone to use the online web version, rules were a huge time saver and organizational tool. However, the online version of Outlook does not allow for more broad rules such as any messages I received that had “Accepted” in the subject could, on the desktop version, be routed to a specific folder but there is no way to create the same rule on the web version. I get hundreds of “Accepted” responses a day that will clog up my Inbox and make it impossible to find who accepted what invites with any ease.
I prefer not to use the online web version of Outlook because it seriously lacks functionality. I don’t know why anyone but the most basic of users would choose the web version.
I have been under the impression that Microsoft apps were for productivity, but it now seems like it is taking steps to move away from being productivity based. It makes zero sense to take away functionality from your users. I hope another company eventually steps in to fill the gap with flexible functionality. I’m sick of all the constant changes MS makes now that it’s a subscription.
Additionally, it is tiresome seeing the below message every single time I want to review my rules, especially since even if I choose to store my rules on my computer, they don’t work.
I use mail rules every day. Until MS started forcing everyone to use the online web version, rules were a huge time saver and organizational tool. However, the online version of Outlook does not allow for more broad rules such as any messages I received that had “Accepted” in the subject could, on the desktop version, be routed to a specific folder but there is no way to create the same rule on the web version. I get hundreds of “Accepted” responses a day that will clog up my Inbox and make it impossible to find who accepted what invites with any ease. I prefer not to use the online web version of Outlook because it seriously lacks functionality. I don’t know why anyone but the most basic of users would choose the web version. I have been under the impression that Microsoft apps were for productivity, but it now seems like it is taking steps to move away from being productivity based. It makes zero sense to take away functionality from your users. I hope another company eventually steps in to fill the gap with flexible functionality. I’m sick of all the constant changes MS makes now that it’s a subscription. Additionally, it is tiresome seeing the below message every single time I want to review my rules, especially since even if I choose to store my rules on my computer, they don’t work. Read More
I need help with cell referencing
When making a cell relative or absolute is it the F2 or F4 key that I need to press or is there another key that needs pressing like Control+Shift+F2, or Control+Shift+F4, because when all I press is the F4 or F2 key nothing happens? What am I missing? Can anyone help me out and explain?
When making a cell relative or absolute is it the F2 or F4 key that I need to press or is there another key that needs pressing like Control+Shift+F2, or Control+Shift+F4, because when all I press is the F4 or F2 key nothing happens? What am I missing? Can anyone help me out and explain? Read More
Azure IOT Hub, plotting raw date (not average)
Hello
I’m using Azure IOT Hub and would like to visualize actual sensor data. However, using the preset template for the visualisation, I can’t select raw data but only mean values over a minimum timespan of 30min.
Hello I’m using Azure IOT Hub and would like to visualize actual sensor data. However, using the preset template for the visualisation, I can’t select raw data but only mean values over a minimum timespan of 30min. Read More
Windows Server 2025 build and SKU questions
Dear Windows Server Team,
few questions from my end. Hopefully other Insiders can share thoughts on these, too.
1. can we assume 26100 (WS 2025 preview) to be a RTM candidate and b26277 a vNext release already?
2. What are the feature and benefits differences between the WS 2025 Azure Edition and WS 2025 preview b26100 & WS 2025 b26277+. Question arises as with SMB QUIC, and Hotpatch in both, I see kinda feature parity. TY for your time sharing more insights on this. Also in docs. WS 2025 preview is documented (not feature complete, lot of Hyper-V things are missing), but no work on Azure Edition preview yet.
3. Since a certain time the announcement of Azure Edition ISO in the blog fell behind the WS build announcement. Matches with #2. Why, what’s the need for Azure Edition atm?
Azure Edition is reportingly at 26085.
Dear Windows Server Team,
few questions from my end. Hopefully other Insiders can share thoughts on these, too.
1. can we assume 26100 (WS 2025 preview) to be a RTM candidate and b26277 a vNext release already?
2. What are the feature and benefits differences between the WS 2025 Azure Edition and WS 2025 preview b26100 & WS 2025 b26277+. Question arises as with SMB QUIC, and Hotpatch in both, I see kinda feature parity. TY for your time sharing more insights on this. Also in docs. WS 2025 preview is documented (not feature complete, lot of Hyper-V things are missing), but no work on Azure Edition preview yet. 3. Since a certain time the announcement of Azure Edition ISO in the blog fell behind the WS build announcement. Matches with #2. Why, what’s the need for Azure Edition atm?
Azure Edition is reportingly at 26085.
Read More
New look for Intune Company Portal app for Windows
By: Maggie Dakeva – Sr Product Manager | Microsoft Intune
We’re excited to announce that the Intune Company Portal app for Windows is getting a new modernized design. Users will be able to use the same functionality they’re used to with an improved experience on their desktop app. This blog covers what’s changing and how to prepare.
Available for preview now, released to the Microsoft Store in August 2024
A preview version for the updated Company Portal is now available for download in the Microsoft Download center. The preview will be available until late August. It should only be used for testing purposes and updating your IT admin and user documentation. We’ll release the new Company Portal to the Microsoft Store in late August and it’ll automatically update for all users where Microsoft Store apps are configured to auto-update. See Common Store policy settings and their impact on Microsoft Store apps for details on enabling and configuring Microsoft Store app updates.
How to deploy the preview
Download the Company Portal app installation file and all dependencies applicable to your device architecture. Navigate to the Microsoft Intune admin center and Add a Windows line-of-business app to Microsoft Intune. Assign the app to a small group of test devices or users.
On your device, sync with Intune and confirm the Company Portal app installed correctly.
Important: If Company Portal from the Microsoft Store is also assigned to the same user/device, make sure you have the latest preview version. Company Portal automatically updates to the latest version targeted so your preview version needs to be higher than the version available in the Microsoft Store.
What to expect
With the updated design, users will see improvements in user experience for the Home, Devices, and Downloads & updates pages. The new design is more intuitive and highlights areas where users need to take action.
Home
An image of the new Home page design in the Company Portal app for Windows.
The Home page displays apps, including featured apps, and shows the device status overview in the top right corner. The side menu icons have also been updated.
Downloads & updates
An image of the new Downloads & updates page design in the Company Portal app for Windows.
The Downloads & updates page shows installed apps and apps currently in the download queue. In the above example, 7-Zip is currently installing, and progress for this installation has just reached 100%.
Notifications
An image of the Company Portal app Home page with the new Notifications button.
There is a new Notifications button on the Home page which shows a list of the latest notifications.
Device
An image of the new Device page design in the Company Portal app for Windows.
The Device page highlights compliance status in a color-coded block which helps users spot issues more easily. They can also view suggested remediation steps, review device information, and take actions for the device.
Send feedback
If you have any feedback for the product group, reach out via the Feedback hub or reply directly to this blog.
Frequently asked questions
Q: Will there be improvements in the functionality or new features available with this update?
A: While the redesign offers improvement to the user experience, there is no intended change to the supported feature-set at this time.
Q: Can I use the preview version in my production tenant?
A: You can use the preview version in production tenants for testing purposes but keep in mind that this version will be removed from Microsoft Download center as soon as we release to the Microsoft Store at the end of July 2024.
Q: Is it possible to keep using the old look for Company Portal?
A: When we release the new Company Portal design to the Microsoft Store, it’ll automatically update for users who have configured the Microsoft Store to update apps automatically. If you haven’t configured this, you’ll continue to use the old version until you decide to update it manually using the Microsoft Store app on the device itself. It’ll not be possible to download any updated version of the old Company Portal look.
Stay tuned to this post for updates on the release to the Microsoft Store! If you have any questions or feedback, fill out the feedback form or leave a comment below.
Microsoft Tech Community – Latest Blogs –Read More
📝 Teams Premium – Intelligent Recap additional language pack availability
Hi all,
as you all know in the end of April ’24 language pack for Copilot became available. Since Intelligent Recap it’s a functionality available in both Copilot for M365 and Teams Premium, it seems logical to expect support of this language pack in Teams Premium Intelligent Recap too (I also asked about it during Copilot webinar and got confirmation).
I do not have Copilot for M365 license, but my colleague tested and said that Intelligent Recap with Copilot license already has new language pack support and creates summary from meetings, but in Teams Premium I’m still don’t see it.
So, I wanted to ask if anybody knows for sure would Intelligent Recap in Teams Premium get support of that language pack, and if so – when?
Would appreciate any information!
Hi all,as you all know in the end of April ’24 language pack for Copilot became available. Since Intelligent Recap it’s a functionality available in both Copilot for M365 and Teams Premium, it seems logical to expect support of this language pack in Teams Premium Intelligent Recap too (I also asked about it during Copilot webinar and got confirmation). I do not have Copilot for M365 license, but my colleague tested and said that Intelligent Recap with Copilot license already has new language pack support and creates summary from meetings, but in Teams Premium I’m still don’t see it.So, I wanted to ask if anybody knows for sure would Intelligent Recap in Teams Premium get support of that language pack, and if so – when?Would appreciate any information! Read More
Databricks with Simba spark ODBC dsn
I am using the Simba Spark ODBC driver to create a dsn to connect to a Databricks instance. When tested, it passes. When I go in to Access to link to the data, Access is only pulling a subset of the available tables and views. If I try to attach Databricks to Excel, using the same dsn, it returns all schemas, views and tables. Any help would be appreciated getting Access to work correcctly.
I am using the Simba Spark ODBC driver to create a dsn to connect to a Databricks instance. When tested, it passes. When I go in to Access to link to the data, Access is only pulling a subset of the available tables and views. If I try to attach Databricks to Excel, using the same dsn, it returns all schemas, views and tables. Any help would be appreciated getting Access to work correcctly. Read More
Azure Maps not displaying on .Net Framework Web App
Hi,
I just created a subscription for Azure Maps. I’m using Visual Studio 2019 for my web application using .Net Framework 4.8, MVC.
My references in the layout web page are:
<!–Add reference to Azure Maps–>
<link href=”https://atlas.microsoft.com/sdk/javascript/mapcontrol/2/atlas.min.css” rel=”stylesheet” type=”text/css” />
<!– Add a reference to the Azure Maps Services SDK JavaScript file. –>
<script src=”https://atlas.microsoft.com/sdk/javascript/mapcontrol/2/atlas.min.js“></script>
The function to initialize the Azure Maps is:
function GetMap() {
// Initialize a map instance.
map = new atlas.Map(‘divMap’, {
center: [39.011902, -98.484247],
zoom: 5,
view: ‘Auto’,
// Add authentication details for connecting to Azure Maps.
authOptions: {
// Use an Azure Maps key.
// Get an Azure Maps key at https://azure.com/maps.
// NOTE: The primary key should be used as the key.
authType: ‘subscriptionKey’,
clientId: azureMapsClientId,
subscriptionKey: azureKey
}
});
}
Why is the map not showing? I just want to display a satellite imagery of the US as background map.
Appreciate any help.
Hi, I just created a subscription for Azure Maps. I’m using Visual Studio 2019 for my web application using .Net Framework 4.8, MVC. My references in the layout web page are:<!–Add reference to Azure Maps–><link href=”https://atlas.microsoft.com/sdk/javascript/mapcontrol/2/atlas.min.css” rel=”stylesheet” type=”text/css” /><!– Add a reference to the Azure Maps Services SDK JavaScript file. –><script src=”https://atlas.microsoft.com/sdk/javascript/mapcontrol/2/atlas.min.js”></script> The function to initialize the Azure Maps is:function GetMap() {// Initialize a map instance.map = new atlas.Map(‘divMap’, {center: [39.011902, -98.484247],zoom: 5,view: ‘Auto’,// Add authentication details for connecting to Azure Maps.authOptions: {// Use an Azure Maps key.// Get an Azure Maps key at https://azure.com/maps.// NOTE: The primary key should be used as the key.authType: ‘subscriptionKey’,clientId: azureMapsClientId,subscriptionKey: azureKey}});} Why is the map not showing? I just want to display a satellite imagery of the US as background map. Appreciate any help. Read More
Sharing invites as a link
I am creating an optional event in a shared mailbox calendar (so no Teams for it). I would like a way for people to be able to click on a link to say they want to attend and for it to be added to their personal calendar. I particularly want a link rather than an iCal attachment. Can this be done, and if so how?
I am creating an optional event in a shared mailbox calendar (so no Teams for it). I would like a way for people to be able to click on a link to say they want to attend and for it to be added to their personal calendar. I particularly want a link rather than an iCal attachment. Can this be done, and if so how? Read More
How to remove time from date and time data in one cell
I have an Excel spreadsheet of 2000 records with the date DD MM YYYY and time HH:MM:SS in the same column and I want to remove the time detail from the column. Any suggestions how I might do this ?
I have an Excel spreadsheet of 2000 records with the date DD MM YYYY and time HH:MM:SS in the same column and I want to remove the time detail from the column. Any suggestions how I might do this ? Read More
Create and manage approval requests for a Word document
Hi Microsoft 365 Insiders!
Happy Monday! We’re delighted to unveil a new add-in that simplifies the approval process for your Word documents. Now, you can create and manage approval requests without leaving Word, ensuring a seamless and efficient workflow.
Discover all the ins and outs in our comprehensive blog post by Connor Rodewald, Senior Product Manager on the Low Code Experience team: Create and manage approval requests for a Word document
Thanks,
Perry Sjogren
Microsoft 365 Insider Social Media Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hi Microsoft 365 Insiders!
Happy Monday! We’re delighted to unveil a new add-in that simplifies the approval process for your Word documents. Now, you can create and manage approval requests without leaving Word, ensuring a seamless and efficient workflow.
Discover all the ins and outs in our comprehensive blog post by Connor Rodewald, Senior Product Manager on the Low Code Experience team: Create and manage approval requests for a Word document
Thanks,
Perry Sjogren
Microsoft 365 Insider Social Media Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Read More
