Issues

iannedrs

I'm using Power BI Desktop on a daily basis because I have four dashboards that I update everyday (new data daily). Last Monday, April 15, I was able to access my files in the morning. Come afternoon when I was about to update another dashboard, I suddenly got this error: There is an error in XML document (1, 1). When I tried opening all my Power BI files, and even creating a new one, I still get the same error. I searched and most suggested to just reinstall Power BI, or delete the App Cache. I did both, but the error still persists. The weird thing now is Power BI is working fine (with my files) using a different user in my laptop: i.e. I was using my own user account (admin access) and my Power BI app is having an error, but when I logged on to a different user in the same laptop, Power BI is working well. How can I fix this issue? It's quite a hassle now logging in and out of my laptop user account just to use Power BI. Thanks in advance for the help!

rdnguyen

This seems to happen to existing dataflow when change saving is attemped. New dataflow is saved without any issue

frankwangtakumi

All my published to web URL stop working since yesterday night, anyone knows how it be?

brus4814

Hi I have connected sharepoint file as one of the data sources to my pbix file. The file is expected to have dynamic columns. I'm using parameterization to bring those dynamic columns into my table visuals on the report. Report refresh works fine in desktop app and was working fine in power bi service until the April release. Refresh fails with this error in service: Data source errorThe 'xxxx' column does not exist in the rowset. Table: A. Could I please report this as a bug, thanks

fantasea · ‎04-11-2024

Hi , I cannot use most of the quick measures. Once I choose a calcultion, say percentage difference, after several minutes of waiting, it showed "Something went wrong, an error occurred while rendering the report". then the app crashed. I've tried to re-start the laptop and re-install the app but both not helping. Could you help with that? Thank you.

BLSR09 · ‎04-09-2024

Hi, I am unable to launch Power Automation page from Power BI Desktop or Service. My colleague also is facing the same issue. The page just shows as loading but it never loads and it's been more than 3 days we are having this issue. I am not sure if it is a bug or our power bi desktop version needs an update. We are using March 2024 version. Please help!

nouraali369 · ‎04-01-2024

Hello, I am trying to get data from a BigQuery view in a specific dataset, using service account authentication. I am able to preview the view in BigQuery console, which means the underneath view query is working fine. However, when i try to get this view into power bi using import mode, it gives below error: View_LogicalCS_CH_Relationship (3) Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [42000] [Microsoft][BigQuery] (70) Invalid query: Array index 2 is out of bounds (overflow). ' I have also tried the direct query mode, and when i try to build any visual it gives same error is there anything i need to configure ? Would appreciate your support. Thanks

kishoree · ‎03-26-2024

Facing server issues while trying to copy a Power BI visual using the 'Copy Visual' option from a published report on Power BI Service. Below attached is the screenshot of the error message:

ffirda99 · ‎03-24-2024

Hi, Can anyone help me, I cant sign to find out the problem in my Appended table. Thankyou in advance!

lFahadl · ‎03-16-2024

Hello, I hope good health I have a problem with the app working after the February update Feedback Type: Frown (Error) Timestamp: 2024-03-17T06:31:58.0559452Z Local Time: 2024-03-17T09:31:58.0559452+03:00 Session ID: 31924743-56b1-4b96-aa41-318f4fc03cd9 Release: February 2024 Product Version: 2.126.1261.0 (24.02) (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(IList`1 libraryExtensions, IApplicationPaths applicationPaths, ILibraryProvider internalProvider, ILibraryProvider remoteExtensionsProvider) at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHostManager.RegisterAndActivateUiExtensionHost(UiExtensionHost uiExtensionHost, IList`1 libraryExtensions, 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.126.1261.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.22000.0 (x64 ar-SA) CLR Version: 4.8 or later [Release Number = 533325] Peak Virtual Memory: 70.4 GB Private Memory: 492 MB Peak Working Set: 1.08 GB IE Version: 11.1.22000.0 User ID: c86ff492-468e-4f30-a69b-88fc2cbde24b 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_backstageUI PBI_setLabelOnExportPdf PBI_dynamicFormatString PBI_oneDriveSave PBI_oneDriveShare PBI_newCard PBI_buttonSlicerAuthoring PBI_generateMeasureDescriptionsButton Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_b2bExternalDatasetSharing PBI_enhancedTooltips PBI_angularRls PBI_onObject PBI_useModernPublishDialogs PBI_gitIntegration PBI_tmdlInDataset PBI_EimLessElevatedUser PBI_modelExplorer PBI_daxQueryView PBI_aiNarrativesVisual PBI_qnaImproveLsdlCopilot PBI_visualCalculationsAuthoring Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BI

Omar_Osman · ‎03-14-2024

Unsuccessful connect to SQL Endpoint using Node.js and tedious or mssql npm package Software versions tedious: "^17.0.0" Node.js:18.17.1 var Connection = require("tedious").Connection; var config = { server: //"****.datawarehouse.pbidedicated.windows.net", "*****.datawarehouse.fabric.microsoft.com", database: "Gold", options: { encrypt: true, trustServerCertificate: false, }, authentication: { //type: "azure-active-directory-password", type: "azure-active-directory-service-principal-secret", options: { //userName: "@.onmicrosoft.com", //password: "****", clientId: "****", tenantId: "****", clientSecret: "****", }, }, }; var connection = new Connection(config); connection.connect((err) => { if (err) { console.log("Connection Failed"); throw err; } console.log("Custom connection Succeeded"); connection.close(); }); Problem description Got an error message when connecting to Microsoft Fabric SQL Endpoint ConnectionError: Connection lost - socket hang up {at Connection.socketError ... node_modules\tedious\lib\connection.js:1344:26) code: 'ESOCKET' } Note:that the connection works when using the powershell with the same parameters. Install-Module -Name SqlServer $connectionString = "Server=$server;Database=$database;User Id=$username;Password=$password;Authentication=Active Directory Password;Encrypt=True;TrustServerCertificate=False;" # Create a SQL connection $sqlConnection = New-Object System.Data.SqlClient.SqlConnection $sqlConnection.ConnectionString = $connectionString Best Regards,

lucilehan · ‎03-13-2024

Is there a known issue on the Power BI server today? We have a rucurring report subscription scheduled to be sent out 9:AM EST every day. There hadn't been any changes to the semantic model / subscription settings, but there was a significant delay today (3hrs) and wanted to to know if this is a known issue. Also got some end-user feedback that they are noticing slower performance.

mehalam · ‎03-08-2024

We are importing ADX(kusto) dataset in Power BI using direct query mode. Since we scaled up the cpu count in ADX, the visuals got crashed in Power BI desktop/Service and got the below error. Web.Contents failed to get contents from 'https://(Clustername.location.)kusto.windows.net/v1/rest/query?db=(database)&csl=.show%20version' (520): InternalServiceError But the query and tables are working fine in ADX, only in Power BI we are facing the issue. For every refresh, Some of the visuals are working and some of the visuals are crashing. Its soo weird and we can't recoginze the rootcause of this issue. Even I tried to create a new Power BI report using the ADX connection string, i got the same issue. once we scale down and return back to the previous state of cpu count. The reports are coming up and working fine. Due to the performance issue, we are in need of scaling up the cpu count in ADX which results in crashing power bi reports. Need help to resolve this issue!

HSpeelman · ‎03-06-2024

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.

daniog · ‎03-04-2024

Hey, I'm working with SharePoint files, and I'm having an issue. All the files are combined into one, but this particular file keeps loading and I can't seem to access it for editing. I've checked if background data is disabled, but that doesn't seem to be the problem. I'm not sure what's going on. I've been using this project for several months, and it's the first time I've encountered this issue with the preview not working. Not even an error message appears. I have this project set up with automatic daily refresh, and it's quite perplexing. While the web version is functioning properly and I can see the updated data online, the Power BI Desktop version seems completely frozen. I'm unable to update the data there because the refresh function isn't working, making it impossible for me to see or edit the data on my desktop.

Alshaimaa · ‎03-04-2024

When I try to open the application on my desktop, I get the message "An error occurred" Even though I updated it to the latest version and the Windows system was also updated, the problem still exists and I do not know what the solution is. I hope someone will help me.

c_sagar_mehta · ‎03-03-2024

Facing Issue trying to open published file in Power BI Desktop App is opening fine on the web but when I click on Edit in Power Bi Desktop facing issue as below Feedback Type: Frown (Error) Timestamp: 2024-03-04T06:19:13.1052558Z Local Time: 2024-03-04T10:19:13.1052558+04:00 Session ID: 417f4570-031a-4a1a-97fa-db871020d451 Release: September 2023 Product Version: 2.121.1642.0 (23.09) (x64) Stack Trace: Microsoft.PowerBI.Client.Windows.Storage.FileOpenException at Microsoft.PowerBI.Client.Windows.SSRSService.SSRSPbixFile.<Open>d__32.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.BiPackageOperationHandler.<LoadPbiFile>d__12.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.CurrentFileManager.<ExecuteAndHandleFileOpenErrors>d__35.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.CurrentFileManager.<>c__DisplayClass23_0.<<OpenFileAndSetAsCurrent>b__1>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.<>c__DisplayClass13_0`1.<<BlockUIAndRun>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.WaitOnUIThreadForTaskCompletion[T](Task`1 task) at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.BlockUIAndRun[T](Func`1 asyncMethod) at Microsoft.PowerBI.Client.Windows.Services.CurrentFileManager.OpenFileAndSetAsCurrent(IPowerBIWindowService windowService, IPowerBIFile fileToOpen, Nullable`1 entryPoint) at Microsoft.PowerBI.Client.Windows.Services.FileOperationUIHandler.<OpenFileInternal>d__44.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Program.<>c__DisplayClass6_2.<<RunApplication>b__7>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.MainWindow.<<ActivateMainWindow>b__116_1>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext() PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.121.1642.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.SSRSService.SSRSPbixFile+<Open>d__32","Error":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenException","MethodDef":"MoveNext","ErrorOffset":"525","ErrorCode":"Other"} OS Version: Microsoft Windows NT 10.0.22621.0 (x64 en-US) CLR Version: 4.8 or later [Release Number = 533320] Peak Virtual Memory: 70 GB Private Memory: 511 MB Peak Working Set: 1.06 GB IE Version: 11.1.22621.0 User ID: 1f36730b-784d-491f-84d3-e509a7799129 Workbook Package Info: 1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False. Telemetry Enabled: True Model Default Mode: Empty Model Version: PowerBI_V1 Enabled Preview Features: PBI_scorecardVisual PBI_NlToDax PBI_setLabelOnExportPdf PBI_dynamicFormatString Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_b2bExternalDatasetSharing PBI_enhancedTooltips PBI_sparklines PBI_fieldParametersSuperSwitch PBI_angularRls PBI_onObject PBI_oneDriveSave PBI_oneDriveShare PBI_gitIntegration PBI_newCard Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BI Report Server, Power BI

GINMED · ‎02-28-2024

Hi, 1.we have the problem to add additional time to refresh data and other users e-mail to getting error message . 2.and the same problem to add users in Row Level Security Data source info : Please help to find the solution?

garich · ‎02-27-2024

I am constructing a report where I aim to embed Paginated Reports in Power BI Desktop. How can I automate the process of setting the data source to fetch it from the correct environment (DEV, TEST, PROD)/workspace for these Paginated Reports? Currently, I need to manually change all tabs that contain a paginated report into the right environment. Ellipsis > Edit It automatically references the DEV and I need to manually set it to TEST.

Peerapholk · ‎02-25-2024

Normally it take 30 minutes to refresh but on saturday, sunday it takes up to 3-4 hours. Is there any power bi service issue? or any idea to investigate the issue ?

Share your ideas and vote for future features

Error: There is an error in XML document (1, 1).

Power BI Service - NetworkConnectionIssue when saving change to dataflow

Publish to web url not working

Data Source error: Column not found in rowset

cannot use quick measure

POWER AUTOMATION IN POWER BI DESKTOP OR POWER BI SERVICE NOT WORKING

Get BigQuery Data

Server Issue with 'Copy Visual' Option in Power BI Service

Couldn't Authenticate - Appended

Power BI Desktop don't work

ERROR - Connect to SQL Endpoint using Node.js and tedious npm package.

Power BI Server Issue - Subscription and Report Performance

Web content failed to get content error in Power BI

TOM property not deployed to Semantic model (dataCoverageDefinition) - Hybrid table setup

refresh preview is not working - I cannot edit my data

A technical problem in Power BI Desktop

Facing Issue trying to open published file in Power BI Desktop

RLS and Refresh data=> You can't use invalid or duplicate emails.

Make source of Paginated Report automatically change when deployed to a new environment

Power BI Very Slow Refresh !!

Helpful resources

Error could not copy visual

Power BI semantic model account sign in for every ...

When `select all` is used, then slicer doesn't res...

published report with PERSONALIZE enabled - the sc...

Power BI desktop version