Issues - Page 115

Peter_Novak · ‎03-15-2023

Every day failing the datamart refreshing, it ends with error message: datamart_error_msg it is the same for schedulled refreshing and for manual refresh. Additional error messages what I often get: Datamart_error Usually when I try to refresh the dataset from the Datamart with automate refreshing in the reporting tab. When I try to make change or just open and save the query in the Datamart.

Anonymous · ‎03-15-2023

I need to make a report that looks like this where i can drill down on the segments but all the base/above base should be visible all the time

AndreaLorenzo · ‎03-15-2023

When I add a PBI report page with some visuals that have top N filters - working properly in Deskotp and Report Server- into PowerPoint, the filter is lost and all data is shown, not just the top N.

Saad_ghraybeh · ‎03-15-2023

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

bjkoning-bince · ‎03-15-2023

Hi, The updated UI experience prevents me from testing row level security (RLS) on reports in the same workspace other than the "dataset report". The old UI experience allowed me to select a different report (dropdown in left menubar) residing in the same workspace as the dataset when testing as a different user. My colleagues and our customers use this feature to check for any rights issues, or data privacy concerns. Best, Bart

TransDig · ‎03-15-2023

Hi guys After a couple of days the refresh of the dashboards embeded in our web page is not working. The tiles of that dashboards are from a report directly connected to a push dataset filled by azure stream analytics. This method was working well some years but recently the refresh of the dashboards is not working anymore. I tried to use one of the samples code provided in Embed content in your Power BI embedded analytics application - Power BI | Microsoft Learn page to test a scenario outside our angular application but we have still the same problem. Its a very strange error in embeded because the dashboard in Power BI Service works perfectly. One thing that i discover in my test is the real time tiles from the dashbord connectet directly to the push dataset working well in the embeded, but all the tiles coming from the report dont. This gif is from the embeded test. Here we can see how the two tiles of the top are working well but the table doesn't refresh the data. This is because the table come from the report and the tiles are connected directly to the data set. This gif is from the power bi service, in this case, we can see how all the tiles are refreseh properly when new events are pushed to the dataset. Any ideas why this error is happening since a few days ago? Thanks for the help.

awarriorpoet · ‎03-14-2023

I have a dataset with addresses that include city/state/country. on my report I am using the Map Visualization using the City and State field. For my Puerto Rico addresses (State = PR) it is showing up in Paraguay. Bing maps resolves PR correctly.

GregMarbais · ‎03-14-2023

When adding or removing users from RLS, I'm getting an error in the service. I've had this dataset up for a while and have existing users assigned to the roles but for the last couple weeks, I'm getting errors. Here's the error: Activity ID: a3dfac75-15ee-454a-aba6-373c306b20db Request ID: d448c3e5-aecc-b43c-a9ab-7fde13f66ca5 Correlation ID: c0cae358-4c01-7413-2298-e34848689e13 Status code: 500 Time: Tue Mar 14 2023 18:40:45 GMT-0400 (Eastern Daylight Time) Service version: 13.0.20295.56 Client version: 2303.2.12867-train Cluster URI: https://wabi-us-north-central-h-primary-redirect.analysis.windows.net/

michaelgutman · ‎03-14-2023

We had this functionality in SSRS and need to be able to export a subscription as HTML in email. Right now there is a workaround but it doesn't work for an entire page for html. Please add this!

ftowner · ‎03-14-2023

We were using Segio UI on buttons and the text automatically wrapped - it now longer wraps.

naranha · ‎03-14-2023

Hi, I've created Project Plans for a number of Projects in Project Online and I want to connect the plans to Power BI so I can generate data reports and visualizations. Appreciate the support in advance

v-cmace · ‎03-14-2023

Hello, My Power BI - Integrated Insights is not populating and my CPU fan is running pretty fast and constant. I have tried restarting and even a shut down with no impact to Power BI. See the two screenshots below. I only have the Power BI Integrated Insight open in Edge, Teams, Outlook and Excel and this is what is going on. No updates are pending for Windows. Thanks, Chris v-cmace@microsoft.com 304-263-7535 (O)

dscott73 · ‎03-14-2023

I deleted a column in the report designer from a table. I open up the source SQL view, and removed the column. Now, when I go to refresh the report, I get an error about the column no longer existing and the report fails to load.

nsdonosol · ‎03-14-2023

Buen dia @Soporte @SoporteBI desde que cambie de pc me esta saliendo el siguiente mensaje; ya cambia las opciones de autorrecuperacion y configure los permisos de origen de datos ; aun asi sigue el problema.

Anonymous · ‎03-14-2023

The Power BI doesn't have a orthogonal line for maps or images and would be a very important feature to add in the SW, I would give some examples, the energy company that I work need to implant some telecommunication's trasmission tower over the country, but also need to evaluate the travel of the signal from one point to another, how can I filter which types of signals are beign received in that point? Or another example, air companies, they need to filter which lines are in the air and their destination, in that case is also need a orthogonal line for euclidean algebra, because to go to one point for another one, you can't go in a straight line because the planet isn't flat! The same occurs with the telecommunication issue above (with less impact, but still does). My idea is to implant orthogonal line with and without euclidean algebra for maps, images and others visuals of Power BI. That would helps many sections of bussiness, industry, public government, travels and many more areas or jobs.

ykoh · ‎03-14-2023

Hello, I recently had an issue in one of my model and it just gave me the error "OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005)" After removing all part of the querry I was still having the same error. I checked the log from the published report and the error on the previous refresh and it gave me : The following system error occurred: Type mismatch. Unable to convert a value to the data type requested for table 'RequestForm' column 'Length'. The data provider was unable to convert the value '' from the source data type 'VT_BSTR' to the expected data type 'VT_CY'. Please check the column data types in the data model and data source and ensure that the data types are compatible. Where I could find on which column the error was 'Length' in that case. (it was giving me that it was expecting a 'VT_CY' so a currency column which is not correct but fine) An idea would be, if possible, to update the error given in PowerBI desktop to point to which column has the Type mismatch to better allow us to debug error (in my case an user typed "3 days" in a column that is usually hidden and that should be only numbers... But I had that column as text since I was just using it for PowerAutomate to calculate the length of a travel and displaying it on the SP List directly.

Aaron_Coughlan · ‎03-14-2023

Hiya, "Unable to update this data source's credentials. Invalid connection credentials." Running in this error when trying to use the Windows Authentication Method for my own account, which has access to the relavent SharePoint site as an owner. UserName and Password are correct, yet the issue persists. Workaround is the manually refresh the related dataset and publish, but not ideal when I'm trying to automate! Thanks.

mwroblewski · ‎03-14-2023

Hi all, I've been struggling for some time with changing live connect to direct query for my dataset. So far I made sure, that "Allow XMLA Endpoints and Analyze in Excel with on-premises datasets" and "Users can work with Power BI datasets in Excel using a live connection" is enabled. Also checked to meet these limitations. Once I want to swtich to directquery to my dataset, I'm getting: Here is part of error, which I find meaning full: PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.112.1161.0","ModuleName":"Microsoft.PowerBI.AdomdClient.dll","Component":"Microsoft.AnalysisServices.AdomdClient.Authentication.PbiPremiumAuthenticationHandle","Error":"Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException","MethodDef":"TryResolveWorkspaceWithWorkspaceResolver","ErrorOffset":"121"} InnerException0.Stack Trace Message: The remote server returned an error: (403) Forbidden.

chrisbaker · ‎03-14-2023

I'm using a Gantt chart to track ownership of assets. All of the below have the same commencement date, and a few months different in end date. As you can see, the start points of the bars are not rendering consistently and some are defaulting to sharp instead of rounded corners. This appears to be a visual bug.

Anonymous · ‎03-14-2023

Hi, When I try to use a field (table imported from Sharepoint) and use it as a column in a table visual, I get this error message and the table visual doesn't load. I found that I get this error for some pages and not for others (all pages have table visuals, but not the same filters) within the same report file. The last time this was mentioned on this forum it was said that the November 2022 update resolved this issue. Can I have some help to resolve this? My current workaround is removing some fields, but this is not sustainable in the longrun as I will eventually need the information from these fields. I am using the February 2023 version of PowerBI. TIA!

Share your ideas and vote for future features

Datamart(preview) refreshing failing

Don't know how to make a table like this

Top N filter lost when adding a PBI report page to PowerPoint

Power BI Desktop crash - March 2023 Release version 2.115.663.0 (x86)

New UI experience disables option to test RLS on workspace reports

Issue with the RealTime Refresh In embeded scenario

Map doesn't resolve PR as Puerto Rico

Cannot Add to Row Level Security

Need Paginated Report Subscriptions to export as HTML

Using certain fonts in Button text does not format

Connect Power BI to Project Online Project Plans

Power BI - Integrated Insights - Portfolio is not populating

Deleting column in designer, then removing from SQL view causes error.

recuperación automática

Orthogonal Lines for Maps and VIsuals in Power BI

Giving more context for error such as OLE DB or ODBC error: Type mismatch. (Exception from HRESULT:

Power BI GateWay for SharePoint - The credentials provided for the SharePoint source are invalid.

dataset directquery request failed - 403 forbidden

Gantt Chart 2.2.3 visual bug

An unexpected error occured (file'pfoledbreader.cpp', line 836, function 'PFDBReaderOledb::Bind').

Helpful resources

Power BI Crashes When Using Quick Measure

PowerBI Service - filter by keyword doens't bring ...

Microsoft Fabric Trial Issue

"Telemetry Initialization Error" - Cant Open Power...

Manage access within the workspace