When using two UNICHAR results for the return of a DAX IF function, the behavior is not expected.   As the following print screen:     The problem doesn't occur when using a UNICHAR result and a simple text      Here is the DAX formula   SincroniaViagemDia = if( DATEDIFF('sir Viagem'[DataHoraSincronizacao],TODAY(),DAY)=0 && DATEDIFF('sir Viagem'[DataHoraFechamentoViagem],TODAY(),DAY)=0 , "OK", UNICHAR(9940))   ... View more

Hello forum,   I really appreciate if anyone could help me to solve this problem. I was practicing to plot model in power BI with python code, but when I tried simple code to visualize my data, the error was popping up. I attach my error below.     Feedback Type: Frown (Error) Timestamp: 2022-04-20T16:11:23.5074808Z Local Time: 2022-04-20T23:11:23.5074808+07:00 Session ID: 65ac636c-ea4f-4faa-9443-0db31382d679 Release: February 2022 Product Version: 2.102.683.0 (22.02) (x64) Stack Trace: Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: Python script error. C:\Users\GS2200017\anaconda3\lib\site-packages\numpy\__init__.py:143: UserWarning: mkl-service package failed to import, therefore Intel(R) MKL initialization ensuring its correct out-of-the box operation under condition when Gnu OpenMP had already been loaded by Python process is not assured. Please install mkl-service package, see http://github.com/IntelPython/mkl-service from . import _distributor_init Traceback (most recent call last): File "C:\Users\GS2200017\anaconda3\lib\site-packages\numpy\core\__init__.py", line 22, in <module> from . import multiarray File "C:\Users\GS2200017\anaconda3\lib\site-packages\numpy\core\multiarray.py", line 12, in <module> from . import overrides File "C:\Users\GS2200017\anaconda3\lib\site-packages\numpy\core\overrides.py", line 7, in <module> from numpy.core._multiarray_umath import ( ImportError: DLL load failed while importing _multiarray_umath: The specified module could not be found. During handling of the above exception, another exception occurred: Traceback (most recent call last): File "C:\Users\GS2200017\PythonScriptWrapper_c7215ef9-e412-46b7-b14c-196a7bcdaccb\PythonScriptWrapper.PY", line 2, in <module> import os, uuid, matplotlib File "C:\Users\GS2200017\anaconda3\lib\site-packages\matplotlib\__init__.py", line 107, in <module> from . import _api, cbook, docstring, rcsetup File "C:\Users\GS2200017\anaconda3\lib\site-packages\matplotlib\cbook\__init__.py", line 28, in <module> import numpy as np File "C:\Users\GS2200017\anaconda3\lib\site-packages\numpy\__init__.py", line 145, in <module> from . import core File "C:\Users\GS2200017\anaconda3\lib\site-packages\numpy\core\__init__.py", line 48, in <module> raise ImportError(msg) ImportError: IMPORTANT: PLEASE READ THIS FOR ADVICE ON HOW TO SOLVE THIS ISSUE! Importing the numpy C-extensions failed. This error can happen for many reasons, often due to issues with your setup or how NumPy was installed. We have compiled some common reasons and troubleshooting tips at: https://numpy.org/devdocs/user/troubleshooting-importerror.html Please note and check the following: * The Python version is: Python3.9 from "C:\Users\GS2200017\anaconda3\python.exe" * The NumPy version is: "1.20.3" and make sure that they are the versions you expect. Please carefully study the documentation linked above for further help. Original error was: DLL load failed while importing _multiarray_umath: The specified module could not be found. ---> Microsoft.PowerBI.Scripting.Python.Exceptions.PythonScriptRuntimeException: Python script error. C:\Users\GS2200017\anaconda3\lib\site-packages\numpy\__init__.py:143: UserWarning: mkl-service package failed to import, therefore Intel(R) MKL initialization ensuring its correct out-of-the box operation under condition when Gnu OpenMP had already been loaded by Python process is not assured. Please install mkl-service package, see http://github.com/IntelPython/mkl-service from . import _distributor_init Traceback (most recent call last): File "C:\Users\GS2200017\anaconda3\lib\site-packages\numpy\core\__init__.py", line 22, in <module> from . import multiarray File "C:\Users\GS2200017\anaconda3\lib\site-packages\numpy\core\multiarray.py", line 12, in <module> from . import overrides File "C:\Users\GS2200017\anaconda3\lib\site-packages\numpy\core\overrides.py", line 7, in <module> from numpy.core._multiarray_umath import ( ImportError: DLL load failed while importing _multiarray_umath: The specified module could not be found. During handling of the above exception, another exception occurred: Traceback (most recent call last): File "C:\Users\GS2200017\PythonScriptWrapper_c7215ef9-e412-46b7-b14c-196a7bcdaccb\PythonScriptWrapper.PY", line 2, in <module> import os, uuid, matplotlib File "C:\Users\GS2200017\anaconda3\lib\site-packages\matplotlib\__init__.py", line 107, in <module> from . import _api, cbook, docstring, rcsetup File "C:\Users\GS2200017\anaconda3\lib\site-packages\matplotlib\cbook\__init__.py", line 28, in <module> import numpy as np File "C:\Users\GS2200017\anaconda3\lib\site-packages\numpy\__init__.py", line 145, in <module> from . import core File "C:\Users\GS2200017\anaconda3\lib\site-packages\numpy\core\__init__.py", line 48, in <module> raise ImportError(msg) ImportError: IMPORTANT: PLEASE READ THIS FOR ADVICE ON HOW TO SOLVE THIS ISSUE! Importing the numpy C-extensions failed. This error can happen for many reasons, often due to issues with your setup or how NumPy was installed. We have compiled some common reasons and troubleshooting tips at: https://numpy.org/devdocs/user/troubleshooting-importerror.html Please note and check the following: * The Python version is: Python3.9 from "C:\Users\GS2200017\anaconda3\python.exe" * The NumPy version is: "1.20.3" and make sure that they are the versions you expect. Please carefully study the documentation linked above for further help. Original error was: DLL load failed while importing _multiarray_umath: The specified module could not be found. at Microsoft.PowerBI.Scripting.Python.PythonScriptWrapper.RunScript(String originalScript, Int32 timeoutMs) at Microsoft.PowerBI.Client.Windows.Python.PythonScriptHandler.GenerateVisual(ScriptHandlerOptions options) --- End of inner exception stack trace --- at Microsoft.PowerBI.Client.Windows.Python.PythonScriptHandler.GenerateVisual(ScriptHandlerOptions options) at Microsoft.PowerBI.ExploreHost.SemanticQuery.ScriptVisualCommandFlow.RunInternal(Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor) at Microsoft.PowerBI.ExploreHost.SemanticQuery.ScriptVisualCommandFlow.Run(Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor) at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.TransformDataShapeResult(QueryCommand transformCommand, SemanticQueryDataShapeCommand command, Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor) at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ExecuteDataQuery(IQueryResultDataWriter queryResultDataWriter, EngineDataModel engineDataModel, DataQuery query, Int32 queryId, ServiceErrorStatusCode& serviceErrorStatusCode, CancellationToken cancelToken) at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteSemanticQueryCommands(IQueryResultsWriter queryResultsWriter, IList`1 queries, HashSet`1 pendingQueriesToCancel, EngineDataModel engineDataModel) OS Version: Microsoft Windows NT 10.0.22000.0 (x64 en-US) CLR Version: 4.7 or later [Release Number = 528449] Peak Virtual Memory: 54.4 GB Private Memory: 778 MB Peak Working Set: 904 MB IE Version: 11.1.22000.0 User ID: 97424b8e-e66c-4258-ab47-2a67f39c7581 Workbook Package Info: 1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True Model Default Mode: Import Model Version: PowerBI_V3 Enabled Preview Features: PBI_enableWebView2 PBI_mobileAuthoringFormattingUI PBI_useModernFormatPane PBI_sparklines Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_azureMapVisual PBI_dataPointLassoSelect PBI_compositeModelsOverAS PBI_dynamicParameters PBI_enhancedTooltips PQ_WebView2Connector PBI_scorecardVisual Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 125% Supported Services: Power BI ... View more

Hi, Power BI was upgraded to the new Version: 2.103.881.0 64-bit (March 2022) and it appears "Data Colors" is no longer an option supported on the new sidebar...       Is this feature going to be deprecated? I can see that this is still available on the Power BI web version (app.powerbi.com):     Also, is there a possibility of restoring the old sidebar?  The new one requires around 3x as many clicks to do the same thing, e.g. when choosing a custom map:   OLD-       NEW-       Thank you ... View more

When building a treemap visual in my PowerBI workspace there is an error showing only "placeholder text" when I try to select a metric to format by in the drop down. This should show all the metrics I have available in my dataset to then be able to add rules accordingly. This is only happening in the web service and show appropriately in the PowerBI desktop file before publishing. Is anyone else experiencing this issue?     ... View more