Issues - Page 2

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

PeterWessels

---------- Message ---------- ApiRequest load failed with status 500 ---------- Stack ---------- ApiResponseError: ApiRequest load failed with status 500 at p.handleLoadEvent (https://australia.prod.powerquery.microsoft.com/MashupEditor/scripts/p.h.a.c2dedd539a7896950b5f.bundle.js:2:34257) at XMLHttpRequest.<anonymous> (https://australia.prod.powerquery.microsoft.com/MashupEditor/scripts/p.h.a.c2dedd539a7896950b5f.bundle.js:2:35587) ---------- Session ID ---------- d43a2bf6-a4a9-49c7-b818-4aa5def558ab ---------- Request ID ---------- 15deb255-3b4a-4aee-9b61-ab8b04bf6084 -

Pbloke

Patched to 3000.214.9 March 24 Now the data sync is kicking back on the SSL error for the self-signed certificate. sync works fine with the force encryption removed. MessageParameters=[Microsoft SQL;<ccon>A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)</ccon>] MessageParametersContainsPrivateInformation=[False;True] --->

ClaretBlue

I recently did my monthly data rfresh only to get below screenshotted errors. Can you assist. i have been looking around for a solution but am stuck. All the while everything was working fine. Please help with below errors. Seems Cache removal is noit a trick at all.

GuvenTum

The Unused Artifacts api (https://learn.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-unused-artifacts-as-admin) returns me a list including duplicated reports that have already been deleted. Is there any way to fix this?

DmitryKo

Currently, if a certain column "A" in a table is specified as "Key column", then "sort by column" feature - when column "B" is used to sort instead of column "A" - for this column stops working - without any warning or otherwise indication in the UI. Expected behavior: it should work regardless.

nachthl

I have posted the details into a forum post: https://community.fabric.microsoft.com/t5/Desktop/When-select-all-is-used-then-slicer-doesn-t-respect-the-visual/td-p/3809838 Steps to replicate the issue/bug: 1. In Power BI Desktop, click on Enter Data and create a table having 2 columns. In column 1, enter values 1-10; and in column 2, enter values a-j. Load this table into Power BI. 2. Now create a table visual with both these columns 3. Create a slicer visual with column 1, SLICER TYPE should be dropdown, and under SELECTION choose `Show "Select All" ...` 4. Click on the slicer visual, and under the filter pane -> `Filters on this visual` -> filter on this column such that it shows items with value less than 4, and click on `Apply Filter` 5. Now your slicer will show values from 1 to 3 6. If you select any slicer value, the table visual will get filtered to show that record. 7. However, if I choose `Select All`, with the intention that the table should show data for all items in the slicer, then the table visual shows all values. Shouldn't it only show 1 to 3?

TeaPea88

Hi, this seems to be a bug in the April 24 release. You can no longer right click and group objects on the canvas, nor can you do it in the selection pane. The only place to do it is from the Format menu, however, after some time or a trigger (I'm yet to work out what) the objects ungroup. This is causing issues with selected items bookmarking.

khacwee

Dear all, Recently the mobile layout is updated with interactive function, however the background of the mobile layout now stays in White color regardless what canvas color or wallpaper you choose in Power BI Desktop view. I have tried on few different PCs and Pbix files they all return the same white background issues since all my reports are in Black background with white font. Would be gladful if this is verified as a bug and can be fixed as we are unable to publish the report now as it will ruin the mobile layout view of users. Thanks!

santhoshkj

Hi Team, I am trying to use one of AI chart - smart narrative. its not working for simple pie chart also. Can you please help me to get this resolved? Attached Screenshot - Thanks, Santhosh

bllodyigruel · ‎04-12-2024

I am writing to bring to your attention a serious issue involving a scam link that is exploiting unsuspecting users, endangering their financial security and compromising their privacy. The scam link in question is: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=addf729c-b8f6-ee11-a73d-6045bdb2f131 Upon investigation, it has become evident that this link is maliciously designed to deceive individuals into divulging sensitive personal information, including financial details. Victims are lured into clicking the link through deceptive means, such as false promises of rewards or urgent notifications mimicking legitimate Microsoft communications. The consequences of falling victim to this scam are dire, ranging from financial loss to identity theft and fraud. It is imperative that immediate action is taken to address this threat and protect users from further harm. I urge the Microsoft security team to promptly investigate this matter and take appropriate measures to block and remove the malicious link from circulation. Furthermore, I recommend enhancing security protocols to prevent similar incidents in the future and to educate users about recognizing and avoiding such scams. The safety and security of Microsoft's users should always be a top priority, and I trust that the necessary steps will be taken to address this issue swiftly and effectively. Thank you for your attention to this matter. Sincerely,

jj6291 · ‎04-11-2024

I have a barchart with small multiples. I have turned off shared Y axis and enabled scale to fit. I have an ongoing issue where one of the Y axis labels will vanish, and it only comes back temporarily if i click the plot and resize it. See my image, the top left Y axis values are not shown:

chuusan · ‎04-11-2024

Our team is developing a report on a dark canvas. When adding stuff to the filter panel, the text font is not rendering in white as expected and it make it hard for user to use to filter panel. Hope you guys can help fix this issue soon. Much appreciated!

D_M · ‎04-11-2024

Hello, As of the latest release of PBI desktop (version: 2.128.751.0), the 100% stacked column chart detail labels do not display or inherit the correct font color by default. This applies both to standard Microsoft default themes and custom variants. Only an explicit font color reference (using 'detailColor') in a custom theme file or alternatively a manual override appears to solve the issue, but ideally it would 'simply' inherit the color from elsewhere in the file, as this would facilitate a simpler, cleaner JSON theme file (which of course has multiple benefits). To visually demonstrate, here is a 100% stacked colum chart with the default PBI theme in place and Data labels switched on (which by default uses the detail labels as expected). Note the highlighte color options in the Detail formatting panel, which do not match the physical font color: This also applies to standard custom themes, like so (in this case, the intended style is for the font to appear black against a white background): In both cases, the correct font color is ostensibly being referenced, but not translated into the visual. However, if the font color is drilled into, the correct hex value is revealed (this also fixes the font color of course, as PBI sees any access to this menu as a hard override): If using the explicit 'detailColor' value in the custom JSON theme file, this also fixes the issue, though this should NOT be necessary: Hoping this can be fixed relatively easily, as we're mindful of keeping our custom theme file as streamlined as possible and anomalies such as this are nudging us in the wrong direction, adding granular formatting where it should be avoided if possible, thanks!

D_M · ‎04-11-2024

Hello, Having upgraded to the latest release (version: 2.128.751.0 at the time of writing) it's been observed that, by default, the 'Detail' formatting options for the Data labels pane is currently missing 'Bold', 'Italic' and 'Underline' as options in PBI desktop, as shown below: Also, just to confirm from my testing, this is the case even if using a default Microsoft theme (as well as a standard custom theme). However, if a 'detailBold' option is invoked in a custom PBI theme file explicitly, this then works in the relevant PBI file in PBI desktop, and also displays in the visual, like so: Clearly, this is not expected behaviour, so would suggest these formatting options to be made available in the formatting pane as per other similar text outputs, thanks!

RJ_YYC · ‎04-11-2024

Hi, We have enabled the PERSONALIZE option for some of our visuals and users love the ability to add some measures to the visuals that are published. However, the names we've given our meausres are quite long (for example : "Gas Produced Gross (e3m3/d)"), and they don't fit in the window that pops up when you choose to personalize, and we can't figure out a way to make that window bigger. You can see the full name if you hover with your mouse over the measure names but it would be easier/more convenient to be able to SEE the full name, by exanding that little pop-up window. Thanks

Merkurs · ‎04-11-2024

Hi, When i try to open a file using desktop version im getting this message, how can i open a file on desktop version?

gaurangpatel668 · ‎04-11-2024

I am currently using Power BI to connect to an Excel workbook with a live connection. The workbook contains data that I summarize using Power BI. While this process works smoothly on Windows, I am facing difficulties when attempting to refresh the data in Excel on my Mac. Specifically, when I click on "Data" > "Refresh All" in Excel on my Mac, the worksheet remains blank, and I do not see the expected output rows that I see on Windows. Here are some additional details: The live connection between Power BI and Excel is established without any errors in window. I have verified that the data source is accessible and up-to-date. Enabled the External Data Connection both in Mac and Window I have tried troubleshooting this issue by restarting both Power BI and Excel, as well as checking for any updates, but the problem persists. I would greatly appreciate any guidance or assistance you can provide to help resolve this issue and ensure that I can successfully summarize data in Excel with a live connection on my Mac.

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.

OscarLake · ‎04-11-2024

need to connect (local) Power BI, through On-premises data gateway (cloud), to MS SQL server (on bussiness server) I managed to connect Cloud Power BI to bussiness SQL server through Data Gateway, but when i try to do the same on my laptops using my power platform credentials, ssl error appears DataSource.Error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - La cadena de certificación fue emitida por una entidad en la que no se confía.)

Share your ideas and vote for future features

Data Source error: Column not found in rowset

Datamart unable to refresh due to credentials

On premises gateway self signed certificate now being rejected after March 24 was working prior.

Dashboards

Unused Artifacts API returns already deleted artifacts.

"Sort by column" should work regardless of key column setting

When `select all` is used, then slicer doesn't respect the visual level filter

Issue with April 2024 desktop - Grouping objects not persisting

Mobile Layout - Background stay in White color after Interactive Update

Smart Narratives is not working for simple pie chart

Urgent Report: Scam Link Exploiting Users

Small multiple Y axis values disappearing

Bug with Filter panel background color

100% stacked column chart - Detail label font color not being correctly displayed/inherited

100% stacked area chart - Detail label formatting options 'missing'

published report with PERSONALIZE enabled - the screen is too small

Power BI desktop version

Sumerize Data > Excel with Live Connection not working in Mac Excel

cannot use quick measure

need to connect (local) Power BI throught (cloud) On-premises data gateway to MS SQL server

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