Hello, I tried to load Oracle/MS SQL data through on-premise gateway in Dataflow Gen. 2.. I see tables, load table in editor, see columns, data. Then I wanted to set destination to Lakehouse and always receive this error message:   An exception occurred: The given data source kind is not supported. Data source kind: Lakehouse.    I tried csv file from SHP - and this was ok, I was able to load data to Lakhouse. I know - MS Fabric is in preview - but I can not find that this feature (Oracle/MS SQL on-premise) is not yet supported.    Thanks. ... 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

Unable to refresh data in the datamart, following error.   We couldn't get your datamart's updated schema The datamart data is invalid Activity ID: f817febf-3293-4b66-a64d-0ac1c9987419 Request ID: b247eba4-d0b6-440d-8000-e8d6fe3d6459 Correlation ID: 0fefd113-83ba-4f76-c8d0-6d4464a511b2 Status code: 400 Time: Mon May 22 2023 23:16:52 GMT+0100 (British Summer Time) Service version: 13.0.20726.71 Client version: 2305.3.13975-train Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/ ... View more

Created a Power BI Dataflow with the connection to other existing Power BI data flow using "Dataflow" connector, worked in the editing, but failed in refreshing once saved it.     Switched the connector from "Dataflow" to "Power BI Dataflow (Legacy)" and worked.   Dataflow connector has the issue with connecting to other Power BI dataflow when refreshing data. The refresh error message was   "Error: Data Source Error : DataSource.Error: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider error: 40 - Could not open a connection to SQL Server) DataSourceKind = <ccon>PowerPlatformDataflows</ccon> DataSourcePath = <ccon>PowerPlatformDataflows</ccon> Message = <ccon>A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections". ... View more

Starting around 4/21, users across multiple tenants started see a blank white pane when trying to choose a Power BI Dataset in Excel.   ... View more

Hello,   When creating a new or changing a current working dataflow with a Exasol certified connector. The refresh fails with "Expression.Error: The import Exasol.Database matches no exports. Did you miss a module reference?". It does work in the designer mode.   This is preventing us from maintenance and new development using our datawarehouse. Please give us advice on solving this problem.    Kind Regards, Cees van Leuveren       Requested on,Dataflow name,Dataflow refresh status,Table name,Partition name,Refresh status,Start time,End time,Duration,Rows processed,Bytes processed (KB),Max commit (KB),Processor Time,Wait time,Compute engine,Error, 2023-05-16 10:04:49,test,Failed,VD_CALENDAR,NA,Failed,2023-05-16 10:04:49,2023-05-16 10:04:50,00:00:00.3770,NA,NA,NA,NA,NA,NA,Error: Expression.Error: The import Exasol.Database matches no exports. Did you miss a module reference? . RootActivityId = 291a1fbe-19fa-4694-bb31-dd4c00b6ddc4.Param1 = Expression.Error: The import Exasol.Database matches no exports. Did you miss a module reference? Request ID: c85810c6-b3f6-90c9-7a5c-ae4778ff3afd.         ... View more

In the latest version (Version: 2.114.664.0 64-bit (February 2023)), all display boxes in PBI desktop aren't displaying correctly. Is this happening to other users? I can find an area to post to Microsoft. Some examples attached.   ... View more

Hallow everyone,   after updating Power BI desktop from version 2.114 (Feb 2023 Release) to the March 2023 version, the app crashed immediately on startup giving an error that an external component has thrown an exception. the application is installed on a windows server 2012 R2, some error details are below. I thought I would roll back to Dec. 2022 version to see if it works, I unfortunatlly don't have the 2.114 setup file anymore.   Please help.   Feedback Type: Frown (Error) Timestamp: 2023-03-15T08:47:28.9016104Z Local Time: 2023-03-15T11:47:28.9016104+03:00 Session ID: 7cfb7f39-7cf7-44db-8be6-d6e192c4b1e2 Release: March 2023 Product Version: 2.115.663.0 (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__DisplayClass5_3.<<RunApplication>b__12>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.115.663.0","ModuleName":"Microsoft.Mashup.Client.UI.dll","Component":"Microsoft.Mashup.Client.UI.Windows.DialogWindowBase","Error":"System.Runtime.InteropServices.SEHException","MethodDef":"ShowModal","ErrorOffset":"17"} OS Version: Microsoft Windows NT 6.3.9600.0 (x64 en-US) CLR Version: 4.8 or later [Release Number = 528049] Peak Virtual Memory: 1.58 GB Private Memory: 519 MB Peak Working Set: 687 MB IE Version: 11.0.9600.20874 User ID: 4259c6c6-f912-426e-8a86-b621577bd7f5 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_fieldParametersSuperSwitch PBI_horizontalFusion PBI_relationshipEditPane PBI_setLabelOnExportPdf Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_azureMapVisual PBI_compositeModelsOverAS PBI_b2bExternalDatasetSharing PBI_enhancedTooltips PBI_NlToDax PBI_optimizeTabRibbon PBI_angularRls PBI_onObject Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BI ... View more

Since updating to this month's new Power BI Desktop release, the UI appears to be using my secondary display's DPI scaling upon launching a pbix file. The UI is blurry and zoomed in until I resize the window. Additionally, I'm unable to see the full dialog window of Get Data. It's zoomed in and I can't resize to see the OK and Cancel buttons. The only fix for that I've seen is to move Power BI Desktop to my secondary display temporarily. ... View more

Look like Issue with Power BI April 2023 version : No longer able to see the name of the file at the top of the desktop app as shown below. When I hover, it just displays "undefined".     ... View more

I've been trying to incorporate LINESTX into my reporting but keep running into errors when modifying the filter context.   To create a minimal reproducible example, I've loaded a data table like this: and defined a measure as follows:   LINEST_Intercept = VAR Summary = ADDCOLUMNS ( VALUES ( Data[ID] ), "@Y", CALCULATE ( SUM ( Data[Y] ) ), "@X1", CALCULATE ( SUM ( Data[X1] ) ), "@X2", CALCULATE ( SUM ( Data[X2] ) ) ) VAR Coeffs = LINESTX ( Summary, [@Y], [@X1], [@X2] ) VAR Intercept = SELECTCOLUMNS ( Coeffs, "Intercept", [Intercept] ) RETURN Intercept   This works fine initially in a matrix like this: However, if I add a slicer on ID and make any selection other than the full range, I get an error on the entire visual.   Error Message: MdxScript(Model) (4, 1) Calculation error in measure 'Data'[LINEST_Intercept]: A table of multiple values was supplied where a single value was expected.   If I try using MAXX instead of SELECTCOLUMNS inside my measure   VAR Intercept = MAXX ( Coeffs, [Intercept] )   and filter the ID, I either get "An unexpected exception occurred" or weird results with a blank Group like this:   None of this weirdness happens if I use a different function that returns a single row like TOPN ( 1, ... ).   Please see the attached sample file.   Tagging a few people for awareness. Please ignore if you aren't interested. @jeroenterheerdt, @marcorusso, @Greg_Deckler, @ValtteriN, @CNENFRNL, @tamerj1, @wdx223_Daniel, @smpa01  ... View more

Hello,   With August'22 version I have an issue when I try to apply changes or discard them.   Seems not working neither:           ... View more

Ever since about 6am Eastern today, my dataset refreshes have been failing and the reports are just spinning - no errors, just spinning like it's trying to load the data. ... View more

Hi All, I am getting bellow error while trying to apply the Score Sentiment using AI Text Analytics:   DataSource.Error: An error happened while reading data from the provider: 'An internal error occurred.' Details: DataSourceKind=AIFunctions DataSourcePath=AIFunctions   Other two text analytics functions( Detect Language & Extract Key Phrases) works fine. Issue is only with Score Sentiment. I am using Power BI  Oct 2022 version.   Any idea how to fix this issue?  Appreciate your help!!   Thank you! Shephali   ... View more

Hi Everyone, I recently signed into my Power BI workpace, and all of my dataflows that were created are now gone. Wondering if there are any known issues right now with Dataflows disappearing. Looking for any help here.   Thanks,   Wesley ... View more

I am stuck at this point when I click on the Refresh button. Looks like there is a problem in September 2021 update, I've downgraded to August and it's working fine.   ... View more

I have a data sort which requires me to apply a couple different filters in the data view. When I open the report I select the first column and apply a filter on my table in data view.   Whenever I select the filter button on the next column it automatically is hoping back to the last column I selected not pulling up the filter dropdown on the new column. This is a new issue as of last night and I can not seem to select any column for filtering other than the first one I click on when entering the data view.   I have tried uninstalling and reinstalling powerBI but no luck ... View more

When trying to connect to Databricks I keep getting the error "Value cannot be null.  Parameter name:  s".  All the connection info is correct.  Also after I make the first attempt and get this error I am unable to try again, the OK button is grayed out.  I have to click Cancel and start the Get Data process all over again.  I should also mention that I think this is a bug in the April Desktop update because several coworkers have March 2023 version.  When they copy my steps and input they do not get the error and they can make changes and still be able to press OK again to retry. Thank you! ... View more

As subject said, I cannot scroll all the way to the bottom on the Data panel, I installed the latest version of Power Bi Desktop via Microsoft Store. My colleague who has same version installed doesn't have the same issue. Is it my PC setting or something? Please kindly help, I cannot see all the data table.     ... View more