Hi Support team,   The Option and Settings havenot been working for over 2/3 months now. I have tried 4/5 times selecting new preview features and when I go back to it its unselected.     Surprised not been picked up as a bug.   Let me know if additional details requiured.     ... View more

Trying simple dataflows Gen 2 API call saving to a table in a lake house. All good on the power query screen. Query runs fine and is successful but the storing to lake house fails. Shows a credential error but have entered Oauth Organization creds everywhere. It just won't save them after it says it does with re-sign in.  ... View more

Please advise specific instructions on how it is possible for data from an on-premises SQL server database to be fed into a Lakehouse. When using Gen2 dataflow to connect to on-premises SQL server via a gateway (client using Power BI Premium), configuring a Lakehouse as the data destination does not work: If I use a Gen1 dataflow to connect to the on-premises SQL server, and then reference the result of this dataflow using a Gen2 dataflow, interface (most of the time) allows for the Lakehouse to be assigned as the data destination, but then the Gen2 dataflow fails to refresh and gives the following error: When above dataflow is referenced in a pipeline, the associated run fails and below error message is received:   Trying to connect to the on-premises SQL Server database via a pipeline does not appear to be an option as the only available connection method is "Basic" and there is no option to select the gateway.   ... View more

When creating a new data mart and connecting to a dataflow, below error messages received. Unable to refresh or use data mart.   ... View more

In the new update, when pressing the Alt key, the following shortcuts are highlighted.     This is welcome but there is a problem switching windows with other applications. If I'm in another application and I use Alt+Tab to switch to PBI, then the black short keys show up, interrupting any workflow. This is not how it work in any other application. For example, if I Alt+Tab into Word, the shortcut keys do NOT show until I press Alt when the window has focus. Please fix as this makes it impossible to switch between PBI and other applications at the moment without creating a lot of friction   PS Please consider adding shortcut keys to switch between report view, data view and model view.   ... View more

   Hi, Team   Power BI Desktop Version: 2.117.984.0 64-bit (May 2023)   We don’t’ understand ‘추천 가치’ in the Quick measure result. That should be ‘추천 측정값’ or '측정값 제안'.   Korean     English     Thanks, Hong   ... View more

May version came out yesterday, since then: 1) It is NOT POSSIBLE to make ANY CHANGE in "Options", the "ok" button greys out, and pop-up window just sits there.  2) Size of .pbix file keeps increasing every time "Save" button is clicked, even when there is very little to no actual data change   ... View more

Hi, This is my first post in the community, I hope this is the right place to write down this issue! My data model is connected to an Oracle databse using DirectQuery. I built a visual using columns from the data model without any issue. However, if I take one of the columns used in my visual, create a slicer widget, toggle on the search function, and type anything in the search box, the slicer widget crashes. The error message is "ORA-00904: "<table name>.<column name>": invalid identifier. The exception was raised by the IDbCommand interface". That sounds weird to me, because the table and column definitely exist: they work perfectly fin in my other visuals.   Any help you might offer with this issue would be amazing, thanks in advance! Cheers, JD     Feedback Type: Frown (Error) Timestamp: 2023-05-26T15:53:55.5401007Z Local Time: 2023-05-26T11:53:55.5401007-04:00 Session ID: 12eedd82-3a3e-4c44-8900-a0c85f5afa0c Release: March 2022 Product Version: 2.103.881.0 (22.03) (x64) OS Version: Microsoft Windows NT 10.0.19045.0 (x64 fr-CA) CLR Version: 4.7 or later [Release Number = 528372] Peak Virtual Memory: 104 GB Private Memory: 1.38 GB Peak Working Set: 1.59 GB IE Version: 11.789.19041.0 User ID: 0679fafa-cc4d-4b34-b641-5a22974e09ac Workbook Package Info: 1* - fr-CA, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True Model Default Mode: Composite 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 PBI_lineChartError Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BI ... View more

Good afternoon.   In a .pbix file which connects via Direct Query to another dataset, I'm getting the below error when trying to refresh:   I have simplified the model to try and narrow down the issue to the following (which is still receiving the above error):   As you will be able to see, no ambiguous path exists. One would exist if the relationship between DIM - Jobs and 'FACT - NL Budgets' was active, but it is not.   In an attempt to prove that this file should not be showing this error, I have created a new .pbix file with the exact same DirectQuery link to the dataset, and it refreshes completely fine.   Unfortunately I have quite a large and complex report built within the .pbix file which is showing the error, and I really do not want to have to spend time trying to move this over to a new file.   Can you please assist in investigating why this error is occuring? ... View more

We are having problems with 40% of our reports where they don't refresh. The error is "DM_GWPipeline_Gateway_MashupDataAccessError". We have already refreshed the DW server but it didn't work. The full error is bellow, only changing the name of the tables.   An error occurred while processing the data in the dataset. Falha na atualização: Falha na atualização do Fortali - Cargas Abertas. Detalhes da falha: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. {"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>Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"11"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"<ccon><ip>192.168.1.18</ip>;bi_rbfortali</ccon>"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: dimTempo. ... View more

I just installed the 2023 May update where Azure Map has been introduced as the big replacement map. However, when opening an older report already equipped with an Azure map visual (to change something completely unrelated), the report keeps crashing at random (at different pages), where the error details strongly seem to suggest Azure Map as the culprit (which would make sense, seeing how this has undergone significant changes this update). What seems to confirm my suspicions, is that deleting the Azure Map visual and saving the report as a copy without the map, seems to have solved all the crashes. That is, there hasn't been a single crash since, while with the Azure map visual, it crashed every two minutes at least.   Also, saving, closing, reopening the report (without the map) and then again adding (a new version of?) the Azure Map visual, immediately (~ after two minutes) reintroduces the crashes.   Part of the errordetails is pasted below:   Feedback Type: Frown (Error) Error Message: An error occurred while rendering the report. Stack Trace: Javascript&colon; TypeError at O.loadTile (https://atlas.microsoft.com/sdk/javascript/mapcontrol/2/atlas.min.js:55:411024)  at cr._loadTile (https://atlas.microsoft.com/sdk/javascript/mapcontrol/2/atlas.min.js:55:453959)  at cr._reloadTile (https://atlas.microsoft.com/sdk/javascript/mapcontrol/2/atlas.min.js:55:455712)  at https://atlas.microsoft.com/sdk/javascript/mapcontrol/2/atlas.min.js:55:462188  at args.<computed> (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:104853:59)  at ZoneDelegate.invokeTask (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:103736:193)  at Zone.runTask (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:103618:67)  at ZoneTask.invokeTask (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:103774:67)  at ZoneTask.invoke (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:103768:60)  at data.args.<computed> (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:104837:48) 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.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__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) JS Error Message: Cannot read properties of undefined (reading 'send') PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.117.984.0","ModuleName":"https://atlas.microsoft.com/sdk/javascript/mapcontrol/2/atlas.min.js","Component":"O","Error":"TypeError","MethodDef":"loadTile","ErrorOffset":"55:411024"} Snapshot Trace Logs: C:\Users\bi_admin\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot54547778-c39d-4e35-b524-23b0ef97a731.zip Model Default Mode: Composite Model Version: PowerBI_V3 Performance Trace Logs: C:\Users\bi_admin\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip Enabled Preview Features: PBI_shapeMapVisualEnabled PBI_enhancedTooltips PBI_enableWebView2 PQ_WebView2Connector PBI_sparklines PBI_scorecardVisual PBI_NlToDax PBI_fieldParametersSuperSwitch PBI_horizontalFusion PBI_angularRls PBI_setLabelOnExportPdf PBI_dynamicFormatString Disabled Preview Features: PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_b2bExternalDatasetSharing PBI_onObject PBI_oneDriveSave PBI_oneDriveShare Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud PowerBIUserFeedbackServices_IsReported: True   ... View more

Hai , Need an assist with below error, I can't open this Power bi desktop file now Feedback Type: Frown (Error) Error Message: You cannot add the calculated column 'GrSalesValue' to the hybrid table 'Invoice Detail'. Please remove the calculated column. Stack Trace: Microsoft.AnalysisServices.OperationException at Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title) at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, IFileManager fileManager, IFileHistoryManager fileHistoryManager, CommandLine commandLine, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager, IPowerBITelemetryService telemetryService) at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_1.<Main>b__3() at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) Stack Trace Message: You cannot add the calculated column 'GrSalesValue' to the hybrid table 'Invoice Detail'. Please remove the calculated column. 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.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.PowerBI.Client.Program.Main(String[] args) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.112.1161.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenError","Error":"Microsoft.AnalysisServices.OperationException - UNKNOWN_ERROR: 0xC141016A","MethodDef":"HandleError - UNKNOWN_ERROR: 0xC141016A","ErrorOffset":"201"} PowerBINonFatalError_ErrorDescription: UNKNOWN_ERROR: 0xC141016A PowerBINonFatalError_MethodDefDescription: UNKNOWN_ERROR: 0xC141016A PowerBIUserFeedbackServices_IsReported: True ... View more

Hi,    I have integrated Power BI for customers in my Power Pages instance and connected Power BI Capacity.    For analytics and monitoring purposes, I have also connected Power Pages with Application Insights.    I wrote a script that allows me to Resume/Suspend Power BI Embedded Capacity based on whether a user login Power Pages. The business logic is that if authenticated users>0, trigger capacity.   However, the problem that I am facing is that there's a high latency (2-5 min) for Application Insights to receive the information from Power Pages which means that Power BI Embedded Capacity is starting 2 minutes after the user authenticated himself.    Do you know a way to tackle that? Is there something like an app that I can set up in between in order to minimize latency?  Maybe Event Hub or something similar? Interested in hearing alternatives as well, thanks   Thanks ... View more

Apologises I will be unable to upload the dashboard contents due to GDPR, so I will explain my issue as far as I can.   The issue seems to be specifically to do with the Clear All Slicer button which was including in the March 2023 update of Power BI.   Use Case:   I have a dashboard with four filters:   Date: Between slicer defaulted to todays date License: Single select dropdown Country: multi-select dropdown Frequency: multi-select dropdown   When all four of these have been changed and the Clear All Slicers filter is clicked, as expected, all values return to their default, this is of course with the exception of the License Single select dropdown which remains as was previously selected.    Issue:   If was are to just change the License Single select filter, then navigate to a seperate sheet, and select the Clear All Slicers button. This License lifecycle filter returns to the default OnLoad value and doesn't retain it's previous selection.    As such the filter doesn't work as expected if the sheet is changed.   Let me know if you need any further clarification. ... View more

The new update changed to icons that are all grey line drawings and defaults to showing all content types together with no quick way to switch between datasets and reports/dashboards (it now requires more clicks than it did previously). Both of these changes would not be ideal on their own, but the combination of these makes it very difficult to see the differences at a glance, especially with a long list of items. I'm not sure what the intent was here, but it's made it a less user friendly experience. It would be great to at least have an option to default to not showing datasets, but the bigger help would be to have icons that can be distinguished at a glance.   Thanks! ... View more

Hi,   I´m connecting Azure Databricks to Power BI in Direct Query Mode and after refresh I´m receiving the following error with a lot of frequency:     I already cleared the permissions and refresh again, but it not solved. Also I recreated the navigation step in power query, but also did not solved.   Does any one knows how to solve it?   Thank you Ana ... View more

Good day,   When connecting to Azure Cost Management using oauth it works great but when the account expires updating the data source credentials does not allow you to choose oauth as an option, I have to delete the Data Mart every 30 days and recreate it for it to work.   ... View more

I am trying to connect to Azure Database for PostgresSQL. The server requires a secure connection. I have "Encrypted connection" set to Encrypted, but when I attempt to connect to copy data I receive: `28000: SSL connection is required. Please specify SSL options and retry. Check network connectivity setting of your Azure Postgre SQL flexible server, if Pirvate Access(VNet integration) is selected, please use SHIR to connect.`   In ADF, we're able to address this by setting additional parameters in the connection string. I do not see the ability to do that in Fabric. ... View more

With the debut of the new UX there seems to be some problem with the "Manage Connections and Gateways" experience's interaction with the users component. When you I view the Connections tab, the entire "Users" column is blank. When I go into "Manage Users" for a particular connection, the users list stays stuck on "Loading" and searching for known users returns no results, even if you provide the full user email address. This is true despite a fresh browser session in Edge or testing with an InPrivate window. Interestingly this is a problem only for the Gateways management UX, it's not a problem for Workspace Access for example.         This kind of issue seems to have happened before and the workaround was going to the old UX. It worked for me in a pinch today but hopefully this issue will be resolved quickly. Cannot access Manage users setting in Gateway - Microsoft Fabric Community   ... View more