Hi Folks, I recently encountered a scenario where I need to utilize the slicer value as a parameter for a Snowflake stored procedure. Currently, I'm connecting to Snowflake through ODBC, fetching data into Power BI. The requirement is to create a report where passing the company_Code value from the slicer would function as a parameter to the Snowflake stored procedure. Your assistance on this matter would be greatly appreciated. Thank you. ... View more

I found a general bug of PBI (Desktop + Service):  when a decimal number is formatted to have 0 decimal place, any export from PBI into csv will only export the whole number, but no decimal This has led to a lot compatilibity issues, for example, PBI users may want to format the field to 0 decimal in order to have a clean visual, however, since csv is rounded, export loses a lot of accuracy. I have a dataset which exported csv doesn't match original, the error margin is very large.    I think MS needs to fix this issue in order for the tool to be more accurate and useful.   Version: 2.128.751.0 64-bit (April 2024)         ... View more

I am not able to embed Power BI smart narrative using copilot in Salesforce. Can anybody help me out? ... View more

  Feedback Type: Frown (Error) Error Message: Value cannot be null. Parameter name: evaluation Stack Trace: Microsoft.Mashup.Client.UI.Shared.JavaScriptInvocationException at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeScript(Func`1 invokeScript) at Microsoft.Mashup.Client.UI.Shared.AjaxHost.AjaxHandler.<>c__DisplayClass11_0.<OnProcessAjaxAsync>b__0() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_0.<SendAndMarshalExceptions>b__0(Object null) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback) at Microsoft.Mashup.Client.UI.Shared.AjaxHost.AjaxHandler.OnProcessAjaxAsync(Object state) at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) Stack Trace Message: Value cannot be null. Parameter name: evaluation Invocation Stack Trace: at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace() at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage) at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e) at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture) at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_0.<SendAndMarshalExceptions>b__0(Object null) at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbacks() at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at Microsoft.Mashup.Client.UI.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle) at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner) at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.Mashup.Client.UI.Shared.Ux.CredentialsChallengeResolver.ShowResolveDialog(IWindowHandle owner, IUIHost uiHost) at Microsoft.Mashup.Client.UI.Shared.QueriesExtensions.TryResolveResourceChallenge(Queries queries, FormulaPath formulaPath, ResourceChallenge resourceChallenge, IWindowHandle owner, IUIHost uiHost, Boolean saveChanges, ChallengeParameters challengeParameters) at Microsoft.PowerBI.Client.Windows.AnalysisServices.MashupEditor.<>c__DisplayClass10_0.<EditCredentials>b__1(IWindowHandle ownerWindow) at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3_0`1.<SendAndMarshalExceptions>b__0() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_0.<SendAndMarshalExceptions>b__0(Object null) at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbacks() at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.PowerBI.Client.Program.<>c__DisplayClass6_0.<RunApplication>b__0() at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.PowerBI.Client.Program.RunApplication(String[] args) at Microsoft.PowerBI.Client.Program.Main(String[] args) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.126.1261.0","ModuleName":"Microsoft.Mashup.Client.UI.dll","Component":"Microsoft.Mashup.Host.WorkspaceWeb.Controllers.ChallengesSharedExports+JsonResourceChallengeRequest","Error":"System.ArgumentNullException","MethodDef":"Validate","ErrorOffset":"16","ErrorCode":""} InnerException0.Stack Trace Message: Value cannot be null. Parameter name: evaluation InnerException0.Stack Trace: at Anonymous function (ms-pbi://pbi.microsoft.com/ts/Editor/Challenges/Shared.js:53:17) at evaluationHandler.doneCallback (ms-pbi://pbi.microsoft.com/ts/Editor/CoreEvaluation.js:104:17) at success (ms-pbi://pbi.microsoft.com/ts/Editor/CoreEvaluation.js:133:21) at ajaxSuccessFunction (ms-pbi://pbi.microsoft.com/ts/Editor/Core.js:166:17) at ajax.success (ms-pbi://pbi.microsoft.com/ts/Editor/Core.js:460:13) at Core.ajaxHostCompletionCore (ms-pbi://pbi.microsoft.com/ts/Editor/Core.js:79:13) at Core.ajaxHostCompletion (ms-pbi://pbi.microsoft.com/ts/Editor/Core.js:73:9) at eval code (eval code:1:1) InnerException0.Invocation Stack Trace: at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace() at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix) at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth) at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e) at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail) at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture) at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_0.<SendAndMarshalExceptions>b__0(Object null) at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbacks() at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at Microsoft.Mashup.Client.UI.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle) at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner) at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.Mashup.Client.UI.Shared.Ux.CredentialsChallengeResolver.ShowResolveDialog(IWindowHandle owner, IUIHost uiHost) at Microsoft.Mashup.Client.UI.Shared.QueriesExtensions.TryResolveResourceChallenge(Queries queries, FormulaPath formulaPath, ResourceChallenge resourceChallenge, IWindowHandle owner, IUIHost uiHost, Boolean saveChanges, ChallengeParameters challengeParameters) at Microsoft.PowerBI.Client.Windows.AnalysisServices.MashupEditor.<>c__DisplayClass10_0.<EditCredentials>b__1(IWindowHandle ownerWindow) at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3_0`1.<SendAndMarshalExceptions>b__0() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_0.<SendAndMarshalExceptions>b__0(Object null) at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbacks() at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.PowerBI.Client.Program.<>c__DisplayClass6_0.<RunApplication>b__0() at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.PowerBI.Client.Program.RunApplication(String[] args) at Microsoft.PowerBI.Client.Program.Main(String[] args) ... View more

Hi,   I have an issue that I just cannot figure out why it is a problem. I have a page that has a slicer.   I also have a drill-through option so that people can see what this value is made up of, taking the to a drill-through page   The drill-through page has the product group, name and priority   Now, it works perfectly fine if I have selected Critical on the slicer   But if I select High, the values on the table do change and the drill-through option in the Tooltip is still there Except this time when I drill through, I get a blank page Why?         ... View more

I am currently trying to implement a DirectLake semantic model with Power BI embedded (Embed for your customers) inside a C# ASP.NET Core web application. When I try to generate a token using the GenerateTokenAsync(workspaceId, reportId, tokenReuest) method, I get a BadRequest error with the message "Embedding a DirectLake dataset is not supported with V1 embed token".   Is there another option to use DirectLake as my semantic model in this case or am I needing to use DirectQuery? Any timeline when this will be available? ... View more

The button for activating an alert for the report is incorrectly labeled in the Power BI service (at least when using German as the display language). This happens both in reports and apps.     ... View more

Unable to create new dataflows in GCC tenant. When you click to Add table then choose any connector, I instantly get the following message.  ... View more

Cuando público desde el PB Desktop a la nube no me guarda los filtros puestos.  Esto pasa desde la semana pasada a mí y a varios compañeros.    ... View more

wertwertw wertwertw wertwerter ... View more

xfghjk sd fgdtfyj ghfjuhgil ... View more

Our gateway is up to date (we just updated a few days ago) and I have been having this issue since the March gateway update. Random reports will frequently get this refresh error during it's scheduled refresh in Power BI service. This error is not consistent. For example, a 9:00am refresh completed without issue and then an 11:00am refresh failed with this error:   {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<ccon>An error happened while reading data from the provider: 'Access to the path 'C:\\Windows\\ServiceProfiles\\PBIEgwService\\AppData\\Local\\Temp\\Microsoft\\MashupProvider\\Cache\\Uzd@iy7VOEcSTQNocKkMETMMCDlJeLNn+iocalJLh2WI=\\Cache.Key' is denied.'</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"<ccon>rjc-sql3;BI_ReferenceTables</ccon>"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Safety Data.   I have tried researching this error and have gotten nowhere. Does anyone know why this is happening/how to fix it?   Thank you! ... View more

Hi,   Loading any logs from a pipeline/notebook runs fails with "Unable to complete the action because your organization's Fabric compute capacity has exceeded it's limits. Try again later." I've maxxed out the capactity and it still fails.     To dig further I wanted to check the actual capacity usage and installed the Fabric Capacity Metrics App. I managed to connect it and can select the 3 different capacties, but all metrics just show: 'An error occurred due to an on premise service issue'. Do you know what could be causing this issue?   ... View more

After closing or report the issue, the message it keep showing. The only way to close it is by force shutdown with task manager. The message always appears when I want to use quick measure to calculate percentage differences or other differences. But there are no errors for other calculations. I already tried to reinstalling power bi and rebooting pc, but nothing work.  ------- Feedback Type: Frown (Error) Error Message: An error occurred while rendering the report. Stack Trace: Javascript&colon;TypeError at convertParameterToInputValue (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.quick-measures-lazy.min.js:2128:53) at DaxTemplateStoreService.<anonymous> (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.quick-measures-lazy.min.js:1971:70) at https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:106599:43 at Object.next (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:106610:26) at fulfilled (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:106514:44) at _ZoneDelegate.invoke (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:140766:180) at hooked_1.invoke (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:469523:88) at Object.onInvoke (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:594779:64) at _ZoneDelegate.invoke (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:140766:68) at Zone.run (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:140627:59) Stack Trace Message: An error occurred while rendering the report. Invocation Stack Trace: at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace() at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage) at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e) at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture) at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0() at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.PowerBI.Client.Windows.Utilities.PowerBIFormUnexpectedExceptionHandler.HandleException(Exception e) at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass15_0.<ExecuteInteropCsMethod>b__0() at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<ExecuteInteropCsMethod>d__15.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.ExecuteInteropCsMethod(Object interopObj, MethodInfo method, Object[] arguments, Nullable`1 runOn, Nullable`1 jsonOptions) at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.<>c__DisplayClass22_0.<<InvokeCsMethod>b__0>d.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.<>c__DisplayClass22_0.<InvokeCsMethod>b__0() at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAsyncExceptions>d__0.MoveNext() at System.Runtime.CompilerServices.AsyncVoidMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc) at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.InvokeCs(InteropCall call) at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at System.EventHandler`1.Invoke(Object sender, TEventArgs e) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.PowerBI.Client.Program.<>c__DisplayClass7_0.<RunApplicationLegacy>b__0() at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.PowerBI.Client.Program.RunApplicationLegacy(String[] args) at Microsoft.PowerBI.Client.Program.Main(String[] args) JS Error Message: Cannot read properties of undefined (reading 'value') PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.128.952.0","ModuleName":"https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.quick-measures-lazy.min.js","Component":"","Error":"TypeError","MethodDef":"convertParameterToInputValue","ErrorOffset":"2128:53","ErrorCode":""} Snapshot Trace Logs: C:\Users\unfoc\Microsoft\Power BI Desktop Store App\FrownSnapShotdf75347e-6d54-4f09-924c-01f78b2ff368.zip Model Default Mode: Import Model Version: PowerBI_V3 Performance Trace Logs: C:\Users\unfoc\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip Enabled Preview Features: PBI_sparklines PBI_scorecardVisual PBI_NlToDax PBI_fieldParametersSuperSwitch PBI_angularRls PBI_backstageUI PBI_setLabelOnExportPdf PBI_dynamicFormatString PBI_oneDriveSave PBI_oneDriveShare PBI_useModernPublishDialogs PBI_gitIntegration PBI_newCard PBI_buttonSlicerAuthoring PBI_mobileAutoReportLayout PBI_daxQueryView PBI_daxInlineCopilot PBI_aiNarrativesVisual PBI_generateMeasureDescriptionsButton PBI_desktopReportAuthoringCopilot Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_b2bExternalDatasetSharing PBI_enhancedTooltips PBI_onObject PBI_tmdlInDataset PBI_EimLessElevatedUser PBI_modelExplorer PBI_qnaImproveLsdlCopilot PBI_visualCalculationsAuthoring Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud PowerBIUserFeedbackServices_IsReported: True Formulas: section Section1; shared Sheet1 = let Source = Excel.Workbook(File.Contents("C:\Program Files\WindowsApps\Microsoft.MicrosoftPowerBIDesktop_2.128.952.0_x64__8wekyb3d8bbwe\bin\SampleData\Financial Sample.xlsx"), null, true), Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Segment", type text}, {"Country", type text}, {"Product", type text}, {"Discount Band", type text}, {"Units Sold", type number}, {"Manufacturing Price", Int64.Type}, {"Sale Price", Int64.Type}, {"Gross Sales", type number}, {"Discounts", type number}, {" Sales", type number}, {"COGS", type number}, {"Profit", type number}, {"Date", type date}, {"Month Number", Int64.Type}, {"Month Name", type text}, {"Year", Int64.Type}}) in #"Changed Type"; Active Section Contract: {"id":0,"name":"ReportSection","displayName":"Page 1","filters":"[]","ordinal":0,"visualContainers":[],"config":{},"displayOption":1,"width":1280,"height":720} ... View more

I completed one of my reports. It has a slicer that let me manipulate the date range.  However, when I go to publish this report, it seems everything remains the same except for the date range formatting, which is the only thing that changes. Is there any way I can fix this? or is this a bug?  ... View more

PBI Desktop Version: 2.128.952.0 64-bit (April 2024)   ISSUE: 0__migrate on-prem source to LH and 2 DFg2. 1__make a copy of old pbix report. 2__connect to new LH data source, all tables in DirectQuery mode. 3__start relinking all visuals; all tables have the same name and schema as when the report was connecting to on-prem source in Import mode. 4__one slicer still using the same field name as before (field still selected and no error icon shows) appears as broken. 5__click on 'See details.'  This is the error message that pops up:     6__remove field from data well; choose same field from Data pane, drag and drop it, and now the problem goes away.  Another slicer picks up the change automatically and the above is not needed for this slicer. But another slicer next to it, same interface issue.  Again, all tables are in DirectQuery mode. ... View more

Hello Fabric Team,   We are seeing some inconsistencies when using the ROUNDDOWN function. For example, when creating a measure/calculated column with this hardcoded formula:    (1.8-rounddown(1.8, 0))=0.8   The formula evaluates to TRUE, which is correct as 0.8=0.8   However, when we evaluate:   (2.8-rounddown(2.8, 0))=0.8   The formula evaluates to FALSE, which in our opinion is incorrect as 0.8=0.8, no matter how we got there. Please see below for our test tables:   On a call with the Fabric support team (ticket #2404220040008712), we tried and found that the same problem exists even when: We don't harcode the number and use references (columns, other measures) instead We use INT() or TRUNC() instead of ROUNDDOWN() We move the formula to Power Query and use Number.RoundDown instead We use strictly equal == or other operators like <= and >= Our current workaround is to put a ROUND on the left side of the formula, that seems to overcome the issue.   Lastly, not sure if this will help you investigate, but we noticed that the breaking point is between 1.8 and 1.9. Where if the decimal number is below or equal to 1.8 the formula will work properly, while it will not work if the decimal number is above 1.9, with the following exception: For some reason, 1.99 and 1.9999 works (evaluates to TRUE), but 1.9, 1.999, 1.99999 and beyond do not.   Looking forward to hearing back from you!   Regards,   Felix     ... View more

Is there a way to export to exce with  going to the upper right (...)  ... View more

When mapping the aggregates to the detail table.. if the column name is long its not fully available.. is there any way to see it fully and map?   ... View more