Issues - Page 299

hongju · ‎03-13-2022

Hi, Team I found same labels in Korean on Goal’s status. That should be fixed. Korean English Thanks, Hong

MM159159 · ‎03-13-2022

The last item in my slicer list is being cut off when the slicer is completely scrolled to the bottom. This occurs on both the PowerBi Service or the Desktop Version. In this example you can see I want to select "UNITRIG MT4400". However if I scroll completely to the bottom, it disappears, even if selected.

Subanand · ‎03-12-2022

Currently only table entities are visible when connecting to Google Big Query. All other objects like Materialized views also needs to be listed to connect and fetch data.

RossWNA · ‎03-11-2022

Since the last Power BI update, I've been getting the following error message when attempting to refresh a composite model report: "Sequence contains more than one matching element". When someone with the Dec 2021 version of the report attempts a refresh however, it works perfectly fine. Any advice on how the update may have cause these problems, and what possible solutions exist for this?

Anonymous · ‎03-11-2022

HI, my name is Felipe I'm having trouble creating a VNET Data GAteway in Power Platform Admin Center. If i hit the save button and nothing happens. Looking at the network(F12) somethig like a cors error appears. Can you check please?

AdamJ · ‎03-11-2022

We have had three users in the past two days, out of about 40 Power BI Online users, report that they have had issues accessing Power BI. They each receive a sign in error (like the ones seen below), when they try to access Power BI, even though they were previously signed-in and utilizing Power BI Online. The error message is: "Sorry, but we're having trouble signing you in" and there is an initial error code of AADSTS50011. Searching on that code seems to indicate that this could be an issue with some Azure AD misconfiguration, however we literally are just using Power BI accounts though the Microsoft 365 admin center. We don't do anything else with these accounts in Azure AD. In testing so far, one user (the one whose error message is not posted below) could resolve the situation when I had him try using Edge instead of Chrome for accessing Power BI Online - he was able to log in to Power BI Online using Edge without issue. Going back to Chrome and deleting all history (other than passwords) for all time still did not resolve this issue in Chrome; neither did trying in a new Incognito Mode tab. So, we seem to have a workaround (I have not heard back from the other two users), but it would be good to know what is going on, or if it's just that something fluky is occurring with Power BI Online.

mcornfield · ‎03-11-2022

Any idea why this is happening? I have all the visual interactions in my report set to filter. When I open it on my mobile device and click in a visual the others highlight (only in vertical mode) If I move to horizontal they filter again. Is this a bug?

Laurusleen · ‎03-11-2022

should be: 'vandaag' not 'vadnaag'

dansimmons · ‎03-11-2022

Hi, When using the 'Area chart' vis with multiple values plotted, the 'Apply settings to' > 'Customize series' feature doesn't appear to work as intended for the 'Shade area' option. Whilst I am able to select an option from the 'Series' dropdown, adjusting the 'Area transparency' slider scale within 'Shade area' applies this formatting to all lines - not just the series that I have selected. However, if I apply the same principle within the 'Data labels' formatting, for example, it only applies changes for the 'Series' option that I have selected, which is what I would expect to happen. In terms of area shading, I am using a workaround in the form of the 'Line and stacked column chart' vis - for which the 'Customize series' feature does work correctly.

kennienp · ‎03-11-2022

I am working on a template app for Dynamics 365 Business Central (my alias is kepontop) but am currently blocked on two places: 1) After deploying the app, it shows no data in the visuals. I get this error message This operation is not allowed, as the database '3beb3617-d346-4637-9e0d-3a566c09defd' is in a blocked state. Following the support link, I refreshed the dataset in the template app and this does not solve the problem. When connecting to the dataset in PBI Desktop, I can read the data. 2) If I try to connect the deployed app to the data source (after suppliying parameters), I get this error details: Activity ID: dc1bcfc8-4642-4378-bace-a4587f95b697 Request ID: 781be6fe-a173-2ce8-9af4-2495b0607cd6 Correlation ID: 04b544e6-b4fa-fbb8-0b56-8496488dd282 Time: Fri Mar 11 2022 06:47:48 GMT-0600 (Central Standard Time) Service version: 13.0.17904.24 Client version: 2203.2.10336-train Cluster URI: https://df-msit-scus-redirect.analysis.windows.net/ Can you help me get unblocked, please? I run a beta program with 10+ customers that now cannot install the app.

pedroccamaraDBI · ‎03-11-2022

Hi guys This error happened yesterday a few times, and the day before but it disapeared. Today it didn't disapeard. I've clicked on see details, and it shows this And this is the message i got. Can anyone help me please? Feedback Type: Frown (Error) Timestamp: 2022-03-11T10:50:03.7096416Z Local Time: 2022-03-11T10:50:03.7096416+00:00 Session ID: 4e1216ef-4f6d-4558-9fcd-66baf515c2e7 Release: February 2022 Product Version: 2.102.845.0 (22.02) (x64) OS Version: Microsoft Windows NT 10.0.19042.0 (x64 en-GB) CLR Version: 4.7 or later [Release Number = 528372] Peak Virtual Memory: 59 GB Private Memory: 1.95 GB Peak Working Set: 1.72 GB IE Version: 11.789.19041.0 User ID: 71eebc89-ea9a-4e9d-a77b-9411c9920e5b Workbook Package Info: 1* - pt-PT, Query Groups: 4, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True Model Default Mode: Import Model Version: PowerBI_V3 Enabled Preview Features: PBI_dataPointLassoSelect PBI_dynamicParameters PBI_enhancedTooltips PBI_enableWebView2 PQ_WebView2Connector PBI_mobileAuthoringFormattingUI PBI_sparklines PBI_scorecardVisual Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_azureMapVisual PBI_compositeModelsOverAS PBI_useModernFormatPane Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BI

ligei · ‎03-10-2022

Goal: A solution to powerbi - Can Power BI's stacked bar chart visualization hide filtered-out value bucket columns? - Stack Overflow Issue: Calculated columns not updating based on a conditional measure changing value Repro steps: Create two tables without a relationship between them (see image or refer to tables). Fruits and Guesses Fruits Guess1 Guess2 Apples 4 3 Bananas 2 3 Oranges 7 6 Grapefruits 0 1 Guess Columns Value Guess1 Guess2 Create a table visual for each table in step 1. Create a measure that concatenates all the selected values in the second table, then display it in the report as a table visual. Concatenated Selections = CONCATENATEX(ALLSELECTED('Guess Columns'[Value]),'Guess Columns'[Value],", ") Create two measures that are True or False based on the contents of the measure created in step 3, then display them in the report as table visuals. Show Guess1 Values = CONTAINSSTRING([Concatenated Selections],"Guess1") Show Guess2 Values = CONTAINSSTRING([Concatenated Selections],"Guess2") Create two new calculated columns that get their values from the columns in the first table, predicated upon the True and False measures in step 4. Conditional Guess1 = IF('Guess Columns'[Show Guess1 Values],[Guess1],BLANK()) Conditional Guess2 = IF('Guess Columns'[Show Guess2 Values],[Guess2],BLANK()) Create a stacked column visual, with the Values bucket containing the calculated columns in step 5, and the Axis bucket containing 'Fruits and Guesses'[Fruits]. Select any row(s) from the second table's visual. Observe changes in the measures' visuals, and the stacked bar chart. The measures' values update, but the calculated columns in the stacked column chart don't update. Example report showing the problem; includes all data, measures, calculated columns Table: Fruits and Guesses Measures: None Calculated Columns: [Conditional Guess1], [Conditional Guess2] Conditional Guess1 = IF('Guess Columns'[Show Guess1 Values],[Guess1],BLANK()) Conditional Guess2 = IF('Guess Columns'[Show Guess2 Values],[Guess2],BLANK()) Table: Guess Columns Measures: [Concatenated Selections], [Show Guess1 Values], [Show Guess2 Values] Calculated Columns: None Concatenated Selections = CONCATENATEX(ALLSELECTED('Guess Columns'[Value]),'Guess Columns'[Value],", ") Show Guess1 Values = CONTAINSSTRING([Concatenated Selections],"Guess1") Show Guess2 Values = CONTAINSSTRING([Concatenated Selections],"Guess2") I used the below linked pages as references, and attempted to work around my issue. I also checked my understanding for correctness, given some DAX functions don't work with DirectQuery. Tutorial: Create calculated columns in Power BI Desktop - Power BI | Microsoft Docs Update values in table which are based on a measur... - Microsoft Power BI Community ALLSELECTED function (DAX) - DAX | Microsoft Docs Please advise on whether the intended goal is achievable or not. My actual use case is similar to the repro steps, however, the first table is created from a Kusto query. If the resolution process will change based on this, then I would appreciate knowing.

hongju · ‎03-10-2022

Hi, Team The ‘target date’ means due date for the goal in the context. The ‘target date’ at Power BI web is displayed ‘목표 날짜’. That should be ‘2022.6.30. 목표 날짜’ or ‘목표 날짜 2022.6.30.’. Korean English Thanks, Hong

JeffWeir · ‎03-10-2022

I didn't realise until just now that clicking on a panel in the #PowerBI Small Multiples left DOES NOT crossfilter other visuals UNLESS you happen to click on an actual data point directly. By way of comparison, @ZebraBI let me click anywhere. See tweet: https://twitter.com/InsightsMachine/status/1502091711752728577?s=20&t=89PTODLZ-5-gXvQb_OBzTA

tlove15 · ‎03-10-2022

See below for Error Message when I try to access Something went wrong You don't have access to this content Please try again later or contact support. If you contact support, please provide these details.Hide details Activity IDf3a564b2-58e7-4e75-8b31-6cd98be22d87 Request ID98bb2c12-a53d-3e8b-9b1b-e540be512b01 Correlation IDf3ca46ad-fc69-59ae-e12f-e553a3d48ade TimeFri Mar 11 2022 10:26:51 GMT+1000 (Australian Eastern Standard Time) Service version13.0.17810.44 Client version2202.4.10252-train Cluster URIhttps://wabi-australia-southeast-redirect.analysis.windows.net/Copy

Eleftheria_K · ‎03-10-2022

Hello! I am facing an issue and even though I tried hard to solve it I didn't make it. I have written a native sql query which has an aggregation function (max) and some where clauses in it and even though when I run it to management studio works fine and brings only one value for each ID which is the correct, in Power BI brings for some IDs double values (neither the aggregation and group by works not the where clause). Have anyone faced anything like that? Thank you in advance Eleftheria

jpcrjbball · ‎03-10-2022

All, I apologize if my terminologies are inccorect. For about 4 months now, our company has been using power query/dataflows. We expand mostly csv files and have succesfully for awhile now. About 16-20 days ago we became unable to expand the content column and create a "Sample file". When we click the down arrows in the content column, we get this error. This error is independent of the file. We have tried multiple csv files and text files of different formats. We are continually getting this error. The queries/dataflows that are currrently built and utilize this function, are refreshing fine. We are not able to build any new queries/dataflows with new sources. The expand table function works fine in the desktop app for the same exact csv/text files. We are accessing an azure blob storage container and this also works fine for already built dataflows and for the desktop app. This seems to be an issue isolated to power query/dataflows. We are trying to find workarounds, but have had no luck so far. It is very strange to us that the exact process has worked for months and all of the sudden, the exact same code from the advanced editor will not accomplish what it previous has. Thank you for any time and effort you expend helping us out.

senthilvelk · ‎03-10-2022

I have a Power BI report that fetches data from azure application insights. When I initially created it, all data were getting fetching. But in recent times, there is a huge spike in the volume and not all the data is fetching. I need 3 months of data to prepare the report. But I am getting only few days of data now. Expanding the timeout settings in the query doesn't help at all. Any suggestions pls?

qiaoc · ‎03-10-2022

JSousa · ‎03-10-2022

Dataflows with enchance compute enabled returning status Failed when trying to refresh, with the following log: Error: An internal error occurred.. RootActivityId = 6939a220-2565-43f9-9285-358468b3f494.Param1 = Operation failed because the compute engine has an outage and is unavailable. Please retry your operation Request ID: b84c6704-e381-f888-fc64-f7f3691f82a0. When trying to modify those dataflows via enhanced compute engine settings to disable or optimize it returns the following error: Activity ID: 898203eb-51b4-4a15-b4f5-f216d30094db Request ID: 79b5fdee-08dc-1592-0a84-a7c752dc0312 Correlation ID: c2cd9177-e68e-79f0-6366-a2c9a3eb74b6 Status code: 500 Time: Thu Mar 10 2022 11:40:45 GMT+0100 (hora estándar de Europa central) Service version: 13.0.17810.44 Client version: 2202.4.10252-train Cluster URI: https://wabi-north-europe-e-primary-redirect.analysis.windows.net/

Share your ideas and vote for future features

Typo at Goal’s status (in Korean)

Slicer Cutting Off Last Value

Connect to Google Big Query Materialized Views

Composite Model Refresh Error Post-Feb 2022 Update

Power Platform Admin Centre

Power BI Sign in errors starting out of nowhere - no changes have been made prior

Power BI Mobile report Visual interactions ISSUE

Start page has bad spelling

Possible bug on 'Area chart' vis - 'Shade area' not working for 'Customize series' feature

Template app - database is in blocked state and deployed app cannot load data

couldn't load the data for this visual

Update calculated columns based on a conditional measure changing value

Typo at Goal on Mobile app(in Korean)

Crossfiltering from a Small Multiple Line Chart requires you to click DIRECTLY on a datapoint.

Unable to access Power App

Power BI Desktop Optimised for RS (Jan 2022) - Native Query problem

Content column will not expand into transform file, independent of file/file type

Power BI not fetching all data from azure application insights

Data Color option missing in format your visual

dataflow enhanced compute issue

Helpful resources

Multiple Refresh schedules in single report

R and Python - Standard Gateway

PowerBi consistently crashes when chosing Quick Me...

Bug in quick filter in PBI Desktop

Something went wrong endless loop