Hello,   I'm encountering an unexpected behaviour while connecting with Direct Quert to Power BI dataset and creating local (composite) model from it.   'Show values of the selected field' option of Field Parameters when they are used within a slicer (blog announcment) is not available anymore.   If I'm connecting directly via DQ to PBI dataset this option works fine, it stops working when clicking 'Make changes to this model' on lower bar next to Storage Mode information. As soon as I make this change, slicer with this option breaks and the error is generic "Something's wrong with one or more fields". If I try to set this up while already being in Composite model mode this option is not available in context menu.   I realise that Field Parameters are preview feature, but is this expected behaviour? It is not described as limitation in documentation. ... View more

Bug: Filter Pane Visibility on App Differs to Individual Report   I've republished a report to the service and updated the app to suit, however the filter pain is completely unavailable on the app but is visible on the report. I've ensured it's visibility in edit mode, as well as disabling it, publishing and enabling it again for a subsequent publish - but it wont enable on the app at all (specifically the report within the app).   I've tried multiple browsers and cleared the cache, no joy. It has been enabled in the past, so I've no idea if it's an issue with the latest release - but I'm surprised others haven't mentioned it, so it's doubtful to be widespread.   I originally had filters on a separate bookmark, but I've removed them all now in favour of the filter pane for everyone to use across all pages, but since I can't get them working on the main app that everyone uses they currently have no filters at all (unless they access the report separately, but not everyone has access to that). ... View more

Field Parameter is working in PowerBI Desktop but not in PowerBI Server. Is there a solution or workaround? Thank you! ... View more

Datamart is "refreshing" but it is producing empty tables with no fields instead of populating the actual data from the dataflows. This issue has been occuring for the 2 weeks.  When I "edit" the Datamart the tables will populate with the actual data from the data flows but then when I attempt to save it when it comes to the loading data setp I recieve the error message below.  I'm not seeing any errors in the dataflows and the formatting and columns have not changed.  All data sources from existing dataflows which I can access directly and like I said I'm not seeing errors or issues within the dataflow and they are refreshing properly. Loading data OperationCanceled ErrorMessageThe current operation was canceled because one or more operations failed. HttpStatusCode400 Activity ID8e3f57e4-042e-10b4-9b8e-fe79b8f4a59a Request ID0c198856-158e-4886-8e84-756994f51d08 Status code500 Error CodeOperationCanceled Batch ID8e5718cf-1d7f-4d33-bc90-278e0a5b8728@d9edeb66-6d00-456e-a8dd-7682fec3462f$2023-05-02T15:49:50.4829816Z@88e5575b-cbc9-40e4-9e78-8b453e94d6f8 ... View more

The New feature Clear All Slicers button (part of March 2023 release) works only for the 1st time in both desktop & Service. And it does nothing when you do some more slicer changes & try to use it 2nd time. When you click, it does nothing! It is of no use if this issue is not fixed.    Any one else tried to use this?  ... View more

Good afternoon Dear Mr.(a), am using the DAX function USERNAME() to show the user name loged in windows.   I am using the following measurement: Fulfillment = VAR Hour = HOUR(NOW()) VAR Greeting = SWITCH(TRUE(), Time >= 5 && Time < 12, "Good morning", Time >= 12 && Time < 18, "Good afternoon", Time >= 18 && Time < 24, "Good evening", Time >= 0 && Time < 5, "Good morning", "Hello")   However, after the report was published instead of the windowns user name my email from the power bi service appears. i tried to switch to the USERPRINCIPALNAME() function but i got the same result.   On any machine that I open the published report, my e-mail from the power bi service appears. how to solve it? ... View more

So we migrated much of our workspaces to be connected to Pipelines. We have a DEV, TEST and PRODUCTION workspaces for every workspace. Then implemented a Change Management process that will only gives a handful of people permission to publish to the Production workspace. Deveopers and Report writers only have VIEW access in the Production workspaces.   We noticed that if someone has VIEW rights, they can only see Reports in the WebUI. Dataflows and Datasets are filtered out. We leverage DataFlows heavilly to cleanup and better organize our data. All reports are written against the Dataflow tables and don't touch our source systems at all. Our DEVs would like to see when the tables last refreshed or if there were any errors but we don't want them having any edit rights. We noticed DEVs were editing the production dataflows directly causing issues with other reports and keeping our Pipelines in sync. Hence the lockdown and migration to Pipelines for change managmenet controls.   Is there a way to permission the workspace so people can still see and browse the dataflows without giving them access to edit them?  ... View more

We have successfully connected to a postgres database with dataflow.  However, there is no way to use this data in any report as the mechanism to 'promote' or 'certify' dataflows does not make the datasets visible.   1. select workspace 2. new dataflow 3. choose postgresql 4. enter credentials and selected tables 5. choose the three dots on the dataflow you just created -> settings 6.  Endorsement -> promote or certify -> apply 7. Choose Data Hub or Create -> Endorsed in your org 8.   BOOM - nothing here.     ... View more

Hello. I work with a datamart and can't connect and get data from an analysis service (not azure). When this functionality plan to add? ... View more

In Power BI Desktop installed from the Microsoft Store, the "Dataflows" connector has been missing for at least 6 months, no matter what version.   Example:  Clicking on the Get Data "quick start" menu shows "Dataflows", when selecting it, nothing happens.   Example:  Clicking on "More" from Get Data, navigating to Power Platform confirms "Dataflows" is missing.   I've submitted 2 separate tickets over the last 4 months, but they manage to close the ticket by suggesting downloading the version from powerbi.com.  That is not a solution, I'm trying to point out the Bug in the Store Version. ... View more

Buenas tardes, en la documentación de estudio en el epígrafe: Generación de perfiles de datos en Power BI. En el párrafo: "Distribución de columnas muestra la distribución de los datos en la columna y los recuentos de valores distintos y únicos. Ambos pueden indicar los detalles sobre los recuentos de datos. Los valores distintos son todos los diferentes valores de una columna, incluidos los duplicados y los valores NULL, mientras que los únicos no incluyen los duplicados ni los valores NULL.    He estado comprobando mediante un ejemplo (columna Designación) y el conteo de valores únicos es incorrecto. Ejemplo Cuando se hace referencia a "los valores únicos no incluyen los duplicados ni los valores NULL". En esta columna debería sumar como valor único 3 (el valor Senior Manager no debería de contarlo ya que está duplicado) y no 4 como muestra. Sin embargo para la columna Nombre Empresa si es correcto los valores únicos.     https://learn.microsoft.com/es-es/training/modules/clean-data-power-bi/6-profile-data ... View more

Not sure if this is a bug, i have a measure with a dynamic title that i want to apply as a field value under conditional formatting however it was not appearing after i select the measure. My pbi is connected to a AAS server with live connection but i was able to do it in a older version of PBI desktop, see images below, they are both connected to same data source the only difference is the version of PBI, is this a known issue?   version March 2023   version 2022     ... View more

Hi, when i try push sql import in databricks with a sql query, return "this value cant is null". like in the print     ... View more

The text "Install now" on the button is not clearly visible while installing Gateways in Power BI Service. It's font color should be white as we have at other places. ... View more

Feedback Type: Frown (Error) Timestamp: 2023-04-14T21:36:51.4109585Z Local Time: 2023-04-14T14:36:51.4109585-07:00 Session ID: a5fd3a69-6fce-44f0-97e3-39de758b91df Release: April 2023 Product Version: 2.116.622.0 (23.04) (x86) Stack Trace: System.Runtime.InteropServices.SEHException 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.Application.RunDialog(Form form) 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.WebDialogs.WebDialog.<>c__DisplayClass57_0.<ShowModal>b__0() at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.ShowModal(IWindowHandle owner) at Microsoft.Mashup.Client.UI.Shared.Ux.WindowService.ShowDialog(IDialog dialog) at Microsoft.PowerBI.Client.Windows.FloatingDialog.StartDialog.Show(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, IPowerBIQueryUIService queryServices, IReportManager reportManager, IAutoRecoveryManager autoRecoveryManager, ILegacyUIHost uiHost, IUIBlockingService uiBlockingService, IPowerBIWindowServiceFactory windowServiceFactory, IFileHistoryManager fileHistoryManager, IAuthenticationManager authenticationManager, IUpdateNotificationManager updateNotificationManager, IApplicationCommands applicationCommands, IPowerBISettings powerBISettings, IUISettings uiSettings, IEventAggregationService eventAggregationService, IPowerBITelemetryService telemetryService, IUrlOpener urlOpener) at Microsoft.PowerBI.Client.Windows.MainWindow.<ShowStartDialog>d__96.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task) at Microsoft.PowerBI.Client.Program.<>c__DisplayClass6_2.<<RunApplication>b__6>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.MainWindow.<<ActivateMainWindow>b__116_1>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext() Error Code: -2147467259 (0x80004005) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.116.622.0","ModuleName":"Microsoft.Mashup.Client.UI.dll","Component":"Microsoft.Mashup.Client.UI.Windows.DialogWindowBase","Error":"System.Runtime.InteropServices.SEHException","MethodDef":"ShowModal","ErrorOffset":"10"} OS Version: Microsoft Windows NT 10.0.19045.0 (x64 en-US) CLR Version: 4.8 or later [Release Number = 528372] Peak Virtual Memory: 1.57 GB Private Memory: 431 MB Peak Working Set: 561 MB IE Version: 11.789.19041.0 User ID: b645d8e7-e641-4d88-b332-654ee733d2bf Workbook Package Info: 1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False. Telemetry Enabled: True Model Default Mode: Empty Model Version: PowerBI_V1 Enabled Preview Features: PBI_enableWebView2 PQ_WebView2Connector PBI_sparklines PBI_scorecardVisual PBI_NlToDax PBI_fieldParametersSuperSwitch PBI_horizontalFusion PBI_optimizeTabRibbon PBI_relationshipEditPane PBI_setLabelOnExportPdf Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_azureMapVisual PBI_b2bExternalDatasetSharing PBI_enhancedTooltips PBI_angularRls PBI_onObject PBI_dynamicFormatString Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 150% Supported Services: Power BI ... View more

When I give user direct access to the report, then there is an informational msg that says `People with direct access can view this report and use the data associated with it, regardless of its sensitivity label.`   When the end user opens this report, then the reporet has the sensitivity label applied, so what exactly does the above msg mean?       ... View more

When presenting data in matrix visual, on occasion, segoe font fails to load the string data and returns within the visual context a condenced-hardly-visibile data row. changin to any other font resolves the missing row.    see screen shot below with Segoe as font (theres a hardly visible line with data between MATE and UTE) Once changing font to DIN then the row magically re-appears    ... View more