usage reports arent refreshing according to the last 30/90 days. ... View more

i have already setup a personal mode and that is working fine but today i had setup the gateway in stander mode and it give me this error.. however, the sql server is up and im able to connect via remote from sql studio and even i can refresh powerbi file using the same sql connection however im not able to setup this for auto refresh pls guide.   server machise has 2022 R2 and sql 2014 and yes ports are open and using connection with correct port and allow remote connection is also enable from SQL database.     Unable to create connection for the following reason: SQL Server connection failed Details: ERP: 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: TCP Provider, error: 0 - The remote computer refused the network connection.) Please have this information handy if you choose to create a support ticket. ActivityId: 62f812e6-370b-4652-8b16-0f18d3efced1 RequestId: 0b2e946e-6100-40e1-a052-7d7f6b41e5b9 Cluster URI: https://api.powerbi.com Status code: 400 Time: Sat May 13 2023 03:26:13 GMT+0500 (Pakistan Standard Time)   ... View more

I Have a pretty simple PowerBI report that shows Q&A Visual and it's working fine in PowerBI Desktop. When I publish it to PowerBI Service (premium capacity), it shows 'We weren't able to load suggestions right now. Please try again later' error.  We have the Q&A feature preview enabled in both PBI Desktop and at the PBI Tenant level setting.    What is cauing the Q&A feature to not work when published to Premium Capacity workspace in Power BI Service, but it's working fine in Power BI Desktop?       ... View more

I downloaded the February 2023 (64 Bit) Power BI Desktop Cloud.  I'm missing the single value card visual icon. My other coworkers have it.  Why is missing from my version and how can I fix it?     ... View more

Hello team   i am having problems to sincronze some dataset (powerbi portal)  with my server (gateway connector)   the system send me this message : ------------------------------------------------------------------------------------------------------- Refresh failed: PBI_RODRIGO_FIGUEROA has failed to refresh. Failure details: 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_GatewayOverloadedConcurrency","pbi.error":{"code":"DM_GWPipeline_Gateway_GatewayOverloadedConcurrency","parameters":{},"details":[],"exceptionCulprit":1}}} Table: BI BI_CALENDARIO. Next refresh for PBI_RODRIGO_FIGUEROA is scheduled for May 12, 2023 17:00 UTC.   ------------------------------------------------------------------------------------------------------- Any know i can resolve this ?   ... View more

It would be nice to see the date and time the report was updated via publishing or onedrive refresh. Today the only time stamp shown is related to the dataset that has been published within the workspace. The ability to see last publish date of the report and last OneDrive update is a basic request that has been overlooked for too long.     ... View more

Publishing a power BI desktop file to power BI service, in an attempt to overwrite an existing dataset/report doesn't work whenever you might have switched on the toggle of OneDrive refresh.   Turning of the toggle doesn't solve the issue.   Reported issues, claimed to be resolved by the product team, continue to cause big issues: Cannot disable OneDrive refresh - Microsoft Power BI Community. This result in a status where it is impossible to adjust a dataset/report. (Even though Microsoft is pushing towards full parity of power BI desktop into the cloud, currently we can't fully work in the browser as not all functionality of power BI desktop has been added in the browser.)   The only unacceptable workaround appears to delete your dataset/report in the service and publish a new one.   Let me elaborate some of the consequences of deleting the dataset/report:   need to re-pin visuals to dashboards RLS/OLS needs to be reconfigured related reports/datasets are broken (hybrid reports, reports on the same datasets, etc.) all reports directly or indirectly related to this dataset that are pinned in Microsoft Teams are broken Deep Links (with filters in the URL) to every report related directly/indirectly to this dataset are broken all people's bookmarks to related reports/datasets are broken integrations of power BI reports in PowerApps are broken integration in Excel Custom data types are broken (featured tables) integration of power BI in Power Automate are broken, automation of processes thus are broken all external systems sending API requests to that dataset are broken metrics are broken report usage metrics are gone power BI comments are gone integration with Synapse Analytics is broken e-mail subscriptions on the reports are broken alerts on Card/Gauge visual are broken everything else I forgot about is broken!  Let it be very clear: the impact of deleting just a simple report/dataset can be huge. Huge work in fixing stuff, huge in disruption for the business with a many power BI users. Currently we're not updating our power BI reports and datasets, which also is impacting our business operations!   All power BI users are facing this issue and many are complaining about it: https://community.powerbi.com/t5/Service/Couldn-t-publish-to-power-BI-already-exists-and-is-set-up-w... https://community.powerbi.com/t5/Developer/Publish-of-update-fails-with-error-about-cloud-refresh/m-... https://community.powerbi.com/t5/Service/Cannot-quot-overwrite-quot-You-already-have-a-dataset-named... https://community.powerbi.com/t5/Developer/Publish-of-update-fails-with-error-about-cloud-refresh/m-...   The product team should fix this and have admins the possibility of disabling OneDrive refresh all together for the entire tenant. Simply moving one .pbix file in SharePoint (seeming unharmful) can trigger unrepairable/irreversible consequences.    I have raised a support ticket for this issue, but power BI support has been unable to solve this open ticket for more than 5 days.   Please vote, and raise awareness of this BUG. This must be fixed! ... View more

When I have a user that is assigned the permission "member" on a workspace, once I downgrade the workspace permissions to "viewer", the user still can access the report like a member, which disables all row-level security that is inplace. I tested this for multiple users and multiple workspaces. Also the user is not in agroup with different permission settings. Only solution so far is to open a new workspace and give them the "viewer" role initially.    Would really appreciate a Bugfix regarding this topic. ... View more

I had issues with my previous PowerBI Desktop Installation (not closing down properly, and suddenly not opening up PBIX files that I had previously been able to open & edit).   I uninstalled it.   I rebooted the PC.   I downloaded the lastest x64 Desktop install from Microsoft website.   I installed it.   On startup it gives me the following error report (There was an error deserializing the object of type Microsoft.Data.Mashup.Preview.DownloadManifestResult+JsonRemoteExtensionInfoArray. Encountered unexpected character '<'.).   I have rebooted the laptop but still get the new error report.  The full error message from the clipboard is below.   Any help appreciated!   Feedback Type: Frown (Error) Error Message: There was an error deserializing the object of type Microsoft.Data.Mashup.Preview.DownloadManifestResult+JsonRemoteExtensionInfoArray. Encountered unexpected character '<'. Stack Trace: System.Runtime.Serialization.SerializationException at System.Runtime.Serialization.XmlObjectSerializer.ReadObjectHandleExceptions(XmlReaderDelegator reader, Boolean verifyObjectName, DataContractResolver dataContractResolver) at System.Runtime.Serialization.Json.DataContractJsonSerializer.ReadObject(XmlDictionaryReader reader) at Microsoft.Data.Mashup.Preview.DownloadManifestResult.FromDownloadResponse(Stream manifest, Version targetEngineVersion, IHostTrace trace) at Microsoft.Data.Mashup.Preview.MashupExtensionsServiceClient.GetRemoteExtensionManifest(String remoteExtensionUrl, MashupExtensionsServiceState state, MashupExtensionsServiceClientCancellationToken cancelled, IEvaluationConstants evaluationConstants) at Microsoft.Data.Mashup.Preview.MashupExtensionsServiceLibraryProvider.FetchRemoteExtensionManifest(MashupExtensionsServiceState serviceState) at Microsoft.Data.Mashup.Preview.MashupExtensionsServiceLibraryProvider.<>c__DisplayClass45_0.<ConfigureManifestPolling>b__1() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) Stack Trace Message: There was an error deserializing the object of type Microsoft.Data.Mashup.Preview.DownloadManifestResult+JsonRemoteExtensionInfoArray. Encountered unexpected character '<'. 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.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_0.<SendAndMarshalExceptions>b__0(Object null) 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.Delegate.DynamicInvokeImpl(Object[] args) at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbacks() at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) 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) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.116.966.0","ModuleName":"Microsoft.Data.Mashup.Preview.dll","Component":"Microsoft.Data.Mashup.Preview.DownloadManifestResult","Error":"System.Runtime.Serialization.SerializationException","MethodDef":"FromDownloadResponse","ErrorOffset":"0"} InnerException0.Stack Trace Message: Encountered unexpected character '<'. InnerException0.Stack Trace: at System.Xml.XmlExceptionHelper.ThrowXmlException(XmlDictionaryReader reader, XmlException exception) at System.Runtime.Serialization.Json.XmlJsonReader.Read() at System.Xml.XmlBaseReader.IsStartElement() at System.Xml.XmlBaseReader.IsStartElement(XmlDictionaryString localName, XmlDictionaryString namespaceUri) at System.Runtime.Serialization.Json.DataContractJsonSerializer.InternalIsStartObject(XmlReaderDelegator reader) at System.Runtime.Serialization.Json.DataContractJsonSerializer.InternalReadObject(XmlReaderDelegator xmlReader, Boolean verifyObjectName) at System.Runtime.Serialization.XmlObjectSerializer.ReadObjectHandleExceptions(XmlReaderDelegator reader, Boolean verifyObjectName, DataContractResolver dataContractResolver) InnerException0.Invocation Stack Trace: at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace() at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix) at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth) at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e) at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail) 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.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_0.<SendAndMarshalExceptions>b__0(Object null) 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.Delegate.DynamicInvokeImpl(Object[] args) at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbacks() at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) 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) Snapshot Trace Logs: C:\Users\BenbowS\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot9d55e30d-c7d7-4b96-ba5b-bdaa86a2f39a.zip Model Default Mode: Empty Model Version: PowerBI_V1 Performance Trace Logs: C:\Users\BenbowS\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip 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 PowerBIUserFeedbackServices_IsReported: True Formulas: section Section1; ... View more

Hello all I had a report that was up and running without any issues for few months now and today had an error saying this native database query isn't currently supported.  Report was not changed at all, any ideas why this happened?  Many thanks Dmitrij  ... View more

In Version 1022 of Power BI Premium Capacity Utilization and Metrics App the Multi Metric Column Chart from Overview is no longer available.   Can you please bring back the Multi Metric Column Chart (per Power BI items, not by Power BI items kind) in Overview Tab? Ribbon Chart via Item Kind is not useful at all:(   Regards, Karo ... View more

I use Apache POI to generate xlsx files. Recently I upgraded from Apache POI 4 to Apache POI 5 and my excel files started failing their upload to my workspace (https://app.powerbi.com/).   My investigation led me to generate roughly the same content using Apache POI 4 and Apache POI 5 and narrowed down the issue to the applyAlignment="true" attribute in the excel file's "xl/styles.xml" file. This attribute was added to Apache POI 5 as a bug fix (https://bz.apache.org/bugzilla/show_bug.cgi?id=64494) and seems to be causing an error when uploading to my Power BI workspace.   I removed all instances of the attribute from the styles.xml file, and I was able to successfully upload the file to my Power BI workspace.   Interestingly, the same xlsx file can be opened just fine in other Microsoft products, such as Excel. ... View more

Most of our datasets are failing with the error DM_GWPipeline_Gateway_TimeoutError   Here are some detailed logs of one of the failures Data source error: {"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_TimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: XXXXX. Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net Activity ID: 102863cf-9705-4230-8356-90c55b612706 Request ID: 5b83fab5-5fd3-496f-abc3-d3214466f572 Time: 2023-05-11 15:01:26Z ... View more

Hi all, Having an issue with granting an external user access to a workspace.   I've set up the user in Azure AD as a Guest. I've enabled "Allow Azure Active Directory guest users to edit and manage content" via the Power BI Admin Portal. I've sent an invite to the guest user.   We have Power BI Pro license.  External users also has Power BI Pro license.   When I try to add the guest user as a member or contributor to the workspace, I'm getting the following error:     Any thoughts on why I'm not able to add the guest external user to the workspace?   Do they need to accept the invite first?  Is there a way I can accept the invite for them or confirm them another way? ... View more

Hi Team, Please find the screenshot of the error and not able to clone the dashboard. Please suggest ... View more

BUG - Published paginated report from Report Builder not showing all selectable options in the parameter drop down, in this case, for the date period parameter. However, all options are available in the dataset, and also if run directly from Report Builder. ... View more

Hi For all the power BI publishing showing below error, Even to a small excel data. Please help unable to write data to the transport connection: an existing connection was forcibly closed while publishing power bi ... View more

I had publsihed a P&L report which had 14 dax in it and 3 copmany_id, Account Group , Account Dept column. Report work fine in desktop but when published in Service it crashes and give this error.I am using PPU account. I had tried dax optimization and using group by to group data bud nothing worksin my case. Is there any way to fix it? This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed. Please try again later or contact support. If you contact support, please provide these details.   More detailsThe XML for Analysis request timed out before it was completed. Timeout value: 225 sec. Activity IDd8c87ca1-336c-447b-b551-5c5f3519325b Correlation ID80a5c825-9b0f-8f55-4cb6-2b6468095fd8 Request ID69ec3545-fbab-4808-9f00-03a980e83e35 TimeThu May 11 2023 11:45:19 GMT+0500 (Pakistan Standard Time) Service version13.0.20626.62 Client version2305.1.13619-train Cluster URIhttps://wabi-west-europe-d-primary-redirect.analysis.windows.net/   ... View more