From yesturday users outside of organisation see null dashboards with only the Q&A section. Any suggestions how I can fix this?
The stacked column charts stopped working in existing dashboards and reports. all other reports, grids etc seem to be working fine. Datasource is SSAS MD cube. I have confirmed that there is data at the intersection in the cube that is included in the reports. Report was created from dataset online and not from desktop power bi.
The Attribute Slicers works fine in PowerBI Desktop, no warnings, published w/o issue, but the Attribute Slicers do NOT function in the published reports. The slicers worked fine w/previous publications.
I am having issues installing the Power BI Gateway (powerbigatewayinstaller.exe). It seems the installer doesn't initiate/run.
I think there might be an issue with the application itself, since I am having the same issues on three different computers.
I have tried:
- Run as administrator
- Start the installer from Run
- Check the Task Manager if the process is actually running, with no trace of the gateway.
So I figured I check the Event viewer, and found a .net runtime error with event id 1026. There's also an application error, but I presume this is down to the .net runtime error. The information from the event viewer is as follows:
Tillämpningsprogram: PowerBIGatewayInstaller.exe Framework-version: v4.0.30319 Beskrivning: Processen avslutades på grund av ett ohanterat undantag. Undantagsinformation: System.IO.FileNotFoundException vid Microsoft.DataProxy.PowerBIInstallDownloader.LandingPageViewModel..ctor(Microsoft.DataProxy.PowerBIInstallDownloader.MainViewModel) vid Microsoft.DataProxy.PowerBIInstallDownloader.MainViewModel..ctor() vid Microsoft.DataProxy.PowerBIInstallDownloader.MainWindow..ctor() Undantagsinformation: System.Windows.Markup.XamlParseException vid System.Windows.Markup.XamlReader.RewrapException(System.Exception, System.Xaml.IXamlLineInfo, System.Uri) vid System.Windows.Markup.WpfXamlLoader.Load(System.Xaml.XamlReader, System.Xaml.IXamlObjectWriterFactory, Boolean, System.Object, System.Xaml.XamlObjectWriterSettings, System.Uri) vid System.Windows.Markup.WpfXamlLoader.LoadBaml(System.Xaml.XamlReader, Boolean, System.Object, System.Xaml.Permissions.XamlAccessLevel, System.Uri) vid System.Windows.Markup.XamlReader.LoadBaml(System.IO.Stream, System.Windows.Markup.ParserContext, System.Object, Boolean) vid System.Windows.Application.LoadBamlStreamWithSyncInfo(System.IO.Stream, System.Windows.Markup.ParserContext) vid System.Windows.Application.DoStartup() vid System.Windows.Application.<.ctor>b__1_0(System.Object) vid System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32) vid System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate) vid System.Windows.Threading.DispatcherOperation.InvokeImpl() vid System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) vid System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) vid System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object) vid MS.Internal.CulturePreservingExecutionContext.Run(MS.Internal.CulturePreservingExecutionContext, System.Threading.ContextCallback, System.Object) vid System.Windows.Threading.DispatcherOperation.Invoke() vid System.Windows.Threading.Dispatcher.ProcessQueue() vid System.Windows.Threading.Dispatcher.WndProcHook(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef) vid MS.Win32.HwndWrapper.WndProc(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef) vid MS.Win32.HwndSubclass.DispatcherCallbackOperation(System.Object) vid System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32) vid System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate) vid System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority, System.TimeSpan, System.Delegate, System.Object, Int32) vid MS.Win32.HwndSubclass.SubclassWndProc(IntPtr, Int32, IntPtr, IntPtr) vid MS.Win32.UnsafeNativeMethods.DispatchMessage(System.Windows.Interop.MSG ByRef) vid System.Windows.Threading.Dispatcher.PushFrameImpl(System.Windows.Threading.DispatcherFrame) vid System.Windows.Application.RunDispatcher(System.Object) vid System.Windows.Application.RunInternal(System.Windows.Window) vid Microsoft.DataProxy.PowerBIInstallDownloader.App.Main()
We have a report in PBI service containing lots of matrixes. The report uses SSAS live connection as a source
They have fields in the rows, no fields in the colums and ofcourse some values.
If I download the report and open it in PBI desktop (Version: 2.51.4885.701 64-bit (October 2017)) the report works fine.
They worked fine last thursday. Today I get a complaint of the enduser that the report doesn't show data anymore!
I only get the matrix working if I add a field of the columns.
Has there been an update on the matrix visual? Please fix!
I have two primary data sources in my reports - Salesforce and Workday which is via the built-in PowerBI CSV importer.
When I setup the PowerBI automatic refresh (in the web app), or via a manual refresh in the web app, all the reports fail to refresh and without any details.
In Desktop all the reports refresh all the time without issue. (1) How do I get details of WHY things are failing? (2) Why does this work in Desktop and not after published/refreshing on app.powerbi.com?
Here is the latest example.
|Message:||The command has been canceled. Table: PowerBI: Projects(Non-Billable) w Financ.|
we defined a report with Power BI Desktop with a Live connection toa tabular model (SSAS 2016).
When we move it from development to pre-production we usually change the SSAS tabular connection using edit queries.
We try to do this with the latest version of Power BI Desktop (Nov 17)Â but all the visuals used appear signed with an X (no object found).Â The same works fine with the previous versions.
We suppose this is a bug.
We have a Dashboard that pulls from 2 different reports that has been up and working fine for awhile. But as of this morning we're suddenly seeing strange issues. Here's what we observe:
- The main issue is that the Tiles are all blank (no error, just empty as in the first screenshot below)
- The dashboard says "Refreshing" in the top left and has been like that for hours
- The underlying reports do load properly, and if you pin a new Tile, then that new Tile works fine
- The original, blank tiles cannot be deleted from Dashboard. When you click the menu, there simply isn't an option to delete it anymore. (see second screenshot)
- Clicking "Refresh Dashboard Tiles" does not force them to load
This is our main Dashboard and it would be less than ideal to have to rebuild it completely. Hoping someone has seen this before and knows a solution...?
I have email subscriptions set up that send dashboards out to me on a daily basis. Occasionally, seemingly on random days, parts of the dashboards within the emailed image show no data when there is data in the data model, and the correct data is displayed when viewing the dashboard within Power BI itself.
Is anyone experiencing the same issue?
So, this is logged over in ideas.powerbi.com. However, It's really a bug that can cause problems with report integrity and trust of users for reporting. Table visualizations cannot display duplicate rows. This is with summarization turned off for every field on the table, which is a separate pitfall. In SQL terms, the table visualization acts like a UNION, but it should act as a UNION ALL.
The workaround for the present is to do as advised in the forums, which is to add a unique column to the table visualization and then shrink the column width in order to hide it. In one case recently, however, I had to add an index to my query and then hide that column (with word wrap on, this hack also had the effect of resizing my rows to accommodate the wrapped but hidden index field). My users would like to see, for example, that a check detail has two line items for exactly $51. And I would prefer not to have to build workarounds.
Bug in PowerBI Desktop Version: 2.51.4885.701 64-bit (October 2017)
When you single click a query in the "Queries" selector on the left hand side, it thinks you want to move the query up or down to re-order.
This did not happen in the previous version.
In new release verson of Power BI desltop Version: 2.51.4885.543 64-bit (October 2017). There is no Line style (a Shape feature) of Line chart which is added in Aug 2017 release. Could you please kindly check it?
as the link below
After November mid update,this issue came back. when using drillthrough filter to jump to another page again and again,the memory keeps growing.
This issue has been occuring for the past week, only for one specific report. Publishing from the desktop client still works normally and is being used as a manual refresh.
Details Type Start End Status Message
|On demand||21/09/2017 4:40:43 PM||21/09/2017 4:40:48 PM||Failed||The gateway operation has been cancelled explicitly by the user or from a timeout.|
THis morning the sharing of a dashboard to an external user does not work on the service while it was working before.
The dashboard is referenced on the title but below the page is grey.
Can you check the service for any sharing issue to external users ?
Thanks in advance.
I have the following Power BI Report
If you nativate to page 7, there is a column chart down the bottom. The column on the axis is formatted as TIME. When there is a single value selected for DATE in the slicer, the time formats correctly. When there is no date applied to the date slicer, the axis incorrectly formats as Date/Time.
We faced with issue that in our custom application with embedded report "Line and Stacked Column Chart" in see data mode has wrong view (names of columns in header are duplicated):
It was working fine in application before and also it is working fine right now in PBI Desktop (October 2017 Version):
Thank you in advance
I'm getting the following error when using a variable and logical operator in a column (using direct query).
"An unexpected error occurred (file 'tmmdmodeltm.cpp', line 5980, function 'MDModelTM::GenBaseTableQuery')."
createdChanged = var x = DATEDIFF(xxxxxx[createdDate];xxxxxx[changedDate];DAY) return if(x>1000;0;x)
This formula works fine in Import mode. Tried several scenarios, but it seems the error is thrown when the variable is used as part of the logical test (e.g. this works: createdChanged = var x = DATEDIFF(xxxxxx[createdDate];xxxxxx[changedDate];DAY) return if(1=1;x;1)
When I use a filter by selecting a group in a visual (e.g. a funnel chart) and then select an element from a connected table the funnel selection ist lost. This just happens when the table with the filter results has more rows than the visual can show (scroll bar appears). We could not determine how long the table must be.
I can provide a sample to simulate the issue.
Help/bug fix is highly appreciated because of customer awareness.