Issues - Page 34

gtzanakis · ‎10-26-2022

I'm using Version: 2.110.805.0 64-bit (October 2022) from MS store; same bug applies to the October 2022 installed independently (not from the MS store). The bug is not present in the September 2022 version. Steps to reproduce (see also the screenshots below): Create a new field parameter Add a new column in the power query definition for the field parameter Double-click on the new column name, change the name and press enter October version: An error occurs. September version: the field is renamed without problems. If you need to play around with the particular pbix file used, you can download it here. PS. This was also reported in the community forum by user @thomasblt here. 2. Manually add a new field to the field parameter table 1. Try to rename the new field 3. Error message 4. Field cannot be renamed by any other means

MBonnett · ‎12-22-2020

My team is trying to connect to datasets in our workspace using the new DirectQuery for Power BI datasets and Analysis Services functionality and are encountering connection errors. Power BI Desktop Version: 2.88.721.0 Connecting to a Power BI Premium Capacity Attempted connecting to many different types of models in the Power BI service, even a basic model containing 1 excel sheet to see if we could get it to work Dataflows work without issue, and connecting to 1 Live Dataset works without issue When trying to add a local model after establishing the live connection: An error occurred while loading the model. Verify that the connection information is correct and that you have permissions to access the data source. When we make the local model first and then try to add the live dataset connection we then get this error: Cannot load model Allows us to select the Dataset we would like to add to the model. Once we click "Create" it gives the below error: We couldn't connect to your Analysis Services database. Double check that your server and database names are correct, and make sure you have permission to access them. Bad Request Technical Details: RootActivityId: 8d8dba2e-4c1a-4f50-a68e-b0375e4bac61 Date (UTC): 12/21/2020 7:58:11 PM We have access to the datasets and workspace so I don't know why we would be getting these errors. A single live connection works fine, but when we try to add the local model to create the composite model we get the errors. Does anyone have any thoughts on what we are missing? Thank you for any help with this! + @jeroenterheerdt (additional details pertaining to the errors are below in additional post)

AnonymousPerson · ‎08-11-2022

Connecting from Power BI Desktop to a model in my workspace. I go to DATAHUB > POWER BI DATSETS, choose my dataset, and get the error: We couldn't get the data for this visual due to an authentication error. Please try again later. Detail reveals the message: One or more errors occurred. ---> System.ArgumentException: An item with the same key has already been added. Rolling back to July 2022 fixes this bug. Can you please fix it in August release?

Anonymous · ‎08-11-2022

I have a date column in my table and i have no option to filter it. I cant chose between, before, after ect.. And i'm sure i could do it before. Hopefully some one knows how to fix it.

2BitNerd · ‎09-20-2021

Prior to this weekend (9/20/2021), buttons filled with SVG's would render the correct size in app.powerbi.com and honor the SVG's size. Now, they try to fill the space, ignoring the Image Fit parameter in Desktop, which renders them correctly. For example, I have a button that is 64x40. I fill it with an SVG that is sized to be 24x24 with the Image Fit parameter as Normal. In Desktop, everything looks they way it should. It renders with centered at 24x24, allowing the appearance of padding within the button. In app.powerbi.com, the SVG is stretched to scale to fill the button, resulting in the SVG being scaled to the edges of the button. This is breaking the aesthetics of the report and needs to be fixed back to how it was functioning last week.

dsmithchildren · ‎01-19-2022

Export to excel is not working properly when using a Matrix visual with the show on rows option selected under the values area in the format pane. Here is what the report looks like in desktop... Data and report look the exact same on the Power BI service. But when I click the elipsis on the visual within the service and click on "export data" and choose "data with the current layout" and then "export" I get the following (If I choose summarized data it doesn't work either)... I know that formatting changes aren't applied to the exported data but even though this option is in the formatting pane it is really more of a structural changes to the display of the data and should be kept through the export process. Otherwise, the description of the "data with current layout" text is incorrect because it is not in the same layout.

AJMChris · ‎11-18-2021

The Power Apps Visual in Power BI is now showing blank in Power BI Desktop It is showing correctly in the published version App Any ideas or thoughts as to why this has changed or how I can get it to display again? @v-robertq-msft

PBI_AAA · ‎07-12-2023

Starting 7/11/2023 17:00 CST all reports using dataflows as a datasource are failing to refresh in the service. All give a similar error of "Access token has expired", and I've included one example below. All reports refresh in desktop application, this is only occurring in the service. Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Access token has expired, resubmit with a new access token"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Error","detail":{"type":1,"value":"error \"Microsoft.Mashup.Engine1.Runtime.ValueException: [Expression.Error] The field 'pbi.error' of the record wasn't found.#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForThrow(IThrowExpression throwExpr)#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.<>c__DisplayClass23_0.<CreateValueForRecord>b__0(Int32 index)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.RecordValue.DemandRecordValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Data.Mashup.ProviderCommon.MashupResource.TryGetValue(Func`1 getValue, IValue& value, String& errorMessage)#(cr)#(lf)Record\""}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"TokenExpired"}},{"code":"Microsoft.Data.Mashup.ValueError.RequestId","detail":{"type":1,"value":"284a2330-13e8-481e-a498-8284078e5699"}},{"code":"Microsoft.Data.Mashup.ValueError.RequestUrl","detail":{"type":1,"value":"https://api.powerbi.com/powerbi/globalservice/v201606/clusterdetails"}}],"exceptionCulprit":1}}} Table: Shipper DM. Cluster URI: WABI-US-NORTH-CENTRAL-H-PRIMARY-redirect.analysis.windows.net Activity ID: d57790b8-e591-4464-a4f2-a5d00e862ae3 Request ID: f033803e-eaad-413b-94b7-aa2366b938dd Time: 2023-07-12 09:03:35Z

thebadger7 · ‎07-12-2023

I'm hitting the following error when using the GA4 connector: Expression.Error: The field 'description' of the record wasn't found. Details: apiName=customChannelGroup:XXXXXX uiName=YYYY category=Attribution Seems to have happened after the introduction of a custom channel grouping in GA.

rashidanwar · ‎04-06-2023

Dear members Hope that you all are doing great. I am writing here to resolve a google sheets connector error. Below is the detail. I would really appreciate any help in this regard. I have a report having various data sources. One data source is a google sheet connected through Power BI/Google Sheets connector. Sometimes scedule refresh fails to refresh the report and when I do a manual refresh it works. Sometimes manaul refresh aslo doesn't work. I started receiving these error recently. I think just a week or two ago. Below is the error text. Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<ccon>Web.Contents failed to get contents from 'https://sheets.googleapis.com/v4/spreadsheets/1SFaLvXgIV0lYpSonpwCTw1Y7XCW9Rsws9_cQQVFb9oo?fields=sheets/properties,namedRanges' (429): Too Many Requests</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"GoogleSheets"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"https://docs.google.com/spreadsheets/d/1SFaLvXgIV0lYpSonpwCTw1Y7XCW9Rsws9_cQQVFb9oo/edit#gid=0"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Url","detail":{"type":1,"value":"https://sheets.googleapis.com/v4/spreadsheets/1SFaLvXgIV0lYpSonpwCTw1Y7XCW9Rsws9_cQQVFb9oo?fields=sheets/properties,namedRanges"}}],"exceptionCulprit":1}}} Table: dim_betterplaces gs_exchnage_rates. Cluster URI: WABI-WEST-EUROPE-E-PRIMARY-redirect.analysis.windows.net Activity ID: 7286fe22-df00-4608-94df-ac6cc6200201 Request ID: dbd6c6e5-f5c5-4768-877b-f3e3f59ab855 Time: 2023-04-01 10:06:10Z

stugardner1037 · ‎10-20-2022

In PBIRS, after the September, 2022 update, when attempting to create a subscription based on the day of the week, I receive the message, "An error has ocurred. Something went wrong. Please try again later." Upon examining the logs, in the RSPortal log, I find: 2022-10-20 12:03:14.0721|WARN|123|BadRequest, Errors: An unexpected instance annotation name 'DaysOfWeek.Sunday' was found when reading from the JSON reader, In OData, Instance annotation name must start with @.| RequestID = s_c611f489-2b2b-4258-a79b-3541f6579b1e 2022-10-20 12:03:14.0877|INFO|149|Sending response. Response code MyUserName 400, Elapsed time 0:00:00.0128702| RequestID = s_c611f489-2b2b-4258-a79b-3541f6579b1e 2022-10-20 12:05:41.8710|INFO|151|Received request POST /api/v2.0/subscriptions| RequestID = s_70f526dd-e21e-4bf7-b665-80f6711d842a This occurs regardless of the day of the week selected.

Anonymous · ‎05-21-2021

Some where around May 13th, all of our datasets that connect to SharePoint O365 started failing with the following message: Unable to connect to the data source undefined. (Details below). On May 16th we upgraded our gateway to the latest May 2021 gateway which was version 3000.82.2 (Maybe .4) and everything worked for a couple of days. Then on the 19th we noticed it was failing again. We noticed that the gateway download for May 2021 had a new release and was now at version 3000.82.6. So we downloaded and installed and it seemd to resolve the issue. However, we are still seeing it fail. This morning it failed, so then I was able to manually refresh and it worked, however, it just failed again for the scheduled refresh and a manual refresh is also not working. Ideas? Thoughts? What's going on? Not sure what to do. Underlying error code: -2147467259 Underlying error message: SharePoint: Request failed: The underlying connection was closed: An unexpected error occurred on a send. DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.DataSourceKind: SharePoint Microsoft.Data.Mashup.ValueError.DataSourcePath: https://sharepoint.com/oursite Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net Activity ID: 0b95ab8e-3780-4df9-9af1-7d2edd5cfd55 Request ID: 1464c48e-1da5-ed3e-d5a3-956abbbc3971 Time: 2021-05-21 21:42:35Z

gpoggi · ‎09-30-2019

Hi Guys, It seems Power BI Service is down all over latin-america. Do you know if there is any official ETR about this? Thanks in advance, Regards, Gian Carlo Poggi

ibarrau · ‎01-04-2023

Hi. After UI has changed (green colors) the name of the Service Principals (registered apps on azure) are showing blank for the Workspace Access. Users are asking at the forum about this and it looks like a bug. Regards,

jaap_olsthoorn · ‎10-13-2022

Hi there! I think I found a bug. When you create a measure in a thin report file that uses a powerBI file as its data model, save it, and then add a measure with the same name to the data model powerBI file and upload, you get a warning saying there is a duplicate measure in your report (correct!), but when you try to delete it, you get an error. Steps to reproduce: Create a powerBI file (data model) with some data in it, upload to service Create another PowerBI file (Thin) and connect to the first powerBI file on the service. Create a measure in the Thin file, save. Now create the same measure in the data model file, save and upload. Open the thin file, you will see an error icon next to the thin file measure saying a measure with the same name already exists. Now try to click on the hamburger menu icon. An Error is shown. Hope you can fix it so it becomes easier to delete these duplicate measures! Jaap

remy_guitton · ‎11-25-2020

Since this monday after upgrade to latest on-premises data gateway version, we get refresh failures on some reports with the following error message: "Unable to connect to the data source undefined." Those reports were not modified and were working fine before gateway update. The issue can only be reproduced in a report mixing (ex: with a merge) data from both on-premises source and sharepoint online file. Reports sourcing both these data without any merge run fine. We cleared credentials, checked all connections were categorized as "Organizational" as advised on similar error message in other threads, but with no success. Refresh is successful via Personal data gateway and when downgrading to previous gateway version, I don't get a successful refresh. I tried to apply the fix referenced on Power BI support page for some TLS/SSL issue but with no success, and this mention has disappeared from the portal since a few minutes: https://docs.microsoft.com/en-us/azure/security/fundamentals/tls-certificate-changes Best Regards, Rémy

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

Hexekutive · ‎05-04-2021

Since last week I'm not able to rename my dataflows. I put the new name, click Save, refresh the page and nothing happens. Is this a known bug?

EugeniaBochko · ‎11-18-2020

Hello! I have a big problem with data sources connection in PBI Desktop, especially WEB page from Google Spreadsheets. Today I come across with this problem with my existing data, I have been working for a year with these sheets and everything was OK: “The URL may be wrong or you might not have provided the right credentials to the server.” As usual I Publish to the web my online Google sheet) and then I get new Web data to PBI Desktop and nothing =(..I have an empty window. PBI displays: "We didn’t find any tables on this web page. No items selected for preview." http://prntscr.com/vlgucs http://prntscr.com/vlguos Please let me know how to overcome this issue.

Anonymous · ‎03-28-2023

I've seen the same issue before, but no one had a resoltion for it. I updated a report, which broke some tiles on a dashboard. But the ellipses to delete the tile is missing and I can't find any other way to remove these now broken tiles. Can anyone help? Thanks

Share your ideas and vote for future features

[BUG] Cannot rename extra field parameter column in October 2022 version

DirectQuery for Power BI datasets and Analysis Services: Connection Error

August 2022: Error: We couldn't get the data for this visual due to an authentication error

Date Column unable to filter

SVGs in Buttons no longer respecting image size or Image Fit fill setting in app.powerbi.com

Excel export not working. Matrix visual with "show on rows" in the values section of the format pane

Power Apps Visual

Report dataset refresh failure when using dataflow as data source

GA4 Connector Bug

Schedule refresh sometimes fails for Google Sheets data source.

Day of week subscription in PBIRS after September 2022 update

May 2021 Gateway Error: SharePoint: Request failed: The underlying connection was closed.

Is app.powerbi.com down?

Service Principal showing blank on workspace access - Power Bi Service

Duplicate measure cannot be deleted

Failed refreshes on reports merging data from on-premises gateway with sharepoint online

Vertical scrollbar in table disappears in Power BI Embedded

Not able to rename dataflow in properties

Problem with Google data sources connection

Broken Tiles in Dashboard can't be Deleted

Helpful resources

BUG: DAX expression results in variant data type

Powerbi Direct Query and Cached Data issue

Field parameters - Default sorting order resets Wh...

Issue with slicer search in PBI service

Power BI Crashes When Using Quick Measure