Issues - Page 188

Gia-gia · ‎11-22-2022

Hi, I use powerbi desktop application to create my sales dashboards. When I have all data I need, I export it using the 3 dots. it creates a csv file where data are spread in different columns. Then I load these data into another excel file where I've created a specific table to welcome these raw data. Then I click on "refresh all" and all my data are automatically readable into the right section of my different tables. However, since yesterday, I have an issue, when I export data from powerbi, all data are in one column (A) seperated with comma and not into differents columns like before. Because of that, when I load the raw data in my second excel file, data don't load into the different table. Even if use the function "Text to columns" in the first excel. Any idea how to reslove this issue ? Thanks

Anonymous · ‎11-21-2022

Hi team, I am facing issue. I am having 2 dashboard one is emp level and another is manager level. Wanted to publish report in single ws. But managers which are having access are having admin role to ws. I want to remove them from emp level dashboard. So is it possible? If yes then how? Thanks in advance. Regards, Sagar Shah

geumkang · ‎11-21-2022

When I set the autoauth=true option of the power bi report URL, the following page appears but why is the height value not set to 100%? In the past, it seemed to come out full screen, but now it sticks to the top and appears small. Can you fix it so that it opens in full screen? You only need to add one option "height: 100%" in your css.

Adriano_Rosa · ‎11-21-2022

Estou recebendo um erro intermitente quando eu utilizo a ferramenta Pincel de Formação: Erro ao renderizar o relatório. Não é possível ler propriedades de indefinido (lendo 'cor') Verdadeiro Versão do Power BI: 2.110.805.0 64-bit (outubro de 2022) Após o erro não consigo mais utilizar o aplicativo, sendo necessário fechar e abrir novamente.

CarsonCox · ‎11-20-2022

For over a week now I keep getting the below error without any change. Have modified the and re-uploaded the pbix file and checked to ensure all datasets have been verified. Can update the data on desktop and upload but schedule or manual refresh online not working. No other explanation as to the error. Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net Activity ID: 188785e6-2e09-47f2-bf44-137078409aeb Request ID: 766ab3e6-ae7a-4316-9def-f19e82228ae3 Time: 2022-11-20 20:41:39Z

salehh6 · ‎11-18-2022

When I re-publish my report to web, some of the report specific settings reset to default even though I have changed them before. For example, Pages Pane settings is set to Disabled: and comments are set to Enabled: I was wondering if I am missing any steps or this is expected? Thanks, Hishmat S

fe_software_dev · ‎11-18-2022

Hello, I'm using the Bookmark Navigator toggle button and it's not defaulting to the selected view when I open a published report on through the web portal. I have three bookmarks: Total New Lost When I publish my report and open the web portal, the applied bookmark won't match the selection on the navigator toggles. When I published my report, the bookmark was set to 'Total' and so were each of the Bookmark Navigator buttons. When I open that published report. The visuals are showing the 'Total' bookmark view. The first toggle shows 'New' selected. The second toggle shows 'Lost' selected. Is there anyway to fix or work around this?

Anonymous · ‎11-18-2022

Hi, There's a new issue in the most recent PowerBI patch with the stacked column chart. Below is a chart of a simple table with a few hundred rows, with Country column on X-axis, a plain summation measure of a numeric column on the Y-axis, and column with two distinct values (A or B) as the Legend. As you can see there are two "DK" on the X-axis. I have verified that these are identical, e.g. no "DK " or anything. Identical. This issue appeared with the October patch

v-likosh · ‎11-17-2022

Need help to remove the "Save" option which appears when we click on "Visualize this view" Power BI integration in Dynamics 365. I do not want anyone/everyone to save the view as a report to their own workspaces as its a sensitive data. Referred: https://learn.microsoft.com/en-us/power-bi/create-reports/dynamics-quick-create-report#save-the-report-and-dataset Announcing general availability of visualizing views in Power Apps with Power BI | Microsoft Power Apps None of the articles talks about removing the save button from this view. Do you think it is a by default feature or do you have any suggestions to remove it. Please let me know here. Thank you!

schmiegelt · ‎11-17-2022

Hi all, I have an issue exporting data from a visual in the PowerBI web interface. When clicking on "Export Data" in the three dot menu of any visual, I can choose the type of export, just as expected. I even get a success message on the export. After that, my browser (edge) shows that a download of the data file starts. However, the download always fails: It is the same for exporting a PDF or PowerPoint file. The download starts, but does not succeed. I had a look in the console, but there is no relevant information. Does anyone have the same issue, or even a solution? Best regards, Philip

kabdrx · ‎11-17-2022

Hi, There's a bug (or maybe it's by design), but when you're editing options that contain text (e.g. visual title) and you quickly switch to another visual before the validation of the new value, this new value applies to the visual that you've just selected. Steps to reproduce: 1) Add two visuals, e.g. two cards 2) Start changing the title of one of them 3) After adding a few characters, quickly click on the second card without waiting for value validation 4) The title that you just typed will be applied to the newly selected card instead of the card for which you started changing the title in the first place There is a value validation after a short interval, but if you switch before this validation, your changes are not applied as expected (they're applied to the other visual). Regards,

shatha · ‎11-16-2022

Hello I have a Power BI report published on an embedded capacity that is integrated with Salesforce and it works fine, but I have added a paginated report visual inside it and in the power service it's ok however in salesforce the paginated report visual doesn't appear and all I get is can't display this visual and when I click to see details I get"an unexpected error occurred" could someone help on how to make the visual available

47Yh12 · ‎11-16-2022

Hello there! I have a filled map visual on a report that loads correctly. When exporting to PDF (Current Values & This page only) something goes wrong and I am presented with a whole world map. This is odd as we're only looking at data over a small geographical region. This is something that also worked previously that suddenly stopped working. Troubleshooting/ testings so far: Tried a small date range to pull less data. Did not fix. Tried a measure to run in the background to give the visual time to load when exporting. Did not fix. Some of the data does not fit the geographical data requirements, so I've created a second table to run the quantities through where only correctly formatted data can be loaded. Did not fix. The map is layered behind another visual with no background. I tried separating the visuals and this did not fix. I'm stumped as this worked previously (showing the region in export). Now nothing I try seems to work. Any ideas or fixes anyone?

pedroamaro90 · ‎11-16-2022

I was creating a new table based on information coming from a Direct Query Table which is stored in a Power BI Dataset (I'm using a composite data model). This dataset is connected to an Azure SQL Database. The expression is quite simple: New Table = SUMMARIZECOLUMNS('Store'[Store Id], "# Sales", [# Sales] ) This was working before I updated to the latest version of Power BI Desktop (October 2022). The solution for now was to downgrade to the previous one (September 2022). Could you please check? If you need more information, please let me know.

Daryl-Lynch-Bzy · ‎11-15-2022

Hi, I have noticed recently that some links are directing me to "Apps | Microsoft 365" rather than Power BI. https://app.powerbi.com/groups etc vs https://www.office.com/m365apps/ etc This is okay, but I am finding when I refresh a Dataset or Dataflow that the "Spinning Dots" are not disappearing when the refresh complete on the Office version. The Power BI version seems to update in the background probably about 10 to 15 seconds after the event finishes. Unfortunately, the office version does not appear to update when the background event finishes. I have to manually refresh F5 the screen to show that refresh is completed.

MattSPrictor · ‎11-15-2022

Hi All, We have recently had an organisational change that has required a change to some of the mapping tables in one of our reports. Since this change personal bookmarks have completely stopped working in the report. You can still create a new personal bookmark, however when you select it it does not filter anything at all. It is only affecting this one report, all other reports which went under similar changes are unaffected. This is very frustrating for users as it is a very filter heavy report - Any ideas? Any one see this before? Can't find anything online. Gets refreshed and published every day but issue remains.

RandyPgh · ‎11-15-2022

My environment consists of about 10 reports, 5 dataflows including a staging dataflow that supports the others, and original data sources of Smartsheet, SharePoint lists, and Excel (no relational database). For the most part, the Power BI report datasets pull their data from the dataflows, but some dataset tables might be pulling directly from original sources. Power BI Desktop version 2.110.1161.0 64-bit (October 2022) Since Monday morning, I have had problems with Power BI's Refresh and with Power Query's Refresh All and Refresh Preview. These occur in reports that worked on Friday but that, when opening, fail to refresh. Most frequently, these produce the "Too many bytes" error. Unexpected error: Too many bytes in what should have been a 7 bit encoded Int32. Details: Microsoft.Mashup.Evaluator.Interface.ErrorException: Too many bytes in what should have been a 7 bit encoded Int32. ---> System.FormatException: Too many bytes in what should have been a 7 bit encoded Int32. ---> System.FormatException: Too many bytes in what should have been a 7 bit encoded Int32. at System.IO.BinaryReader.Read7BitEncodedInt() at System.IO.BinaryReader.ReadString() at Microsoft.Mashup.EngineHost.Services.DiskPersistentCache.PersistentDictionary.<>c__DisplayClass11_0.<ReadBucket>b__0() at Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.<>c__DisplayClass8_0.<IgnoringAccessExceptions>b__0() at Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.TryIgnoringAccessExceptions[T](Func`1 func, IEvaluationConstants evaluationConstants, T& result, Exception& accessException) at Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.IgnoringAccessExceptions(Action action, IEvaluationConstants evaluationConstants) On occasion the "Container exited unexpectedly" error appears. Unexpected error: Container exited unexpectedly with code 0x80131623. PID: 24488. or Container exited unexpectedly with code 0x80131623. PID: 25908. Sometimes, simply re-clicking Refresh Preview corrects the issue. Other times, walking through the entire Power Query flow, step-by-step, without changing anything, will get the table to refresh the preview. This issue is compounded by the error that for several months has occurred in Power BI Desktop. When I first open a report and click the Refresh button, the following occurs for at least one table in the dataset ("ABC" and "123" have been used below to replace the real query name and step name). Query 'ABC' (step '123') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. My discovered workaround for this older issue has been to go into Power Query, click Refresh All, wait for all table previews to refresh, click Close and Apply, then return to the Power BI Desktop interface and click Refresh. This has worked for months, but now, the Power Query Refresh All produces all of the errors above, causing hours of working through phantom issues through manual refreshes. Thank you for any help in resolving this. [End-of-day update: Windows Programs "Repair" and an uninstall/install cycle have been done without fixing the issue.]

bco_lde · ‎11-14-2022

as the title suggests A network-related or instance-specific error occurred while establishing a connection to SQL Server. Verify that the instance name is correct and that SQL Server is configured to allow remote connections according to the splendig MS forums and the error message, it seems the SQL Server is not running, not accpeting TCP or ports are blocked. funny thing. its the MS own Dataverse I am trying to connect to, via the built in BI -> Dataverse connector. Seriously: one of the things MS claims is the all integrated dataverse, seamless reporting yadda yadda yadda btw: the label function to report issues is a joke, isn´t it ? and tis is not an idea as well, its a serious connection issue yet the Dataverse (and Business Central for that matter) integration has to be the worst performing connection ever. it´s performance is abysmal and it is extremely unreliant. MS , what is goin on ?

bboschma · ‎11-14-2022

For one of our Power BI reports, a user raised an issue that he could not see some specific data on a report page. We gave the user the proper Row Level Security which works for all other users. We tested the Row Level Security by using the "Test as Role" feature in Power BI. Procedure to use "Test as Role": 1) Navigated to the report's dataset in the workspace where the report is located. 2) For that dataset, clicked the elipsis (...) and selected Security from the menu 3) When the Row Level Security page opens, clicked the elipsis (...) to the right of "Users" and selected "Test as Role" from menu 4) Clicked the link for "Now Viewing As" and searched for the user who reported the issue and then clicked the "Apply" button When we use "Test as Role" for that user, we can see the data that needs to display. It works. However, when the user actually visits the same report page, he still cannot see the data that we can see when using "Test as Role" as that user. Please share feedback on how we can debug this further, or in the spirit of suggesting a new idea, can Power BI provide more debugging tools within the interface to let us detect the root cause of this issue.

atman · ‎11-14-2022

Hello, there was a mention about this issue on a post from 2021, but there weren't any updates about the progress. I am currently facing the same issue, but was able to reproduce it. Creating a date slicer filter like this should set the filter like shown, and it does, but only if your local machine is in a UTC+01 timezone or above. If you change your timezone to a negative one(UTC-01 or below), both from and to dates get decreased by 1 and the slicer is set like in the picture below. What makes this even wierder, if you set your local timezone to UTC, suddenly the from date becomes correct and to date is still invalid and shows one day before. I have no idea what causes this behaviour or am I overseeing something. But I don't see how this is dependant on machine's timezone since we are dealing with UTC dates here.

Share your ideas and vote for future features

exporting data Issue

Apply rls in power bi service

Power BI Report autoAuth=true Page CSS Issue

Mensagem de Erro Intermitente

Data refresh - internal service error - Transient Issue

Report specific settings reset after re-publishing

Selected bookmark toggle does not reflect the applied bookmark after publishing a report.

Duplicate X-axis values on stacked column chart when using Legend

Visualize this view in Dynamics 365

Export data not working (Couldn't download file)

Switching to a different visual while editing title applies changes to the new visual

Paginated Reports visual NOT DISPLAYED

Filled Map not Exporting Correctly to PDF

Error on creating a table based with Direct Query Connection to a Power BI Dataset

Refresh Status Not Updating on Microsoft 365 Portal

Personal Bookmarks Broken in PBI online - Not Filtering Report

Errors in Power BI Desktop's Power Query Refresh

Cannot connect PowerBI Desktop to Datverse Connector

Different data is displayed between the actual Power BI user and the Admin using Test as Role

Date slicer filtering showing wrong dates depending on the timezone

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