We are wanting to use direct query for our datasets so we are not limited to how often we can refresh an imported dataset. We are running into an issue of with datetime fields coming from Starburst. Power BI doesn't support timestamp(9) as a date field and we are unable to convert the field data type due to the limitation of direct query. Are there any date formats from Starburst that Power BI supports? We haven't found any. ... View more

When exporting a report as an image to PPT (or to PDF), there is an option to export with default values or with the current selection. No matter what I try, the export is always with the default values. This is for all reports that we currently have online. This issue was previously raised  last year and a fix was issued, but it has recently stopped working again. Export to PDF or PPT always takes default values  Thanks ... View more

Hi there,   I have a noticed a recent issue where people are trying to use the export via the Summarized Data and the File Format .csv    It says it has a limit of 30,000 rows but on any export it only retrieves the first 300?   Can this be investigated please? ... View more

Dear MSFT   Recently I've noticed that calculated column and dax measures s are going blank or unchanged after writing code.   Can you review this potential bug from September version?    Thanks. ... View more

Hi   This morning we no longer recieved Subscription emails from PowerBI reports.   Any ideas to what can be wrong?    Br Mads ... View more

"Analyze in Excel" works nicely in the web-version of Excel. In the Excel application we have the following issues: 1. Only measures can by aggregated (i.e. not possible to sum numerical variables without defining measures).  2. The interaction between connected datasets does not work.    Item 2 is a show-stopper for any application with more than one data connection. Are there any other workarounds than denormalizing the data (one "flat" data source)? ... View more

All the relationship lines are missing from the model view.  All graphical manipulation of the model fails.  Adding new tables/datasources fail.  A new version needs to be released immediately.  It appears that version 2.119.666.0 doesn't have that problem.  These versions are so new that they're not even documented on the Microsoft site.  😞   ... View more

Hi, as I am with the latest version of Power BI ( Version: 2.121.644.0 64-bit ) , I have a problem with downloading data - I get the following error - "your data is too large some sampling may occur "  ... View more

Hello,   My data source is ADLS Gen 2, which was working find up until September 16. Now I get a non-descript error when trying to connect to the datasource from Power BI desktop. The published report is refreshing without an issue, so it seems specific to desktop.   Feedback Type: Frown (Error) Error Message: Error Stack Trace: Microsoft.Mashup.Client.UI.Shared.ExceptionResultException at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message) 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.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing) at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource() at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource() at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled) Stack Trace Message: Error 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.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.PowerBI.Client.Windows.Utilities.PowerBIFormUnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.Mashup.Client.UI.Shared.DataImporter.HandleImportEvaluationException(ExceptionResult exceptionView, Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor) at Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor) at Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination) at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass89_0.<OnQuerySettingsResolved>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) 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.121.662.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.EvaluationHost","Error":"Microsoft.Mashup.Client.UI.Shared.ExceptionResultException","MethodDef":"OnException","ErrorOffset":"","ErrorCode":""}   Also, when trying to refresh the data in desktop, it gives this error: Could not load file or assembly 'Microsoft.Mashup.Cdm.ICdmProvider, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.   Any help would be appreciated - I'm supposed to get this report out and I'm dead in the water! ... View more

https://community.fabric.microsoft.com/t5/Service/Power-BI-Service-Dataset-Refresh-Error-Expression-Error-The/m-p/3378733   There is already an ongoing thread in the Community PBI Service forum but I thought it could do with being here too for visibility.   Symptoms:  SharePoint Online lists meeting certain criteria fail to refresh with error Expression.Error: The column '<ccon>ID' of the table wasn't found.. ID. </ccon>. The exception was raised by the IDbCommand interface. Table: [Table Name]   Refresh in Power BI service was working fine for these reports across multiple tenants until reports running from 9/8/2023 midnight UTC onwards.   Some possible trigger conditions noted in above thread:   V2 connector and empty SharePoint list created before a certain date on SharePoint Teamsite (classic w/o Team)  V2 connector and ID column for the list isn't being imported to the data model (i.e. query filters it out)   I found in the second circumstance as long as the list has data in it you can get it to refresh by including the ID column in Power Query instead of removing it, but empty lists just fail completely.   @sulleyinoz mentioned there is a ticket open with MS about their issues with blank lists, is there any acknowledgement this is a wider issue and is being worked on?   Thanks   Mark   ... View more

Situation: One Matrix visual from our standards report and have another Matrix visual from current report. When using format painter from our standards report and applying that to the current report not all the attributes come over as expected. - AUTO-SIZE WIDTH doesn't come over properly. It is OFF in the standards, but when applied to the current pbix it is moved to ON. - ROW SUBTOTALS is ON in the standards pbix and it gets moved to OFF in the current pbix when we apply the format painter.   Version: 2.121.762.0 64-bit (September 2023) ... View more

I keep getting a data limit reached error when attempting to export the data to a CSV file. If the rows of the table visual exceed 300, it gives me the error. Also, reverting back to July version does NOT work. Opening files that have been opened using the September update return an error of incompatibility.  ... View more

Running a VM with 2 processors and 32 GB of RAM Windows Server 2016 standard 64-bit Version 1607 OS Build 14393.5501 Everytime I open Power BI Desktop I'm being promtped to re-enter my login credentials... This appears to have started on 2.117.894 which was found after some testing. This is incredibly frustrating and annoying as I need to enter my full e-mail/AD password (multiple times) and also authenticate via Ping ID every time I open Power BI desktop. Previous version did not have this issue and functioned as expected caching the credentials, allowing me to open a new Power BI desktop window without needing to re-authenticate every time. I have installed previous version of Power BI but am unable to open and .pbix file I edited in a more recent version... the following list is the versions tested to document when the issues started to occur: 2.115.663 - not re-prompted to login each time, user image shows up, pbix files do not load 2.116.622 - not re-promptedto login each time, user image shows up, pbix files do not load 2.116.996 - not re-prompted to login each time, user image shows up, pbix files do not load 2.117.894 and after - re-prompted for login each time, user image does not show up, pbix files load The "user image" is simply my avatar that is set on office365 for my user account within my company None of the labels made sense for this issue, but I was required to add one. ... View more

I have a PBIX file with ~30 tables and with multiple data tables and support tables. I've recently run into an issue when I add a NEW table to the report, it puts it in the top left corner and I'm unable to move it. This causes an issue as I have multiple new tables to add and they keep stacking on top of each other and I'm unable to move any of them. ... View more

New BUG:  The date format in all reports on Power BI Service for all users has changed to US format over the weekend, without any of us changing anything.   This issue has been identified all over the world in Germany, Brazil, Russia, Finland, New Zealand etc. as per this new community post:  Re: Different regional configuration Power BI DAft... - Microsoft Power BI Community     We have checked our browser & PC language & regional settings but have not found a cause, nor a fix. We have not changed any of those settings over the weekend. Could you please urgently help fixing this as it negatively impacts our external customer reporting? ... View more

Until 3 days ago this worked fine 🙂 Now the tooltip displayed on the line of the line and clustered column chart is not showing on hover over....more annoyingly, this only happens in the service, it works fine in desktop, also works fine on the columns.   If I add the field in to the tooltip field of the chart the number then shows twice (but at least it shows).     Tried in chrome and edge, both browsers doing the same (no cache issues with chrome as I dont use it) ... View more

Since the June 2023 release of Power BI desktop, you are no longer able to reorder fields in the filter pane. This issue exists in both Power BI desktop and Power BI service. Please fix it.  ... View more

Hi!   With fabric launch the way how you connect to Power BI dataset has changed. Previously, when you was connecting to already developed dataset for all report no new datasets were added. Now all reports connected to dataset have their own separate dataset.   Because of that when we are publishing Power BI App with those reports connected to separate datasets access provided only to directly connected to this reports datasets, but not original. And this causes "Couldn't retrieve the data for this visual. Please try again later" because it still requires users to have access permission to the original dataset.   For now we have manually added rights to origin dataset, but this doesn't sound as working properly, or we are doing something wrong?   Many thanks in advance! ... View more

When I use the same bookmark group for different bookmark navigators on a page, I encounter a problem. If I select a bookmark on navigator A, it shows the same state for navigator B. However, if I navigate to a different page and interact with the bookmarks, upon returning, I see the correct state for navigator A and the default state for navigator B. ... View more