Hi everyone, I am trying to figure out how to make a macro that will show and hide up multiple tabs in a excel spreadsheet by using a ActiveX Checkbox.   I am able to show a tab by clicking on that designated checkbox.  I need “SHEET 2” checkbox to show “SHEET 3”, “SHEET 4”, and “SHEET 5” once checked, then hide those sheets once it is unchecked.  I tried to add a sheet but it wont accept macro enabled sheets.

​Hi everyone, I am trying to figure out how to make a macro that will show and hide up multiple tabs in a excel spreadsheet by using a ActiveX Checkbox.   I am able to show a tab by clicking on that designated checkbox.  I need “SHEET 2” checkbox to show “SHEET 3”, “SHEET 4”, and “SHEET 5” once checked, then hide those sheets once it is unchecked.  I tried to add a sheet but it wont accept macro enabled sheets.  Read More

​

I need to access some c# code from javascript in MVC ,NET (not blazor). I have the below. This is very specific to .NET and MVC stack and not a generic ajax question like another one in stack overfow. I get no error message it just continues to the next statement after the ajax call. There could be 2 possible issues i think. My url: ‘/Home/CreatePostcodeFromCoordinates’, is wrong. Or my C# assembly is not part of the assembly? or something similar. I am not that experienced with Web techs, I come from a DB background but can’t be that difficult to get this link working right? Can’t see anything else wrong. Also does the return value from C# need to be some special format or a string (as per now) is ok? this could be another reason? Thank you!

console.log(“just before /Home/CreatePostcodeFromCoordinates”);

$.ajax({
type: “POST”,
url: ‘/Home/CreatePostcodeFromCoordinates’,
data: { param1: longitude, param2: latitude },
success: function (response) {
console.log(‘success’);
console.log(response);
},
error: function (error) {
console.error(error);
}
});

​I need to access some c# code from javascript in MVC ,NET (not blazor). I have the below. This is very specific to .NET and MVC stack and not a generic ajax question like another one in stack overfow. I get no error message it just continues to the next statement after the ajax call. There could be 2 possible issues i think. My url: ‘/Home/CreatePostcodeFromCoordinates’, is wrong. Or my C# assembly is not part of the assembly? or something similar. I am not that experienced with Web techs, I come from a DB background but can’t be that difficult to get this link working right? Can’t see anything else wrong. Also does the return value from C# need to be some special format or a string (as per now) is ok? this could be another reason? Thank you!console.log(“just before /Home/CreatePostcodeFromCoordinates”);

$.ajax({
type: “POST”,
url: ‘/Home/CreatePostcodeFromCoordinates’,
data: { param1: longitude, param2: latitude },
success: function (response) {
console.log(‘success’);
console.log(response);
},
error: function (error) {
console.error(error);
}
});   Read More

​

We are thrilled to share that the AI Skills Navigator now localizes to French, Spanish, and German.

The general link https://aka.ms/AISkillsNavigator will localize according to the language that the user’s browser is set to. 
To view the AI Skills Navigator in French, Spanish and German use these unique URLs:

French: https://aiskillsnavigator.microsoft.com/fr-fr
Spanish:  https://aiskillsnavigator.microsoft.com/es-es
German: https://aiskillsnavigator.microsoft.com/de-de

​ 
We are thrilled to share that the AI Skills Navigator now localizes to French, Spanish, and German.
 

The general link https://aka.ms/AISkillsNavigator will localize according to the language that the user’s browser is set to. 
To view the AI Skills Navigator in French, Spanish and German use these unique URLs:

French: https://aiskillsnavigator.microsoft.com/fr-fr
Spanish:  https://aiskillsnavigator.microsoft.com/es-es
German: https://aiskillsnavigator.microsoft.com/de-de  Read More

​

Dear Windows Server Insider team,

I am seeing this issue for a longer time now and hoped it would be resolved.

Will be repeating my tests with 26311 soon and updating this thread by then.

I consider this issue of medium importance. If this goes live it can harm especially Windows Server based VDI which usually using OneDrive and FSLogix Containers. 

This one is just tested in easy complexity with OneDrive for Home Use, but I expect it can also affect OneDrive for Business.

Thanks! 

https://aka.ms/AAt80nr

​Dear Windows Server Insider team,
 
I am seeing this issue for a longer time now and hoped it would be resolved.
Will be repeating my tests with 26311 soon and updating this thread by then.I consider this issue of medium importance. If this goes live it can harm especially Windows Server based VDI which usually using OneDrive and FSLogix Containers. 
 
This one is just tested in easy complexity with OneDrive for Home Use, but I expect it can also affect OneDrive for Business.Thanks! 
 
https://aka.ms/AAt80nr  Read More

​

Hello all,

On the left is my current table. I want it to look like the table on the right. (I manually created a sample for reference, but my table has over 7000 rows so I can’t manually create the whole thing).

As you can see I have multiple entries per day. When I transpose it in PQ, it shortens it to one entry per day, basically erasing all the other entries.

Help would be greatly appreciated.

Thank you!

​Hello all, On the left is my current table. I want it to look like the table on the right. (I manually created a sample for reference, but my table has over 7000 rows so I can’t manually create the whole thing). As you can see I have multiple entries per day. When I transpose it in PQ, it shortens it to one entry per day, basically erasing all the other entries. Help would be greatly appreciated. Thank you!  Read More

​

Title: Writing Powerful Custom Functions with LET and LAMBDA

Session Outline:

Microsoft expert Diarmuid Early will be showing us how to write powerful custom functions using LET and LAMBDA. He’ll start things off with a brief introduction to the basics of writing custom functions with LAMBDA, including how to write, store, and share, as well as some comparison vs VBA user-defined functions. We’ll then move onto writing more complex formulas with LET – and how to do it while maintaining auditability. Then, he’ll show us how to combine LET and LAMBDA to make complex multi-step custom functions.

​Title: Writing Powerful Custom Functions with LET and LAMBDASession Outline:Microsoft expert Diarmuid Early will be showing us how to write powerful custom functions using LET and LAMBDA. He’ll start things off with a brief introduction to the basics of writing custom functions with LAMBDA, including how to write, store, and share, as well as some comparison vs VBA user-defined functions. We’ll then move onto writing more complex formulas with LET – and how to do it while maintaining auditability. Then, he’ll show us how to combine LET and LAMBDA to make complex multi-step custom functions.  Read More

​

Title: Power BI Performance Troubleshooting

Session Outline:

First, we’ll learn about some of the newest features and updates in Power BI with Joseph Yeates. Next, Daniel Szepesi and Jocelyn Porter will present on troubleshooting performance in Power BI, from Desktop to Log Analytics.

Troubleshooting performance on a Software as a Service (SaaS) solution can be very difficult. You don’t own the machines anymore so how do you get to performance data? Power BI at its core is Analysis Services Tabular so some of the troubleshooting tools might be familiar to SQL performance people but it has some built-in capability to help isolate performance issues as well.

This session will include a discussion of Power BI architecture and then will be a demo-heavy walkthrough of using the Power BI Performance Analyzer, SQL Profiler and Azure Log Analytics to help isolate and resolve performance issues with Power BI.

​Title: Power BI Performance TroubleshootingSession Outline:First, we’ll learn about some of the newest features and updates in Power BI with Joseph Yeates. Next, Daniel Szepesi and Jocelyn Porter will present on troubleshooting performance in Power BI, from Desktop to Log Analytics.Troubleshooting performance on a Software as a Service (SaaS) solution can be very difficult. You don’t own the machines anymore so how do you get to performance data? Power BI at its core is Analysis Services Tabular so some of the troubleshooting tools might be familiar to SQL performance people but it has some built-in capability to help isolate performance issues as well.This session will include a discussion of Power BI architecture and then will be a demo-heavy walkthrough of using the Power BI Performance Analyzer, SQL Profiler and Azure Log Analytics to help isolate and resolve performance issues with Power BI.  Read More

​

I’m getting the following error no matter what I do. I’ve casted all the columns to nvarchar in the sql query and the input parameter is text in SSRS and nvarchar(500) in the stored procedure. If I run the query/stored procedure it works fine. but if I run it in SSMS I get this error no matter what I do?

What I have tried:

1. Casted all the select columns to nvarchar

2. the ssrs report parameter is “text” and the stored procedure parameters are numeric but casted as nvarchar

3. Some of the data has null rows would that cause this error?

SQL (obfuscated of course)

Error:

An error has occurred during report processing. (rsProcessingAborted)
Cannot read the next data row for the dataset datasource1. (rsErrorReadingNextDataRow)
Error converting data type nvarchar to numeric.

​I’m getting the following error no matter what I do. I’ve casted all the columns to nvarchar in the sql query and the input parameter is text in SSRS and nvarchar(500) in the stored procedure. If I run the query/stored procedure it works fine. but if I run it in SSMS I get this error no matter what I do? What I have tried:1. Casted all the select columns to nvarchar2. the ssrs report parameter is “text” and the stored procedure parameters are numeric but casted as nvarchar3. Some of the data has null rows would that cause this error? SQL (obfuscated of course)ALTER PROCEDURE SSRS_GetSomething @ListOfIds as nvarchar(500)ASBEGINSET NOCOUNT ON; —Check the string for multiple premiseid’s and parse the string to convert from premise to numericDECLARE @result as nvarchar(500) select TRY_CAST(id as nvarchar) as ‘ID1’,TRY_CAST(id2 as nvarchar) as ‘ID2’,streetaddress as ‘StreetAddress’,TRY_CAST([PossibleYear] as nvarchar) as ‘Year’,TRY_CAST(test2 as nvarchar) as ‘test2’,TRY_CAST(year3 as nvarchar) as ‘Year3’,TRY_CAST(numeric8 as nvarchar) as ‘NumericColumn’,TRY_CAST(numeric9 as nvarchar) as ‘numeric9’,TRY_CAST(numeric10 as nvarchar) as ‘Numeric10’,TRY_CAST(numeric11 as nvarchar) as ‘numeric11’,TRY_CAST(numeric12 as nvarchar) as ‘Numeric12’ from table1 border by b.numeric1 desc,b.numeric2 , b.numeric3; ENDGO Error:An error has occurred during report processing. (rsProcessingAborted)Cannot read the next data row for the dataset datasource1. (rsErrorReadingNextDataRow)Error converting data type nvarchar to numeric.  Read More

​

Hi Team,

I have below sample data:

We need to create a dax using below logics:

filter HeatSense_Device table for last four hours(use ‘UpdatedOn'(max&min datetime) column for this)Then look if the ‘UserMode’ contains ‘heat’ in all rows.If the above 2 conditions are true then return “Heating on Last 4 Hours” else blank.

We tried to create the below logic but its not giving correct output:

Last 4 Hours in Heat =

var latestdatetime = max(HeatSense_Device[UpdatedOn])
var earliestdatetime = latestdatetime-4/24

var last4hours =
CALCULATETABLE(HeatSense_Device,HeatSense_Device[UpdatedOn]<=latestdatetime && HeatSense_Device[UpdatedOn]>=earliestdatetime)

var maximummode = MAXX(last4hours,HeatSense_Device[UserMode])
var minimummode = MINX(last4hours,HeatSense_Device[UserMode])

return
if(and(maximummode=”heat”,minimummode=”heat”),”Heating on Last 4 Hours”,BLANK())

Ouput:

When I bring in UpdatedOn column into visual to test the above dax, it retuns the whole 24hours instead of last four hours. I want to show only last four hours where there is heat in table.

Could you please help us in creating a dax or modify the above dax ?

PFA file here Heatsense – Copy.pbix

Please advise!

Thanks in advance!

@SergeiBaklan 

​Hi Team, I have below sample data: We need to create a dax using below logics:filter HeatSense_Device table for last four hours(use ‘UpdatedOn'(max&min datetime) column for this)Then look if the ‘UserMode’ contains ‘heat’ in all rows.If the above 2 conditions are true then return “Heating on Last 4 Hours” else blank.We tried to create the below logic but its not giving correct output:  Last 4 Hours in Heat =

var latestdatetime = max(HeatSense_Device[UpdatedOn])
var earliestdatetime = latestdatetime-4/24

var last4hours =
CALCULATETABLE(HeatSense_Device,HeatSense_Device[UpdatedOn]<=latestdatetime && HeatSense_Device[UpdatedOn]>=earliestdatetime)

var maximummode = MAXX(last4hours,HeatSense_Device[UserMode])
var minimummode = MINX(last4hours,HeatSense_Device[UserMode])

return
if(and(maximummode=”heat”,minimummode=”heat”),”Heating on Last 4 Hours”,BLANK())  Ouput: When I bring in UpdatedOn column into visual to test the above dax, it retuns the whole 24hours instead of last four hours. I want to show only last four hours where there is heat in table.Could you please help us in creating a dax or modify the above dax ? PFA file here Heatsense – Copy.pbixPlease advise! Thanks in advance!@SergeiBaklan   Read More

​

Yes, it is generally safe to convert MBOX files to PDF as long as you use trusted software or tools. MBOX files contain email messages, and converting them to PDF simply transforms the message content into a readable, printable format. However, here are some safety considerations:

1. Use Trusted Software: Ensure that the tool or software you are using for the conversion is from a reliable source to avoid malware or other security risks.

2. Check Privacy Policies: If you are using an online tool, make sure it has a good reputation for privacy and does not store your emails or data.

3. Backup Your Data: Before converting, it’s a good practice to back up your MBOX files to prevent any data loss.

4. Be Cautious of Attachments: If your emails contain attachments, ensure that sensitive attachments are handled properly in the conversion process.

If you are mindful of these points, the conversion process should be safe.

​Yes, it is generally safe to convert MBOX files to PDF as long as you use trusted software or tools. MBOX files contain email messages, and converting them to PDF simply transforms the message content into a readable, printable format. However, here are some safety considerations: 1. Use Trusted Software: Ensure that the tool or software you are using for the conversion is from a reliable source to avoid malware or other security risks. 2. Check Privacy Policies: If you are using an online tool, make sure it has a good reputation for privacy and does not store your emails or data. 3. Backup Your Data: Before converting, it’s a good practice to back up your MBOX files to prevent any data loss. 4. Be Cautious of Attachments: If your emails contain attachments, ensure that sensitive attachments are handled properly in the conversion process. If you are mindful of these points, the conversion process should be safe.  Read More

​