Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Share your ideas and vote for future features

Suggest an idea
0 Votes
Vote
pulatonano

Access Azure TABLE Storage directly with Power BI Premium site

Submitted on ‎03-03-2022 06:31 AM Submitted by on ‎03-03-2022 06:31 AM
Let me state up front that I am at best Power BI novice.  I have a very large quantity of data being concentrated from 14 locations across the USA in an Azure Table storage for Machine Learning purposes.  The data is made available to each location for internal use at the individual facility using a Power BI report that pulls data from Azure Table Storage.  Power Bi Report is setup to do incremental refreshes on a daily basis for 60 days.  Incremental refresh settings   Common issues are that the connection is "Forcibly Closed".  On very large facility see this issue more than others and it recently failed and now the incremental refresh can no longer get caught up without the connection timming out.  Meaning-- it does not seem to be recoverable--unless I pull I can publish Power Bi Report in a nearly compete state -- it times out before I can get the 60 days downloaded. I have tried building a Data Flow that pulls all the data into one Data Flow and build reports agains this--however it too often fails the refresh and when it dose succeed the refresh interval is 6 -10 hours.  I could live with the long refresh if it were consistent and did not fail over 50% of the time.   It seems that since the data is already in Azure, my Premium Power Bi sites are in Azure:      1.  This refresh should not take so long?        2.  Do I reall need to keep replicating the same data in multiple locations within the Azure environment?           Note: Flat Table storage is used for cost savings --we are currently pulling in over 1 TB per year for just this one project. ... View more
Status: Accepted

When the refresh failed, it there any error information about it or has no information but always under refresh, you can try to find it in refresh history.

 

Currently about dataflow refresh, both refresh failed and refresh for a long time , many similar issues have been submited as far as I know(ICM: 292208833, 288091663), if there is any progress about it, would update here as soon as possible

 

In addition, here is the similar thread that you can refer: Dataflows not refreshing today 

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
2 Comments (2 New)
0 Votes
Vote

No handler was found for message type 'Microsoft.Mashup..Evaluator.MessageBasedOutputStream+BinaryCh

Submitted on ‎03-02-2022 08:09 AM Submitted by Anonymous on ‎03-02-2022 08:09 AM
Feedback Type: Frown (Error) Error Message: No handler was found for message type 'Microsoft.Mashup.Evaluator.MessageBasedOutputStream+BinaryChunkMessage'. Stack Trace: Microsoft.Mashup.Host.Document.SerializedException at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.TranslateCancelExceptions(Action action) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.IgnoreCancelExceptions(Action action) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Finish() at Microsoft.Mashup.Evaluator.Interface.IDataReaderSourceExtensions.<>c__DisplayClass1_0.<AfterDispose>b__0() at Microsoft.Mashup.Evaluator.Interface.NotifyingDataReaderSource.Dispose() at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.Dispose[T](EvaluationResult2`1 result) at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.<>c__DisplayClass10_0.<Complete>b__0() at Microsoft.Mashup.Evaluator.Interface.NotifyingDataReaderSource.Dispose() at Microsoft.Mashup.Evaluator.Interface.NotifyingDataReaderSource.Dispose() at Microsoft.Mashup.Evaluator.DocumentEvaluator.<>c__DisplayClass7_1`1.<BeginGetResult>b__1() at Microsoft.Mashup.Evaluator.Interface.NotifyingDataReaderSource.Dispose() at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.Dispose[T](EvaluationResult2`1 result) at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.<>c__DisplayClass10_0.<Complete>b__0() at Microsoft.Mashup.Evaluator.Interface.NotifyingDataReaderSource.Dispose() at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.Dispose[T](EvaluationResult2`1 result) at Microsoft.Mashup.OleDbProvider.DataHost.MashupEvaluator.<>c__DisplayClass4_1.<Evaluate>b__1() at Microsoft.Mashup.Evaluator.Interface.NotifyingDataReaderSource.Dispose() at Microsoft.Mashup.Engine.Interface.Tracing.TracingDataReaderSource.Dispose() at Microsoft.Mashup.Evaluator.Interface.IDataReaderSourceExtensions.<>c__DisplayClass1_0.<AfterDispose>b__0() at Microsoft.Mashup.Evaluator.Interface.NotifyingDataReaderSource.Dispose() at Microsoft.Mashup.OleDbProvider.MashupCommandEvaluation.Dispose() at Microsoft.Mashup.OleDbProvider.TracingMultipleResults.Dispose() Stack Trace Message: No handler was found for message type 'Microsoft.Mashup.Evaluator.MessageBasedOutputStream+BinaryChunkMessage'. 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__DisplayClass15_0.<HandleException>b__0() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_1.<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.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle) at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.TryShowDialog(Report report, IExceptionHandler exceptionHandler, IPowerBIWindowService windowService, IQueryServices queryServices, IDesktopModelingHost modelingHost, LocalizedString title, LoadToModelContext loadToModelContext) at Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.<>c__DisplayClass16_0.<TryShowDialogForQueries>b__0() at Microsoft.PowerBI.Client.Windows.Report.<>c__DisplayClass64_0`1.<SynchronizeLooselyWithQueries>b__0() at Microsoft.PowerBI.Client.Windows.Report.<SynchronizeLooselyWithQueriesAsync>d__65`1.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.Client.Windows.Report.SynchronizeLooselyWithQueriesAsync[T](Func`1 getTask) at Microsoft.PowerBI.Client.Windows.Report.SynchronizeLooselyWithQueries[T](Func`1 action) at Microsoft.PowerBI.Client.Windows.Commands.ApplicationCommands.DataImportCommands.RefreshAllQueries(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, RefreshAllQueriesParameters parameters) at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.Practices.Prism.Commands.DelegateCommandBase.<>c__DisplayClass4_0.<.ctor>b__0(Object arg) at Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(ICommand command, Object parameter) at Microsoft.Practices.Prism.Commands.CompositeCommand.Execute(Object parameter) at Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(T parameter) at Microsoft.PowerBI.Client.Windows.CommandStoreHostService.<>c__DisplayClass13_0.<Execute>b__0() at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass7_0.<ExecuteOnUIThreadAsync>b__0(Object t) 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__DisplayClass4_0.<Main>b__1() 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.Main(String[] args) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.98.882.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.MessageHandlers","Error":"Microsoft.Mashup.Host.Document.SerializedException - System.InvalidOperationException","MethodDef":"Dispatch","ErrorOffset":""} Snapshot Trace Logs: C:\Users\dgravel\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot36d33d2a-aaed-4ffb-a05e-b7c751b392ba.zip Model Default Mode: Import Model Version: PowerBI_V3 Performance Trace Logs: C:\Users\dgravel\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip Enabled Preview Features: PBI_rdlNativeVisual Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_azureMapVisual PBI_dataPointLassoSelect PBI_compositeModelsOverAS PBI_dynamicParameters PBI_enhancedTooltips PBI_enableWebView2 Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud PowerBINonFatalError_ErrorDescription: System.InvalidOperationException PowerBIUserFeedbackServices_IsReported: True Formulas: section Section1; shared #"TP Active" = let Source = SharePoint.Contents("https://my.metlife.com/teams/SAFeCoP/"), Documents = Source{[Name="Documents"]}[Content], PowerBi_Data_Input = Documents{[Name="PowerBi_Data_Input"]}[Content], #"GI_Analytics_MockUp xlsx" = PowerBi_Data_Input{[Name="GI_Analytics_MockUp.xlsx"]}[Content], #"Imported Excel Workbook" = Excel.Workbook(#"GI_Analytics_MockUp xlsx"), TPActive_Sheet = #"Imported Excel Workbook"{[Item="TPActive",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(TPActive_Sheet, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Days", Int64.Type}}) in #"Changed Type"; shared #"TP Automation" = let Source = SharePoint.Contents("https://my.metlife.com/teams/SAFeCoP/"), Documents = Source{[Name="Documents"]}[Content], PowerBi_Data_Input = Documents{[Name="PowerBi_Data_Input"]}[Content], #"GI_Analytics_MockUp xlsx" = PowerBi_Data_Input{[Name="GI_Analytics_MockUp.xlsx"]}[Content], #"Imported Excel Workbook" = Excel.Workbook(#"GI_Analytics_MockUp xlsx"), TPAutomation_Sheet = #"Imported Excel Workbook"{[Item="TPAutomation",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(TPAutomation_Sheet, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Potential Time Savings", Int64.Type}}) in #"Changed Type"; shared #"TP Financials" = let Source = SharePoint.Contents("https://my.metlife.com/teams/SAFeCoP/"), Documents = Source{[Name="Documents"]}[Content], PowerBi_Data_Input = Documents{[Name="PowerBi_Data_Input"]}[Content], #"GI_Analytics_MockUp xlsx" = PowerBi_Data_Input{[Name="GI_Analytics_MockUp.xlsx"]}[Content], #"Imported Excel Workbook" = Excel.Workbook(#"GI_Analytics_MockUp xlsx"), TPFinancials_Sheet = #"Imported Excel Workbook"{[Item="TPFinancials",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(TPFinancials_Sheet, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"YTD", Int64.Type}, {"FY", Int64.Type}}) in #"Changed Type"; shared PatchingServers = let Source = SharePoint.Contents("https://my.metlife.com/teams/SAFeCoP/"), Documents = Source{[Name="Documents"]}[Content], PowerBi_Data_Input = Documents{[Name="PowerBi_Data_Input"]}[Content], #"GI_Analytics_MockUp xlsx" = PowerBi_Data_Input{[Name="GI_Analytics_MockUp.xlsx"]}[Content], #"Imported Excel Workbook" = Excel.Workbook(#"GI_Analytics_MockUp xlsx"), PatchingServers_Sheet = #"Imported Excel Workbook"{[Item="PatchingServers",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(PatchingServers_Sheet, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Prior", Percentage.Type}, {"Current", Percentage.Type}}) in #"Changed Type"; shared PatchingWKSTNS = let Source = SharePoint.Contents("https://my.metlife.com/teams/SAFeCoP/"), Documents = Source{[Name="Documents"]}[Content], PowerBi_Data_Input = Documents{[Name="PowerBi_Data_Input"]}[Content], #"GI_Analytics_MockUp xlsx" = PowerBi_Data_Input{[Name="GI_Analytics_MockUp.xlsx"]}[Content], #"Imported Excel Workbook" = Excel.Workbook(#"GI_Analytics_MockUp xlsx"), PatchingWKSTNS_Sheet = #"Imported Excel Workbook"{[Item="PatchingWKSTNS",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(PatchingWKSTNS_Sheet, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Prior", Percentage.Type}, {"Current", Percentage.Type}}) in #"Changed Type"; shared Availability = let Source = SharePoint.Contents("https://my.metlife.com/teams/SAFeCoP/"), Documents = Source{[Name="Documents"]}[Content], PowerBi_Data_Input = Documents{[Name="PowerBi_Data_Input"]}[Content], #"GI_Analytics_MockUp xlsx" = PowerBi_Data_Input{[Name="GI_Analytics_MockUp.xlsx"]}[Content], #"Imported Excel Workbook" = Excel.Workbook(#"GI_Analytics_MockUp xlsx"), Availability_Sheet = #"Imported Excel Workbook"{[Item="Availability",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(Availability_Sheet, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Available", Percentage.Type}}) in #"Changed Type"; shared #"Availability Success" = let Source = SharePoint.Contents("https://my.metlife.com/teams/SAFeCoP/"), Documents = Source{[Name="Documents"]}[Content], PowerBi_Data_Input = Documents{[Name="PowerBi_Data_Input"]}[Content], #"GI_Analytics_MockUp xlsx" = PowerBi_Data_Input{[Name="GI_Analytics_MockUp.xlsx"]}[Content], #"Imported Excel Workbook" = Excel.Workbook(#"GI_Analytics_MockUp xlsx"), AvailabilitySuccess_Sheet = #"Imported Excel Workbook"{[Item="AvailabilitySuccess",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(AvailabilitySuccess_Sheet, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Percentage", Percentage.Type}}) in #"Changed Type"; shared MonitorLogs = let Source = SharePoint.Contents("https://my.metlife.com/teams/SAFeCoP/"), Documents = Source{[Name="Documents"]}[Content], PowerBi_Data_Input = Documents{[Name="PowerBi_Data_Input"]}[Content], #"GI_Analytics_MockUp xlsx" = PowerBi_Data_Input{[Name="GI_Analytics_MockUp.xlsx"]}[Content], #"Imported Excel Workbook" = Excel.Workbook(#"GI_Analytics_MockUp xlsx"), Monitoring_Sheet = #"Imported Excel Workbook"{[Item="MonitorLogs",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(Monitoring_Sheet, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Prior", Int64.Type}, {"Current", Int64.Type}}) in #"Changed Type"; ... View more
Status: Needs Info

Hi @Anonymous 

In which situation when you faced with error message, in Desktop or Service ?

I found 2 similar issues on the forum, you can refer to the following .

https://community.powerbi.com/t5/Issues/No-handler-was-found-for-message-type-Microsoft-Mashup-Evaluator/idi-p/1993737#comments

https://community.powerbi.com/t5/Issues/Handler-is-not-found/idi-p/1987564

 

Best Regards

Community Support Team _ Ailsa Tao

See more ideas labeled with:
1 Comment (1 New)
0 Votes
Vote
stellal___

Error shows when extracting data from Power BI Service

Submitted on ‎03-01-2022 05:19 PM Submitted by on ‎03-01-2022 05:19 PM
Hi,    I have recently encountered the issue while extracting data from PB Service, the error shows:"File couldn't be created. Executing the Query for the Export Data operation resulted in an error": It works when I extracted the data using Power BI Desktop version. Also, this only happen in certain filters; when other filters are applied it works fine. I have checked in the community there has not been any clear resolution on this issue... Could anyone please look into it? Thank you. ... View more
Status: Investigating

Hi @stellal___ 

 

To troubleshoot such kind of error, please carry these operations.

  • Check the data source of your report and confirm whether the data source is dataflow/excel/SAP
  • Capture a browser trace to see whether the underlying error shows http 500
  • Check whether the error details is something like: Error:value=The query referenced calculated column '1 append spend'[PO date] which does not hold any data because evaluation of one of the rows caused an error

vcazhengmsft_0-1646271197607.png

 

If it does, please try this solution and let me know whether this solution is applicable to you. Thanks in advance!

  • Delete the above erroneous calculated column in Power bI desktop as it had incorrect DAX query.
  • Republish the report(If the report is added into an App, updated the App)
  • The export of underlying data should work perfectly post that

 

Best Regards,

Community Support Team _ Caiyun

See more ideas labeled with:
  • Report Server
5 Comments (5 New)
0 Votes
Vote
himayenigalla

Unable to delete report from the PowerBI workspace

Submitted on ‎02-24-2022 11:40 AM Submitted by Employee on ‎02-24-2022 11:40 AM
I am trying to delete a Power BI report sourced from a live connection to a PowerBI dataset from the service workspace. The source PowerBI dataset is published to a separate workspace, the report I am trying to delete is sourcing data from the Power BI dataset and published to new workspace. However, the report is not being deleted. Every time delete is done the report is removed from the list but when refreshing the workspace files it shows up again. Have tried deleting multiple times and the report still keeps showing in the workspace.     ... View more
Status: Investigating

Hi,

Would you like to go to the audit log to check if the “Delete report” operation can work and if there is some error message within the action log?

 

It will be very helpful if you can post the download link of the video that can show the reproducing steps of this issue.

 

I also suggest you to make sure you have updated to the latest version of the Power BI desktop.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

See more ideas labeled with:
1 Comment (1 New)
0 Votes
Vote
fedwards

Can't Publish Report

Submitted on ‎02-24-2022 10:23 AM Submitted by on ‎02-24-2022 10:23 AM
Hello!    I've recently started having issues pushing report online (file size: 134,153 KB). This is surprising to me because we have reports that are larger than this already online and refreshing on a daily basis. I would appreciate any help or guidance in resolving this issue.      ... View more
Status: Investigating

Hi @fedwards ,

 

To make it more clear, I need confirm several questions with you.

  • What’s the data source of your report?
  • What’s the connection mode of your report?
  • What kind of workspace are your trying to publish your report? Is it a workspace that resided in Shared capacity or Premium capacity? If your workspace is located in a Premium capacity, you will see a diamond icon besides your workspace name.
  • Have you ever checked the storage of your workspace whether it has sufficient to store this report?

 

Best Regards,

Community Support Team _ Caiyun

See more ideas labeled with:
3 Comments (3 New)
0 Votes
Vote
billuran2009

Power BI Services Still Down

Submitted on ‎02-24-2022 06:05 AM Submitted by Helper I on ‎02-24-2022 06:05 AM
Power BI Services are down again with no communication to thousands of end users.   Something went wrong. Please try again later. TECHNICAL DETAILS Power BI was unable to read the application metadata. Please check the Power BI service status in the below support page and try again later. ... View more
Status: Accepted

Hi,

According to my research, there is still a Power BI service outage in the US, so stay tuned. Here’s the existing ICM:

 

Problem description: Some nodes were under memory pressure in three of our US based clusters

 

ICM: 290883448

 

I will update here once I get any information.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

See more ideas labeled with:
1 Comment (1 New)
0 Votes
Vote

[ISSUE] Single-selection turns into multi-selection when the report is published

Submitted on ‎02-24-2022 03:19 AM Submitted by Anonymous on ‎02-24-2022 03:19 AM
Hello,   I have an issue with one of the reports. When working with the file in PowerBI Desktop, I set the slicers to be "Single-select":  Sadly, when the report was published, the filters were displayed as multi-select: I tried changing the settings and republishing a couple of times. I also tried changing it from the PowerBI Service: when I go into the "Edit" view and choose "Single select" and then "Save" the report and go into the Reading View it's still multi select.   The embeded version of the report has a single-select option as expected.   Consequently, a page security solution I used is not working, please see the details of the solution here: Page-Level Security workaround in Power BI - RADACAD.   Thank you in advance.  ... View more
Status: Investigating

Could not reproduce this issue in my side since I have use Feb 2022 version and publish to a new workspace in Power BI Service and the slicer works fine in Service.

 

Have you tried to publish to different workspaces? If it still happens, perhaps you can consider providing more details about this issue like Desktop version, workspace type, data source of the report etc.

 

By the way, glad to hear that the solution provided by @PVO3  could help you to mitigate this issue temporarily.

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
3 Comments (3 New)
0 Votes
Vote

Scheduled refresh wont update all data sets just now

Submitted on ‎02-23-2022 05:22 PM Submitted by Anonymous on ‎02-23-2022 05:22 PM
Please help to check. I tried to refresh manually in PowerBI report but still won't update into the server.     ... View more
Status: Investigating

Based on the error information, seems like you could not publish this report to Power BI Service, not refresh failed manually in Power BI Desktop.

 

In addition, since the error message is that 'The remote server return returned an error: Internal Server Error', please consider whether it could be a temporary issue on Power BI Service so that you can try to republish this report again to Power BI Service in other time ranges to check.

 

If it still has the same issue, please consider providing more details about this issue like your data source of this report, connection mode, service cluster etc.

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
  • Report Server
1 Comment (1 New)
0 Votes
tsdick

PBI Report Publish Error

Submitted on ‎02-23-2022 02:00 PM Submitted by Resolver I on ‎02-23-2022 02:00 PM
Something went wrong Please try again later or contact support. If you contact support, please provide these details.See details   Cluster URI: WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net Activity ID: 8a5abf90-482b-4809-9be3-ed173e61729b Request ID: f1e1f15c-3b30-4c31-acbe-19098b185260 Time: 2022-02-23 14:29:00Z   Power BI services in WABI-US-NORTH-CENTRAL-B, WABI-US-NORTH-CENTRAL-H-PRIMARY and WABI-US-NORTH-CENTRAL-D-PRIMARY clusters are currently in a read operation only state while engineers investigate and address an issue impacting our customers with tenants in this cluster.   ... View more
Status: Delivered

Hi @tsdick ,

 

Just as the comms displayed in the Service Outage/Degradation section in Power BI Support(https://powerbi.microsoft.com/en-us/support/), there is an outage for the following clusters. Product team has engaged and they are fixing this issue. Please be patient for the fix.

vcazhengmsft_0-1645665175725.png

 

Thanks for the understanding!

 

Best Regards,

Community Support Team _ Caiyun

See more ideas labeled with:
  • Report Server
2 Comments (2 New)
0 Votes
Vote

Issue report

Submitted on ‎02-23-2022 01:53 PM Submitted by Anonymous on ‎02-23-2022 01:53 PM
Date and Time: 2022-02-23 21:51:00Z Activity Id: c976c539-da1a-4b93-b138-a7cc29a0ad16 ... View more
Status: Investigating

Hi,

I will be helpful if you can show the whole error detail like the request ID and the tenant cluster region.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

See more ideas labeled with:
  • Report Server
2 Comments (2 New)
0 Votes
LeijaRLJones

Couldn't publish to PowerBI The remote server returned an error:(500) Internal Server Error

Submitted on ‎02-23-2022 12:27 PM Submitted by on ‎02-23-2022 12:27 PM
PowerBI publishing is not working.       ... View more
Status: Delivered

Hi @LeijaRLJones ,

 

Just as the comms displayed in the Service Outage/Degradation section in Power BI Support(https://powerbi.microsoft.com/en-us/support/), there is an outage for the following clusters. Product team has engaged and they are fixing this issue. Please be patient for the fix.

vcazhengmsft_0-1645665239084.png

 

Thanks for the understanding!

 

Best Regards,

Community Support Team _ Caiyun

See more ideas labeled with:
  • Report Server
3 Comments (3 New)
0 Votes
Vote
Allisond

All Refreshes new Failing

Submitted on ‎02-23-2022 10:56 AM Submitted by Advocate II on ‎02-23-2022 10:56 AM
The data load issue is resolved, we can now load the reports, but we are now seeing refresh failures and are unable to refresh.  ... View more
Status: Needs Info

When the refresh failed, is there any error information in Refresh history? You can find it in Settings -> Datasets -> refresh history when choosing a workspace.

vyingjl_0-1645671761465.png

If there is error information about this refresh, you can click 'details' to find the details information about this issue and consider sharing it for further.

 

In addition, have you checked that the refresh was been configured correctly, see: Configure scheduled refresh 

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
  • Report Server
1 Comment (1 New)
0 Votes
Vote
matheusfc

Loss of comments on the web platform

Submitted on ‎02-18-2022 10:54 AM Submitted by on ‎02-18-2022 10:54 AM
Hi!   I have a dashboard where users use the comments on the web platform.       But, there are a few weeks, all the comments disappeared. I verified the backups and nothing.   Does someone know how I can recuperate the comments? ... View more
Status: Investigating

Hi,

As far as I’m concerned, anyone who has access to the dashboard can view the comment. Here are some limitations to this feature, please refer to this link:

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-comment#considerations-and-troubleshooti...

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

See more ideas labeled with:
  • Report Server
1 Comment (1 New)
0 Votes
Vote
CSheaHPT

Issue with Object Level Security from SSAS in PBI service (but not desktop)

Submitted on ‎02-17-2022 10:26 AM Submitted by on ‎02-17-2022 10:26 AM
Hi all.   We currently have an SSAS tabular model with Object level security (Admin can see all, Restricted_user cannot see specific columns in a few tables) feeding a PowerBI dataset [Dataset X] deployed in the service (non premium workspace). When we connect to the [Dataset X] in PBI Desktop as a Restricted_user, we cannot see the columns/visuals as desired.  BUT, when reports are pointed at the same [Dataset X] and published to the service, two things happen: 1. The Restricted_user is able to see some of the columns/values in visuals that should be restricted 2. Other visuals in the same page refuse to load (that the Restricted_user should have access to, and can see in desktop), and when refreshing page, the visuals that do load switch (i.e. visual 1 & 2 load correctly which should be visible, but 3 does not. Then when refreshed, 2&3 could load but not 1) ***on desktop, this works properly (pointing to cache issue to me...)** Some things we've already tried: 1. Cleared all caches (browser, dataset) 2. refreshed dataset x  3. republished dataset x   Anyone have any ideas?! ... View more
Status: Investigating

Hi,

According to your issue and description, I suggest to check to make sure that you have added the end-users to the RLS roles of the dataset and the users only have viewer access to the corresponding workspace or view access to this report.

vrobertqmsft_0-1645172198510.png

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

See more ideas labeled with:
1 Comment (1 New)
0 Votes
Vote

wrong version of PBIDesktopSetup_x64.exe 2.102.622.0 download, the version still is 2.100.1401.0

Submitted on ‎02-17-2022 08:22 AM Submitted by Anonymous on ‎02-17-2022 08:22 AM
today i downloaded PBIDesktopSetup_x64.exe 2.102.622.0, to create a install package for my organazation. when i extracted the .exe and started adding a .mst to the powerbi.exe i noticed the version of the .msi still was at 2.100.1401.0. so i started checking what went wrong. after some research i found that the .exe that i downloaded here(https://www.microsoft.com/en-us/download/details.aspx?id=58494) that says version 2.102.622.0 is still at 2.100.1401.0.   this results in a problem when trying to update the 2.100.1401.0 version to 2.102.622.0 version. This because we use an automated update tool that wants to install the new update but the installation fails because its already installed. the automatic update tool then triggers a restart and tries again.   so therefor this request to please update the version for the file that we download. Thankyou!  ... View more
Status: Accepted

Hi,

According to my research, a similar issue has been reported internally, so stay tuned.

 

Problem description: Cx downloaded the latest version Power BI Desktop from Microsoft Download Center and found the version displayed in Desktop is wrong after installation.

 

ICM: 289626619

 

I will update here once I get any information.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

1 Comment (1 New)
0 Votes
Vote
danielcontente

The amount of data on the gateway client has exceeded the limit for a single table.

Submitted on ‎02-17-2022 08:29 AM Submitted by Helper II on ‎02-17-2022 08:29 AM
Hi,    I am trying to refresh a dataset but getting the following error:   "The amount of data on the gateway client has exceeded the limit for a single table. Please consider reducing the use of highly repetitive strings values through normalized keys, removing unused columns, or upgrading to Power BI Premium."   The workspace storage is as follows:     I appreciate your help.   Thank you! ... View more
Status: Investigating

Hi @danielcontente 

 

I found an similar issue with similar refresh errors. It should be by-design limitation. Actually, the resolution of this issue is exposed in the Error message itself, remove the columns with high cardinality or move to Premium. The easiest way to find the columns with high cardinality is to use the DAX Studio tool:

1 Connect to the model/PBIX file

2 Go to Advanced -->View Metrics

vcazhengmsft_0-1645162559316.png

 

3 Try to remove as much as you can from the columns that have the highest cardinality. In the above sample if we can remove “Order ID”, it will help reduce the size significantly.   

 

Reference: https://docs.microsoft.com/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios#uncompres...

 

Please try the workaround above and let me know whether it could solve your issue. Thanks in advance!

 

Best Regards,

Community Support Team _ Caiyun

See more ideas labeled with:
4 Comments (4 New)
0 Votes
zfeng

Power BI Stuck on Loading Your Report/Status Code 500 Internal Server Error

Submitted on ‎02-16-2022 09:17 AM Submitted by on ‎02-16-2022 09:17 AM
I have several dashboards stuck on "Loading Your Report" screen for entire morning. Tried a differernt browser but it didn't work. All users are experiencing same issue in my organization.  Error message I just got after "Loading your report" for a while. This is a premium workspace.          Also have this internal server error for data refresh this morning.    Hide Scheduled 2/16/2022, 7:02:10 AM 2/16/2022, 8:59:18 AM Failed 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. Cluster URI: WABI-US-NORTH-CENTRAL-F-PRIMARY-redirect.analysis.windows.net Activity ID: 76f495d5-6f60-4fd3-ab60-3892842c654c Request ID: c9e09260-a705-4b10-a6b6-e2b94bc76f53 Time: 2022-02-16 15:59:18Z   ... View more
Status: Delivered
See more ideas labeled with:
  • Report Server
4 Comments (4 New)
0 Votes
Vote
Baker

DB2 connection not working any more after office update

Submitted on ‎02-15-2022 06:58 AM Submitted by on ‎02-15-2022 06:58 AM
Hi For more than 1 year I am using a DB2 connection via Power Query in Excel and PowerBI. After some office Updates they do not work any more.   It seems like to connection to the database itself can be established, but after that I get the following error message:    ... View more
Status: Investigating

Hi @Baker ,

 

You mean you could connect to DB2 data source and retrieve data from it, right? May I know if you try to refresh it in Power BI Desktop, will you get any errors? If you still can refresh successfully, I think this issue should not impact the usage of this data source too much.

Best Regards,

Community Support Team _ Caiyun

See more ideas labeled with:
2 Comments (2 New)
0 Votes
Vote
yzang198

Power BI service cannot refresh since 2/7/2022 (Same document refreshes with no issue on Desktop

Submitted on ‎02-14-2022 10:43 AM Submitted by on ‎02-14-2022 10:43 AM
Hello, I have a report that refreshes on Power BI desktop with no issue but has not completed any daily refresh on Power BI service.   Below is the error message I got when trying a manual refresh on Power BI service:   Processing errorThe credentials provided for the Salesforce source are invalid.  Cluster URIWABI-WEST-US-redirect.analysis.windows.net Activity ID716a75ae-3ed4-4626-a6f6-d93a16a98862 Request IDded5133f-8b47-5587-0327-04bd189f1ead Time2022-02-14 18:25:18Z Also I am not sure where the link to submit a support ticket go. This is very annoying. ... View more
Status: Investigating

As the error message mentioned, please check whether you have configured the credentials for the data source in Power BI Service correctly or the credentials have been changed already.

 

In addition, if you want to submit a support ticket, you can find it in the end of the support page

vyingjl_0-1644891765422.png

 

Best Regards,
Community Support Team _ Yingjie Li

 

See more ideas labeled with:
1 Comment (1 New)
0 Votes
Vote
KCBH2021

Report Subscription Delay - Email

Submitted on ‎02-14-2022 09:33 AM Submitted by on ‎02-14-2022 09:33 AM
Currently, Email Subscriptions are either never making it through to the end-user or are coming over heavily delayed. There is no issue on our end with blacklisting no-reply-powerbi@microsoft.com. This seems to reoccur monthly and is very annoying as I have to track down, then manually send each report that was missed.  ... View more
Status: Investigating

Hi @KCBH2021 

 

Firstly, according to the official document, the subscription time you set is when the subscription starts to process Once the report processing is complete, the subscription is queued and sent to the e-mail recipients. At times of peak demand, you may see a delay, but not more than 15 minutes. On rare occasion, it may take up to 30 minutes, but should never exceed 60 minutes. If you experience a longer delay, ensure that the address no-reply-powerbi@microsoft.com is on the safe sender list. Another recommendation is to run your data refresh and email subscription at different times to ensure timely delivery. For more details about email subscription, you may refer to Troubleshoot subscribing to dashboards and reports - Power BI | Microsoft Docs.

 

Then, to make it more clear, I need confirm several questions with you. May I know how long your email is delayed? Does it exceed 15, 30 or 60 minutes? Is the refresh of your dataset adjacent to the subscription time?

 

Best Regards,

Community Support Team _ Caiyun

See more ideas labeled with:
  • Report Server
2 Comments (2 New)
Idea Statuses

Helpful resources