Issues

BlueScr33n

It seems recently our navigation pane in our application has the expand/collapse caret on the left side and on it's own line. We verified this is happening in our other reporting apps we have. Is this a known issue? Not sure if this is from a recent update. We didn't make any changes on our side. When we edit the app it looks normal- pic of the app edit showing the expand/collapse caret on the right on the same line-

mark-alford · ‎05-22-2023

Unable to refresh data in the datamart, following error. We couldn't get your datamart's updated schema The datamart data is invalid Activity ID: f817febf-3293-4b66-a64d-0ac1c9987419 Request ID: b247eba4-d0b6-440d-8000-e8d6fe3d6459 Correlation ID: 0fefd113-83ba-4f76-c8d0-6d4464a511b2 Status code: 400 Time: Mon May 22 2023 23:16:52 GMT+0100 (British Summer Time) Service version: 13.0.20726.71 Client version: 2305.3.13975-train Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/

Cees · ‎05-16-2023

Hello, When creating a new or changing a current working dataflow with a Exasol certified connector. The refresh fails with "Expression.Error: The import Exasol.Database matches no exports. Did you miss a module reference?". It does work in the designer mode. This is preventing us from maintenance and new development using our datawarehouse. Please give us advice on solving this problem. Kind Regards, Cees van Leuveren Requested on,Dataflow name,Dataflow refresh status,Table name,Partition name,Refresh status,Start time,End time,Duration,Rows processed,Bytes processed (KB),Max commit (KB),Processor Time,Wait time,Compute engine,Error, 2023-05-16 10:04:49,test,Failed,VD_CALENDAR,NA,Failed,2023-05-16 10:04:49,2023-05-16 10:04:50,00:00:00.3770,NA,NA,NA,NA,NA,NA,Error: Expression.Error: The import Exasol.Database matches no exports. Did you miss a module reference? . RootActivityId = 291a1fbe-19fa-4694-bb31-dd4c00b6ddc4.Param1 = Expression.Error: The import Exasol.Database matches no exports. Did you miss a module reference? Request ID: c85810c6-b3f6-90c9-7a5c-ae4778ff3afd.

ewilliams0405 · ‎05-17-2023

The dynamic format thousands (k) when displayed with a decimal appears correctly in both data labels and tables. But with no decimal the dynamic format for thousands only appears correctly in table visuals. The respective values do display in data labels. The display unit are set to none. Format: SWITCH(TRUE(), SELECTEDVALUE(ValueOrQtySelector[ValueQty_Ind],"Val")="Val" && ABS([Sales_Less_Returns_YTD]) < 100000, "$#,##0;($#,##0)" ,SELECTEDVALUE(ValueOrQtySelector[ValueQty_Ind],"Val")="Val" && ABS([Sales_Less_Returns_YTD]) < 1000000, "$#,0,.K"//"\$#,0,.k;(\$#,0,.k)" ,SELECTEDVALUE(ValueOrQtySelector[ValueQty_Ind],"Val")="Val" && ABS([Sales_Less_Returns_YTD]) >= 1000000, "\$#,0,,.0M;(\$#,0,,.0M)" ,SELECTEDVALUE(ValueOrQtySelector[ValueQty_Ind],"Val")<>"Val" && ABS([Sales_Less_Returns_YTD]) < 100000, "#,##0;(#,##0)" ,SELECTEDVALUE(ValueOrQtySelector[ValueQty_Ind],"Val")<>"Val" && ABS([Sales_Less_Returns_YTD]) < 1000000, "\#,0,.k;(\#,0,.k)" ,SELECTEDVALUE(ValueOrQtySelector[ValueQty_Ind],"Val")<>"Val" && ABS([Sales_Less_Returns_YTD]) >= 1000000, "\#,0,,.0M;(\#,0,,.0M)" ,"#,0;(#,0)") I believe this is a bug in the dynamic formating as no thousands format appears to work and it only appears to an issue when used in data labels. It would be nice to turn off the dynamic formating to display the base value for validation purposes or in visuals where the format may not be required.

GWhite · ‎05-06-2023

Hi there! I have one that is stumping me and cannot find documentation to correct. In the 2.116.966.0 64-bit (April 2023) version of desktop, when I go to make any changes to my options when I select OK it grays out and does not engage or finalize the request. I can only top cancel to get back to the work. I can only assume that this is something within my setup that is blocking the changes, but I cannot find the solution. Any help is greatly appreciated!

Helm · ‎04-25-2023

Hi PowerBI Users I currently have an issue connecting to my PowerBI datasets using Excel. When going through either Data -> Insert Data -> Power Platform -> PowerBI Dataset or Insert -> Pivot table -> PowerBI Dataset the pane opens up in right side of the screen, however the screen is completely white as seen in the attached image. Previously I haven't had any issues with connecting to PowerBI datasets, but all of a sudden it goes completely white. The same error happens when my colleagues try to connect to datasets. It is possible to connect going through the PowerBI portal and pressing "Analyze in Excel", however this is not really something I can make my colleagues use.

Mati · ‎04-13-2023

Dynamic format strings (preview mode) is not working properly. Only simple formating is working fine but a little more advanced is not displaying labels in proper way. For example it is impossible to get proper string for abslute value and percentage growth of this value in one string. Additionally it is working differently in different type of visuals but everywhere it is displayed in wrong way.

Brains_86 · ‎05-09-2023

Hi all, I have installed the latest on premises gateway and if I refresh online everything works smooth. Except when I set the scheduled refresh on. I get this error: Data source error: {"error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","pbi.error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","parameters":{},"details":[],"exceptionCulprit":1}}} Table: factuur_tags_tag. Cluster URI: WABI-WEST-EUROPE-E-PRIMARY-redirect.analysis.windows.net Activity ID: 9250da6e-7976-4d65-97e7-6ea897359b6a Request ID: 3d42cb7b-cb2d-45d7-a1f2-a2dc31ee864f Time: 2023-05-10 05:16:59Z alle datasets are good and tested. As when I hit the refresh button manually the refresh is good. Only when I want to schedule I get this error. Van anybody help me further?

Quiny_Harl · ‎02-01-2023

When a dimension field parameter is used in a matrix visual that has more than one expanadable rows, the visual is collapsed to the level of the field parameter whenever I make a selection from the field parameter slicer. Consider the following matrix, where COST_PERIOD is the dynamic field and TEST PARAMETER is the slicer that controls that field: As you can see, the table is expanded to tge level of Vendor Name. Now, when I make another selection fron the TEST PARAMETER slicer, the table is automatically collapsed to the level of the COST_PERIOD field and I have to expand everything all over again:

gkir · ‎05-08-2023

Starting from 5/7/2023 if a user select value from the matrix visual in power bi service everything in the matrix change backgorund. How it was and how it is in the desktop: And this is how it looks in the service: Please return to the previous version like in the desktop or create options to change backgorund for unselected values...

Joshrodgers123 · ‎02-22-2023

As of 2/20, the Power BI Release Plan report has failed to refresh. This is occuring across multiple users. We are using the out-of-the-box Microsoft provided app/report: Connect to the Power BI Release Plan report - Power BI | Microsoft Learn We are getting the below error: DataSource.Error: <ccon>Web.Contents failed to get contents from 'https://docs.microsoft.com/api/search/rss?locale=en-us&$filter=scopes%2Fany(t%3A%20t%20eq%20%27power-bi-191%27)' (400): Bad Request. DataSourceKind = Web. DataSourcePath = https://docs.microsoft.com/api/search/rss. Url = https://docs.microsoft.com/api/search/rss?locale=en-us&$filter=scopes%2Fany(t%3A%20t%20eq%20%27power-bi-191%27). </ccon>. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Features.Cluster URI:WABI-US-WEST2-redirect.analysis.windows.netActivity ID:53a5d3c5-85b7-4e4f-a23a-d8d3de8a1641Request ID:dc7b30f7-e96e-451c-bc30-042f2bfc7a34Time:2023-02-22 08:20:58Z

DavidPorTodos · ‎04-18-2023

Hi there, while building a report for a German customer I used the County of his country in a filled map. All Counties are working as expected except for what is regarding the County Leipzig that actually has 2 Counties and not just one. Landkreis Leipzig (kreiskennziffer 14729) - please find more information here Leipzig (district) - Wikipedia Leipzig (kreiskennziffer 14713) More info could be found here: Kap 22 01* (jugendfeuerwehr.de) please look for 14713 and 14729 Kreisfreie Städte und Landkreise nach Fläche, Bevölkerung und Bevölkerungsdichte am 31.12.2021 - Statistisches Bundesamt (destatis.de) Kreise - Germany — Opendatasoft Deutschland: Landkreise und kreisfreie Städte - Erdkunde-Quiz - Seterra (geoguessr.com) Wohnung mieten in Kreis Leipzig - ImmoScout24 (immobilienscout24.de) (check here for either Kreis Leipzig or Leipzig) As displayed in the below picture the yellow part correspond to the county Leipzig and the blue corresponds to Landkreis Leipzig Could you please update the map? thank you

saintsitive · ‎04-17-2023

As subject said, I cannot scroll all the way to the bottom on the Data panel, I installed the latest version of Power Bi Desktop via Microsoft Store. My colleague who has same version installed doesn't have the same issue. Is it my PC setting or something? Please kindly help, I cannot see all the data table.

trux66 · ‎04-13-2023

Hi - the April 2023 update has broken the Properties pane in the model view. I used to be able to click on a column in a table and edit its properties in the pane. Now the pane will not update when clicking on any field or measure from my tables. Feedback Type: Frown (Error) Timestamp: 2023-04-13T18:36:16.6400367Z Local Time: 2023-04-13T14:36:16.6400367-04:00 Release: April 2023 Product Version: 2.116.622.0 (23.04) (x64) OS Version: Microsoft Windows NT 10.0.19044.0 (x64 en-US)

sldkfjasdlk · ‎02-03-2023

Datamart is suddenly uneditable and unable to be refreshed. All underlying dataflow tables are accessible and able to be used. Existing reports on top of this datamart can still be accessed. The message when attempting to refresh: "Unable to open the datamart because it is not connected to its dataset. Wait a few seconds, and then try again." Have tried periodically for over 8 hours. Activity ID: 318df93b-b0f7-426a-876d-24a7ceb9d528 Request ID: 5ff5c016-ccfd-4b69-8cf0-e33af0f88dd5 Correlation ID: 38855fed-9a6b-cee7-1f47-7e4ad63816e8 Status code: 400 Time: Fri Feb 03 2023 16:48:03 GMT-0500 (Eastern Standard Time) Service version: 13.0.19958.49 Client version: 2301.4.12022-train Cluster URI: https://wabi-us-west2-redirect.analysis.windows.net/

hannibalmads · ‎11-07-2022

Since October 24th 2022 the Microsoft version of the IBM DB2 connector returns an error on both Import and DirectQuery when working with JDEdwards on an IBM DB2 database (I haven't tried with other databases and tables). "HISMPCB0002 In BasePrimitiveConverter the SetCodePage method has been called with a invalid codepage: 937" This goes for the Power BI Desktop October 2022 version as well as the Power BI Service. When I roll back to the PBI Desktop September version I have no errors with my report. But when I publish the report to the service, the error reappears. Unfortunately this prevents us from doing any reports on the database. See also debate on Solved: Re: Error Message Trying to Hit iSeries DB2 - Microsoft Power BI Community which does not contain a solution even though it is marked as solved.

Tiemen · ‎02-20-2023

Hello, After a page refresh the Power Automate visual in the Power BI service shows an error saying it is not certified. This doesn't seem right to me because it is an built-in visual. Can you look into this? Thanks! Best Regards, Tiemen

jscheible · ‎03-29-2023

The vertical scrollbar in one of my tables is visible in the Power BI service and in Desktop, but at some point over the last few days it has disappeared in Power BI Embedded. I have tried adjusting all the potentially related settings and nothing seems to help. I opened in Desktop and re-published and that did not work either, and I have not been able to find anything helpful online. Any suggestions? Or is this a new bug? Here is how it looks in the service and in Desktop: And here is how it looks in Power BI Embedded

Gopinath_Rajara · ‎03-07-2023

In Line chart, forecasting is available only when the X-axis type selected is "Continuous". When "Categorical" type X-axis is selected the forecasting option is unavailable. There is no option to display labels for the forecasted values, upper and lower confidence levels. In coutinuous type X-axis, the period shown below X-axis is leading 1 period from what the data is shown in the chart. Please enable forecast option with x-axis type categorical as well. Fix the period display when in continuous type x-axis.

DusanRusnak · ‎04-20-2023

Hey there, we've been using Power BI Desktop for a few years in our company (and since July 2022 also Power BI Services). We've been keeping up to date with Power BI Desktop version for last 2 years and never had this issue before. Basically - after upgrading from December 2022 version to February 2023 (also tested on march 2023 / april 2023 - same results ) - loading time of PBI Desktop has skyrocketed - we are talking of jump from just a few seconds to several minutes. Opening blank file takes up to few minutes now , and saved file (size doesnt matter in this case - tested on small and larger files aswell) tens of minutes or not at all (as of now, we have to open saved files by opening blank one, then file -> load etc..) This is happening across the entire company (dozens of computers) , tested multiple times. I cannot find anyone reporting on this issue so I suppose it has something to do with our systems. I'll be happy to provide any information but for most of it, I'll have to consult with our IT department. Thanks in advance for further help.

Share your ideas and vote for future features

Bug - Expand/collapse caret now on left side of navigation pane instead of right and on own line

BUG: We couldn't get your datamart's updated schema

New or changed dataflows with Exasol connector fails on refresh but works in editor

BUG: Dynamic Format Thousands (k) w/out decimal displays correctly in data labels

Desktop options graying out OK and not allowing changes

BUG: Excel - Connect to PowerBI dataset pane doesn't load

Dynamic format strings is not working properly.

PowerBI refresh DM_GWPipeline_Client_GatewayUnreachable

Bug when using a field parameter in a matrix visual

Matrix visual selecting rows new design in the service

Power BI Release Plan App/Report Refresh Failing

County Issue: Wrong county displayed in map for Leipzig

Unable to scroll all the way down on data panel

April 2023 Release Desktop PBI Model View Properties Pane Not Updating

"We couldn't load your datamart"

Issue with IBM DB2 connector October 2022 release of Power BI Desktop and the Power BI Service

Power Automate visual not working in PBI service

Vertical scrollbar in table disappears in Power BI Embedded

Line Chart issues and ideas to improve the line chart visual.

Extremely slow loading of PowerBI Desktop after upgrading from December 2022 to feb/march/april 2023

Helpful resources

Cannot switch off data labels on line chart when u...

Contributor role is able to manage dataset access ...

Y axis should correspond to the total of the stack...

Power BI Crashing!

ModelOperationFailedDueToInvalidCapacityException ...