I have a Pro Workspace, where I created some Dataflows     They are set up correctly and no issues with the refresh   When I tried to use one of them in my model, I could connect to it and refresh connections/data with no issues in Power BI Desktop but when i published my report, I am unable to refresh the Semantic Model through the service once it is published to https://app.powerbi.com/   I have checked the Semantic Model authentication method and selected PowerPlatformDataflow       Wich is set in the service with     The Dataflow and the Semantic Model are in the same Pro licensed Workspace but I keep getting this error     According to https://learn.microsoft.com/en-us/power-query/dataflows/what-licenses-do-you-need-in-order-to-use-dataflows#power-bi-pro I should be able to use Dataflows in  a Pro Workspace. I did see that there are limitations like, DirectQuery connection option to the dataflow, you need to have Power BI P1 or A3 or higher capacities. So I tried changing it to import mode for that Dataflow and it still failed to refresh.     Why can I not use my Dataflow in my Semantic Model? ... View more

Currently, when use Relative Date Filter or Slicer, when you want relative to calendar week, month or year, is possible use three operators "is in the last", "is in this" and "is in the next", which mean "<", "=" and ">". There completely missing ">=" and "<=" ("is in the last or in this" and "is in this or in the next") comparation.   Additionally, is not possible combine (with OR) these comparation (is not possible set "is in the last" n " "calendar months" OR "is in this" "calendar month", as is possible in advanced filter.   And last chance, in slicer is configuration option "anchor date" which can move the relative date and solve this issue, but this option is possible set only to fixed value. Is not possible set dynamically, e.g. = dateadd(today(),1,MONTH). Truly, if static only, I don't know what good is for (for relative date slicer).   Result? Currently is not possible filter date relative as common user want. Is not possible filter dashboard, and see e.g. last 12 whole months in row include current month. But I hope, it is only bug, and will be soon fixed by adding well know comparators ">=" and "<=" ... View more

I can't open Power bi ,so i need you help .   Feedback Type: Frown (Error) Timestamp: 2024-09-09T11:27:36.9612310Z Local Time: 2024-09-09T14:27:36.9612310+03:00 Session ID: 0b227385-001c-48a2-8b37-e52bcdb088a6 Release: August 2024 Product Version: 2.132.1053.0 (24.08) (x64) Stack Trace: System.NullReferenceException at Microsoft.Mashup.DocumentServices.Shorthand.ShorthandManager.ValueIsCompatibleWithOptions(IValue value, ShorthandOptions options) at Microsoft.Mashup.DocumentServices.Shorthand.ShorthandManager.TryGetShorthand(IValue value, IValueRoundTripStringProvider valueRoundtripStringProvider, String& shorthand, ShorthandOptions options) at Microsoft.Mashup.Host.Document.Formulas.GenericInvokeParameterInfo.GetDefaultSampleValues(IEngine engine, TypeHandle paramType) at Microsoft.Mashup.Host.Document.Formulas.GenericInvokeParameterInfo.CreateSampleValues(IEngine engine, GenericInvokeParameterInfo paramInfo, ITypeValue paramType) at Microsoft.Mashup.Host.Document.Formulas.GenericInvokeParameterInfo.Create(IEngine engine, GenericInvokeDetails formula, IFunctionTypeValue funcType, Int32 paramIndex) at Microsoft.Mashup.Host.Document.Formulas.GenericInvokeDetails.TryGetParameterInfos(GenericInvokeParameterInfo[]& parameterInfos) at Microsoft.Mashup.Host.Document.Formulas.GenericInvokeDetails.ProcessBaseResult(FormulaResult baseResult) at Microsoft.Mashup.Host.Document.Formulas.GenericInvokeDetails..ctor(IEngine engine, IFunctionTypeValue functionType, NativeQueryProperties nativeQueryProperties) at Microsoft.Mashup.Host.Document.Formulas.GenericSourceInvokeFormula..ctor(IEngine engine, IFunctionTypeValue functionType, String functionName, String moduleName, FormulaData formulaData, String buttonTitle, String buttonHelp, Boolean isInternal, Boolean supportsDirectQuery, MultiDimensionalStyle style, NativeQueryProperties nativeQueryProperties) at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.PublishedFunction.<>c__DisplayClass89_0.<GetCreator>b__0(IEngine engine) at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHost.DataSourceFormula..ctor(String functionName, Func`2 formulaCreator, TelemetryUserActionId formulaTelemetry, Action enable, String functionButtonTitle, String iconClass) at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHost.LoadMExtensionExports(IList`1 modules) at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHost.TracePerformance(Trace trace, String name, Action action) at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHost.Activate(IApplicationPaths applicationPaths, ILibraryProvider internalProvider, ILibraryProvider remoteExtensionsProvider) at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHostManager.RegisterAndActivateUiExtensionHost(UiExtensionHost uiExtensionHost, IApplicationPaths applicationPaths, ILibraryProvider internalProvider, ILibraryProvider remoteExtensionsProvider) at Microsoft.PowerBI.Client.Windows.PowerQueryExtensionsLoader.<Load>b__10_1() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.132.1053.0","ModuleName":"Microsoft.Mashup.DocumentServices.dll","Component":"Microsoft.Mashup.DocumentServices.Shorthand.ShorthandManager","Error":"System.NullReferenceException","MethodDef":"ValueIsCompatibleWithOptions","ErrorOffset":"10","ErrorCode":""} OS Version: Microsoft Windows NT 10.0.22631.0 (x64 ar-SA) CLR Version: 4.8 or later [Release Number = 533320] Peak Virtual Memory: 70 GB Private Memory: 206 MB Peak Working Set: 618 MB IE Version: 11.1.22621.0 User ID: e425ffd3-f142-46ec-89ac-72a9cbc38e25 Workbook Package Info: 1* - ar-SA, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False. Telemetry Enabled: True Model Default Mode: Empty Model Version: PowerBI_V1 Enabled Preview Features: PBI_sparklines PBI_scorecardVisual PBI_NlToDax PBI_fieldParametersSuperSwitch PBI_setLabelOnExportPdf PBI_dynamicFormatString PBI_oneDriveSave PBI_oneDriveShare PBI_useModernPublishDialogs PBI_gitIntegration PBI_newCard PBI_buttonSlicerAuthoring PBI_EimLessElevatedUser PBI_mobileAutoReportLayout PBI_daxInlineCopilot PBI_aiNarrativesVisual PBI_generateMeasureDescriptionsButton PBI_desktopReportAuthoringCopilot Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_b2bExternalDatasetSharing PBI_enhancedTooltips PBI_onObject PBI_odspSaveBackgroundUpload PBI_publishDialogsSupportSubfolders PBI_tmdlInDataset PBI_enhancedReportFormat PBI_qnaImproveLsdlCopilot PBI_visualCalculationsAuthoring Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 125% Supported Services: Power BI ... View more

I have a short drop-down slicer on one of my report pages that has 3 items. On desktop, when I click the drop-down I see all options upon first click, just like so:               However, when I publish the report, all users, myself included, only see a single item in the drop-down when the slicer is clicked the first time (see pic below). When a user clicks on the slicer the second time (and any time thereafter), they see the "full" dropdown and all three items like it appears on desktop.             This is confusing to users as its not obvious that there are additional options and the scroll bar only appears if you hover over the scroll area. This is a single-select slicer that is on the topmost layer of the report page and isn't being covered by any other item.    This behavior can be seen in every report slicer that has a "small" amount of items (generally <5) -- a user must click the drowpdown, exit, then re-click the slicer dropdown in order to see all the items when viewing the report in the web browser.  Again, every user, regardless of access level or web browser, sees this same behavior. And its on every report that has slicer with a small amount of items, its not limited to this single report example.   If it helps any, I'm on the Power BI Premium service and the desktop version I'm using is Version: 2.92.1067.0 64-bit (April 2021)     ... View more

Hello, I am trying to publish an app and am coming across this message:    Activity ID: af88ba02-93f0-4d30-b5e7-a4ed17fbb1ce Request ID: e4ac52df-05a0-e890-a644-7e04c5c775b3 Correlation ID: b5f32895-f62c-bd43-bafd-d681684092ce Time: Mon Aug 01 2022 11:23:05 GMT+1000 (Australian Eastern Standard Time) Service version: 13.0.18756.45 Client version: 2207.4.12439-train Cluster URI: https://wabi-us-east2-redirect.analysis.windows.net/   It doesnt exactly tell me what the problem is. Could someone please assist?  ... View more

Lately I noticed that when viewing reports on browser, all reports takes forever if they even load at all. Please see attached image.   This happens from randomly, sometimes after a few hours the reports works well as normal But recently this issue has occred much more frequent and the period of the issue is longer. Today, the report failed to load for the entire day.   Anyone has encounted this issue. My data is on Singapore server.   Mac       ... View more

Hi everyone,   I'm encountering an issue with Azure Maps in Power BI, and I was hoping someone could help. I've been using Azure Maps in my reports for several months without any problems. However, recently, when I export my report to PDF or PowerPoint via Power BI Service, the map fails to display the location marker (bubble) and does not apply the automatic zoom to the specific coordinate. To give you more context, my map only contains a single bubble to pinpoint a specific coordinate.   In the past, this worked perfectly, with the map automatically zooming in to the location and showing the bubble clearly. Now, after exporting, the map only shows the satellite image of the Earth, without any markers or proper zoom. This issue only started occurring recently, and I'm unsure what could be causing it. Has anyone else experienced something similar?   Any advice on how to resolve this would be greatly appreciated!   Thank you in advance for your help 😊 ... View more

Power BI customers with premium capacities using Row Level Security may experience issues while adding non-mail-enabled security groups to roles with the message, "The Role could not be updated. Please try again later". As a workaround, users can move their workspace to Shared, add the security group, then move it back to the capacity. Engineers have identified the root cause and a fix is expected to be deployed by end-of-day 01/16/2021.   Above issue is still not fixed . ... View more

I have a Premium workspace with Git integration enabled, which is linked to an Azure DevOps repository. Everything is functioning as expected for the semantic model and Power BI reports. However, we are encountering an issue with our Paginated reports. These reports are connected to a Direct Lake semantic model within the same workspace. When I publish these Paginated reports, they automatically appear as "Synced" rather than "Uncommitted," and I am unable to commit them to the Azure DevOps repository. Despite the Git Status indicating "Synced" in the workspace, the reports do not appear in the Azure DevOps repository.  This issue does not occur with Paginated reports connected using import mode; it seems to be specific to reports connected via the Direct Lake semantic model.       ... View more

Hello,   Having downloaded the latest version of Power BI desktop (Version: 2.104.702.0 64-bit (April 2022)), we are now encountering an "A cyclic reference was encountered during evaluation" exception when refreshing the data from a MySQL database:     We've traced the issue to the use of a Parameter named `Schema` in the Power Query as follows: let Source = MySQL.Database(Server, Database, [ReturnSingleDatabase=true]), <query name> = Source{[Schema=Schema,Item="<table name>"]}[Data] in <query name>   A refresh of the data preview in the Power Query Editor works without any issues, it is only when we attempt to reload the data in the Power BI report that the exception is generated.   The issue is with the following specific snippet in the query:   Schema=Schema     The solution / workaround is to rename the Parameter to something other than "Schema".  For example, the reload works as it did before if we change the query to use a new Parameter called "SourceSchema": let Source = MySQL.Database(Server, Database, [ReturnSingleDatabase=true]), <query name> = Source{[Schema=SourceSchema,Item="<table name>"]}[Data] in <query name>   Whilst the use of a Parameter name which collides with a Power Query attribute name isn't a good principal to adopt, the concern is that this code has been working for months and is only generating an exception with the new version of Power BI Desktop.   The concern is that other users may have adopted this convention in their own Power BI reports and will therefore encoutner the same issue where: The source of the problem is not straightforward to isolate; Issues with the use of a Parameter called "Schema" in this context is not immediately apparent in the the Power Query Editor where data preview refresh works without any issues.  It only surfaces when you reload / refresh the data in the Power BI report itself; There is a risk that this behaviour could propagate into the Power BI Service where report refreshes could being to fail.  This would create a significant operaitonal issue where Power BI reports are being used in production. ... View more

Hi,   We have a report with drill through enabled from matrix cells : https://msit.powerbi.com/groups/6ffc50ad-e19a-4e3d-ad2d-488ffefedfec/reports/045b7ec5-c7c8-47ae-bba8-30c243b15524/ReportSection645d67fd1bc6984bb019  . It is working fine until this morning. The right click menu is not pop up any more. Failed on both edge and chrome. The report is working fine on local desktop. Also tried to republish the report still has the same issue. Please help to check what could be wrong.   Thanks, -Yan ... View more

I'm trying to deploy a property dataCoverageDefinition in my semantic model's partition. I need this for a hybrid model setup, where one partition is set to direct query, and the other one to Import.   According to the documentation, an additional property needs to be deployed to the directquery partition to make sure Power BI does not perform any unnecessary queries in direct query mode. https://learn.microsoft.com/en-us/analysis-services/tom/table-partitions?view=asallproducts-allversions   Compatibility has been set to 1604. Property has been set into the DirectQuery partition. Script runs succesfully, but the property cannot be found when re-opening the script of the datamodel. When reviewing the performance analyzer, Power BI still performs unnecessary direct queries when the requested data is clearly data stored in the import partition. ... View more

As of 3/29/2022, there is a bug with the row banding for matrices in the Power BI service.  The banded colors are not lining up correctly. ... View more

Hi Fabric Community, how do we increase the session timeout on viewing a paginated report in power bi service which by default is set to display "Your session has expired" after 10 minutes of inactivity. Any help would be appreciated. Thanks. ... View more

Classic workspace - Datsets are not visible after the new look upgrade done by microsoft.   There is no dataset option in the filters menu in the new experience   View post on imgur.com   ... View more