Issues - Page 127

owenv · ‎04-12-2022

We have a dashboard that is published publicly and used daily. It was working yesterday but not today. No one has made any changes in weeks. The dashboard within the workspace still works ok. I've tried rebuplishing but with no effect. Any idea what's going on? I've checked other public dashboards and they're fine. This is all that I see at the top of the page:

ksaurabh05 · ‎04-11-2022

Hey Power BI Team, Reports are showing blank for number of user, but its working fine for same user before 7 days, Nothing change, any Role or Power BI report. Everything is same. Its happening for all the Report in application. Kindly help us here, how we can get rid off this issue.

isabelmiranda · ‎04-07-2022

It is the same issue reported by another user in: https://community.powerbi.com/t5/Issues/Not-receiving-email-notification-when-someone-requests-access/idi-p/154711 However, the solution presented there doesn't work in the new workspaces. Anyone know what to do?

Venky_008 · ‎04-07-2022

Dear Team, I have removed existing published PBIx on prod but I related immediately and I have not published the app. Can you please help to restore the deleted PBIx so that my link would not be changed which is being widely used by my stakeholders? Looking forward to your immediate support. Regards Venky

victorviro · ‎04-07-2022

When I set a custom axis range in a columns plot, the axis zoom slider does not work. However, in other visualizations (line plot) it works. If I do not set a custom axis range, it works.

Anonymous · ‎04-06-2022

Hello, kindly help me with this issue please: I am not able to enter new tables via Home -> 'Enter data' icon on any view (report view, data view, power query view). Power BI just freezes (can't click anywhere) right after pressing Load button, and I must shut it down with task admin, and reopen it again. This happens for every pbix with a data model already created except for new, blank ones. Version: 2.103.881.0 64-bit (March 2022).

bluelagoon · ‎04-06-2022

Power BI Report is refreshed in PBI services and the following error constantly occurs: DataSource.Error: <pii>invalid query locator</pii>. <pii>{[...]}</pii>. ;invalid query locator. The exception was raised by the IDbCommand interface. Table: I have downloaded the report, then refreshed the preview and republished it to PBI Services, hoever this error keeps coming back. The report refreshes on the desktop version with no problem

zjesberger · ‎04-05-2022

I am attempting to create a composite model using 2 Power BI Datasets. I am following the directions on the Power BI documentation about connecting to the Dataset with a Live connection, then pressing "Make Changes to this Model" to change the connection to Direct Query. When I try to do that, I receive an error pop-up with "Error 400 bad request". What am I doing wrong? I have enabled the preview feature of DQ/Composite Models for Power BI datasets. Here is the full error message i get: Feedback Type: Frown (Error) Timestamp: 2022-04-05T23:34:48.4132145Z Local Time: 2022-04-05T19:34:48.4132145-04:00 Session ID: b904b147-a3ac-4cca-84b9-808b23bc1382 Release: March 2022 Product Version: 2.103.881.0 (22.03) (x64) Stack Trace: Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException at Microsoft.AnalysisServices.AdomdClient.ASAzureUtility.ThrowConnectionException(WebException ex, AsInstanceType asInstanceType) at Microsoft.AnalysisServices.AdomdClient.HttpStream.GetResponseStream() at Microsoft.AnalysisServices.AdomdClient.HttpStream.GetResponseDataType() at Microsoft.AnalysisServices.AdomdClient.CompressedStream.GetResponseDataType() at Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest(Boolean useBinaryXml) at Microsoft.AnalysisServices.AdomdClient.XmlaClient.CreateSession(ListDictionary properties, Boolean sendNamespaceCompatibility, String sessionToken) at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.CreateSession(Boolean sendNamespaceCompatibility) at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() at Microsoft.PowerBI.Client.Windows.LiveConnectHelpers.AnalysisServices.AdomdQueryExecutor.OpenConnectionAndExecute[T](IAdomdConnectionPool connectionPool, IAdomdConnectionFactory connectionFactory, String connectionString, QueryExecutionOptions executionOptions, IPowerBITelemetryService telemetry, Func`2 execute) at Microsoft.PowerBI.Client.Windows.LiveConnectHelpers.AnalysisServices.ASLiveExternalService.ExecuteCommand[T](String name, Func`2 execute) at Microsoft.PowerBI.Client.Windows.LiveConnectHelpers.PowerBIService.PowerBIServiceLiveConnectionProperties.GetDatabasesAndCubes() at Microsoft.PowerBI.Client.Windows.LiveConnectHelpers.ProxyModelConnectionCompleter.CompleteConnectionPropertiesIfNecessary(ILiveConnectionProperties connectionProperties, IPowerBIWindowService windowService) at Microsoft.PowerBI.Client.Windows.AnalysisServices.LiveConnectToLocalDatabaseConverter.ShowNavigatorAndUpdateSelection(Report report, Query query, ILiveConnectionProperties liveConnectionProperties, IExceptionHandler exceptionHandler, IMinervaModalDialogManager minervaModalDialogManager, IPowerBIWindowService windowService, Func`1 applyChanges, ModelObject[] modelObjects) at Microsoft.PowerBI.Client.Windows.AnalysisServices.LiveConnectToLocalDatabaseConverter.<Convert>d__8.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.Commands.ApplicationCommands.DataImportCommands.<TryConvertLiveConnectToProxyModel>d__56.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.103.881.0","ModuleName":"Microsoft.PowerBI.AdomdClient.dll","Component":"Microsoft.AnalysisServices.AdomdClient.ASAzureUtility","Error":"Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException","MethodDef":"ThrowConnectionException","ErrorOffset":"430"} InnerException0.Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Microsoft.AnalysisServices.AdomdClient.HttpRequestResponseExtensions.GetResponseWithErrorHandling(HttpWebRequest httpWebRequest, Boolean isPbiPremium) at Microsoft.AnalysisServices.AdomdClient.HttpStream.WaitForAndUpdateHttpResponseContainingXmlaPayload() at Microsoft.AnalysisServices.AdomdClient.HttpStream.GetResponseStream() OS Version: Microsoft Windows NT 10.0.19043.0 (x64 en-US) CLR Version: 4.7 or later [Release Number = 528372] Peak Virtual Memory: 102 GB Private Memory: 484 MB Peak Working Set: 725 MB IE Version: 11.789.19041.0 User ID: 18b069b0-0528-4477-93e2-02b4af38728d Workbook Package Info: 1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True AS Live Connection: True Enabled Preview Features: PBI_compositeModelsOverAS PBI_mobileAuthoringFormattingUI PBI_useModernFormatPane PBI_sparklines PBI_scorecardVisual Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_azureMapVisual PBI_dataPointLassoSelect PBI_dynamicParameters PBI_enhancedTooltips PBI_lineChartError Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 150% Supported Services: Power BI

KFPBI · ‎04-05-2022

I have a connection to Sharepoint. It refreshes perfectly from desktop, but when I try to refresh online it says the following: Underlying error code: -2147467259 Underlying error message: SharePoint: Request failed: https://kidsfirstservices-my.sharepoint.com/personal/shraga_kidsfirstservices_onmicrosoft_com/Documents/Desktop/PowerBi/New folder/NYNM ERA/2021/N822310003.20211210.NYNM.E28339.20211214214951.5010_xlsx/_api/contextinfo DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.DataSourceKind: SharePoint Microsoft.Data.Mashup.ValueError.DataSourcePath: https://kidsfirstservices-my.sharepoint.com/personal/shraga_kidsfirstservices_onmicrosoft_com Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error Microsoft.Data.Mashup.ValueError.SPRequestGuid: d8d430a0-e0e4-1000-acc0-72897c480d6c Cluster URI: WABI-US-NORTH-CENTRAL-G-PRIMARY-redirect.analysis.windows.net Activity ID: b427f4e0-bceb-4f69-8338-688c44150a19 Request ID: caf70869-03fc-9a57-4227-2f2e5d9aead6 Time: 2022-04-05 19:08:23Z Why is that?

tcburge3 · ‎04-05-2022

I have a powerbi dashboard posted to a created workspace. When I try to view the report, I get stuck on the screen that says "Loading your report" (first screenshot), and then after a few minutes I get the error in the second screenshot. Has anyone else ran into this issue? Is there a known workaround, or avenue from getting support from the PowerBI team? I use this dsahboard for business purposes so need to get access to it as soon as possible. Thanks!

airwolf39 · ‎04-05-2022

Hi all, This bug is repeatable across all of my team's machines and BIs. It is a HUGE headache and causes a massive strain on our work. We are all on the March 2022 version. Scenario: 1. We want to make changes to the theme. The first time we open it, everything is fine. But if we close and repeon, GREY BOX! Cant see anything! 2. We want to change column settings under 'Cell elements'. The first time we open it, everything is fine. But if we close and repeon, GREY BOX! Cant see anything! This is a huge huge issue for us. Please advise

tsalutski · ‎04-04-2022

Hi team, Is this a bug? Why is it showing this error message? My workspace is premium and it should allow Dataset more than 1 GB. thanks!

Aladin46 · ‎04-04-2022

Hi everybody, I've got a published report on a Premium PowerBI Workspace, and everything's doing fine there. I recently set-up a PowerAutomate flow to send recurring printouts to my peers using this published dashboard. Here again the flow is working just fine. My issue is that my donuts charts (PayPal KPI donut chart more precisely) aren't printed: I only get a grey area where the chart should be - see attached snapshot. All the other charts, curves etc. surrounding those charts in the same page are displayed correctly. To be thourough, those donut charts are also printing perfectly when I'm exporting a pdf from my desktop version. So the issue is somewhere between Power Automate and my published report on the Premium workspace. Any idea how to solve this issue? I find it strange that while everything else is doing fine only those donuts aren't showing up and if possible I'll like to keep them as the Power Automate process is just the icing on the cake: reports have already been shared for months in the workspace and people are now used to the existing format. Would be nice to get the same pdf automated... Thanks, Aladin

sarah127583 · ‎04-04-2022

Hi There, We have noticed a weird phenomenon that has started occurring when we search for a report parameter in one of our paginated reports. The list of available values in question are 5 character codes (which are a mixture of letters & numbers) followed by a string (eg. 2S407 - 2Examplename). If the code/ string starts with either a 1, 2 or 3, the search function works as expected. We get a minimised list of values which match the format and can select the correct parameter and run the report. If, however, we start the search with a number greater that 3 – or a letter, a minimised list of matching values does present itself but when it is clicked the “Loading Report” screen temporarily pops up before the parameter clears itself from selection. This is an issue that has only presented itself within the past two weeks and worked prior to that. It is creating unhappy users who now need to scroll through hundreds of options before finding the selection they require - is there something that can be done? Thanks!

ReinhardtScheun · ‎04-04-2022

Hi There, I have a few dashboards that were published to an app. We have made changes to the dashboards and the new layouts are not being updated when updating the app. We have removed the app and tried again. Removed the dashboards and tried again. Unpublished the app and republsihed it, but it is just holding on to the original dashboard layout. After that, I added another tile and updated the dashboard and now only that tile is showing. Its like there is a gap of changes that the app is just not picking up. We have gone and rebuilt the whoel workspace in a new workspace and the dashboards are only bringing in the header text tiles we built and not the pinned tiles from the reports. The dashboard in the workspace looks perfect. Workspace is in Premium capacity

Yannis_exe · ‎04-02-2022

Hello, The last four days all our published reports need 1 hour (or in some cases a bit more) to be updated from the time that the dataset is refreshed. Note that all these reports are in import mode (most of these have a minimal dataset i.e. 3col x 10 rows) and run for almost a year now - up until four days ago as soon as the dataset was refreshed the published reports refreshed almost instantaneously. I'm aware of "the data is cached for one hour from the time it is retrieved" from Publish to web from Power BI but the next paragraph also states " Data refreshes are automatically reflected in your embedded report or visual. When data is refreshed for an import data model in the Power BI service, the service clears the data cache, making data update quickly" which was also explained analytically in a Microsoft Power BI Blog from 23 October, 2020 "Updates to Power BI Publish to web for better public reporting": "Now, we’re rolling out a change to help make data updates work better. When your import dataset in Power BI refreshes, we’ll clear the publish to web cache. The updated data for will load once the cache entry is cleared, which is often very soon after the refresh occurs. For very popular embed codes or embed codes that generate many queries, it’s still possible to take up to 60 minutes to see the updated data." So, for the last four days it seems that something is not working properly and PBI Service don't clear the Publisht to Web Cache when the import dataset is refreshed. Have anyone else experienced the same issue?

glopreto · ‎04-01-2022

Data source error: DataSource.Error: <pii>ODBC: ERROR [22007] [Microsoft][Support] (40490) Invalid date, time or timestamp value.</pii>. DataSourceKind = <pii>Snowflake</pii>. DataSourcePath = <pii>ga66160.us-east-1.snowflakecomputing.com;BI_WH</pii>. OdbcErrors = <pii>#table({"SQLState", "NativeError", "Message"}, {})</pii>. . The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Finance MRR Transactions. Cluster URI: WABI-US-CENTRAL-A-PRIMARY-redirect.analysis.windows.net Activity ID: Request ID: Time: 2022-04-01 08:16:52Z Desktop is fine, problem is only when trying to refresh service. (The table changes in every try).

Kgarrett · ‎04-01-2022

IN NEED OF HELP!! Recently, I've had an issue when I trying to refresh data from ODBC connection and an ON-Premise SQL Server Database. I can get both to refresh through the Gateway Cluster that I've established for each datasource, but when I try to use a dataset that contains both sources I get an error...Does anyone have any idea why this might be? I've crossed my T's and dotted by i's on the privacy settings that match the file and datasource credentials but still have trouble.. I'm able to connect to the HIVE Datasource Gateway Cluster via CData Power BI ApacheHive I also established the refresh will perform if it is connected to the source. I also am able to connect to the App04; Methasoft data source which, comes from SQL Server Ialso established that the refresh will perform if its connected to the source. The problem that I am now facing is that when I try to combine data from the two sources I receive a MashUpError, which I believe may be related to the data encryption error that the Power BI Online Service is having with of one datasource from another

Sviatoslav · ‎04-01-2022

Using both PBI desctop and web versions. That issue didn't happen before. Here is the full text of the error: Failed to update data source credentials: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) Hide details Activity ID: 85f18e28-a110-4ece-962f-76facf84b674 Request ID: e79b89b2-f6c2-2959-17e3-f532a3095ed9 Status code: 400 Time: Fri Apr 01 2022 16:24:33 GMT+0300 (GMT+03:00) Service version: 13.0.17952.44 Client version: 2203.3.10669-train Cluster URI: can't post with this url Thing is: the credentials are the same as the ones used to connect to server on the downloaded report. They work in the downloaded version but don't work in the web. We didn't apply any IP restrictions to credentials yet, so that couldn't be the issue.

AGLourenco · ‎03-31-2022

When we copy-paste a slicer, if we change the field on the copied slicer only that slicer field is changed. The issue arises when the slicer is on a group with a label, if we select the group and copy-paste it, we can change the text on the label and it goes ok, but if we change the field on the slicer, the 2 slicers are changed. Let's use the "Prod Family" group If we select the group and copy-paste We change the group name and individual objects inside the group, as well as the text on the label. All ok. As normal, the field is still the "Product Family". But when we change it to "Product Category" Then the "original" slicer is also changed As a test, we duplicated again the original group and deleted the field from the slicer just to see again the same behavior. Using Version: 2.103.881.0 64-bit from the Store. António.

Share your ideas and vote for future features

Public link broken

Power BI Reports are showing Blank for Few users

Admin/owner isn't receiving e-mail requests for access

Issue - Restore the deleted PBIx

Axis zoom slider does not work in columns plot with custom axis range

Can't enter new tables via Enter data option

invalid query locator

Composite Model Error 400

Unable to connect to the data source undefined.

PowerBI stuck on "Loading your repot" on published dashboard

BUG!! - Grey Boxes?!

Problem with refresh of the data using Gateway.

Print PowerBI report from Power Automate

Paginated Report Search Function No Longer Working

Dashboard not updating new layout when updating app

Publish to Web Issue - Takes too long for published reports to refresh (sometimes over an hour)

Service Power BI Refresh error - Snowflake

Standard Gateway ODBC Error Connection & SQL Serv

Failed to update data source credentials

Copy-paste of a group selection makes slicer "duplicate" and changes propagate trough copied groups

Helpful resources

Publish to web url not working

Slicer bug?

TypeConversionFailure when not trying to convert

filter pane values in service are showing in black...

Wrong french translation for "reader" permission