Issues - Page 2

daaa · ‎09-12-2023

I have report which uses a composite data model, with a mix between DirectQuery to other Power BI datasets and some imported tables from SQL Server. The model also uses calculation groups, allthough I do not think this is related to the issue. The data model also has RLS, and I can test this in desktop and it works as intended. However, when I publish the report to the service and I want to "test as role", I get the following error message. Is this a bug, or is "test as role" really not supported for a composite model?

uberdube · ‎12-03-2019

I'm struggling to be able to work efficiently with Dataflows as I am experiencing excessive times to 'validate' queries after pressing the 'Save & Close' button. For entities with even a minimal amount of transformation (eg. simply changing some column data types) I've experienced wait times of over 3 hours to simply save the query to exit out back to the main entity menu/view. Should things be taking this long for an output schema validation process, regardless of the size of the underlying table data? Is this an issue being experienced by others as well? This is making it simply impossible for me to work with the Dataflows product in this way.

NickJ2011 · ‎06-15-2023

Getting the error below, even when refreshing one dataflow at a time. There was a problem refreshing your dataflow. RootActivityId: 394090f0-0dd4-44ad-9ac8-76aeff5192d8 ErrorMessage:Refresh has failed unexpectedly. This indicates in most cases an out of memory issue in your capacity. Please check the capacity configuration metrics and try again.

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/

cassidy · ‎04-27-2023

Starting around 4/21, users across multiple tenants started see a blank white pane when trying to choose a Power BI Dataset in Excel.

ManishBundhun · ‎03-08-2024

Hello, I am trying to create a New DataFlow Gen2 and it does not occur. I get the following error: "Unhandled HTTP Request Exception. Status Code: 400. Reason: undefined. Response Text: "ExternalServiceError"." "ApiResponseError: Unhandled HTTP Request Exception. Status Code: 400. Reason: undefined. Response Text: "ExternalServiceError". at p.handleLoadEvent (https://europe.prod.powerquery.microsoft.com/MashupEditor/scripts/p.h.a.f560c1a901069d71f9e2.bundle.js:2:34257) at XMLHttpRequest.<anonymous> (https://europe.prod.powerquery.microsoft.com/MashupEditor/scripts/p.h.a.f560c1a901069d71f9e2.bundle.js:2:35587)". This happens after I try to create it in a lakehouse in my workspace. Does anyone know how to deal with this? Thanks

rajarshi_singh · ‎11-20-2023

refresh not happening Kindly address this issue resolution, I can't downgrade the application as well as there is dire need to use the new slicer in power bi which is available in the latest version only.

KyleTaylor · ‎02-19-2023

In the latest version (Version: 2.114.664.0 64-bit (February 2023)), all display boxes in PBI desktop aren't displaying correctly. Is this happening to other users? I can find an area to post to Microsoft. Some examples attached.

cristianml · ‎08-11-2022

Hello, With August'22 version I have an issue when I try to apply changes or discard them. Seems not working neither:

Fjcgomes · ‎05-11-2021

Hello, Since last friday i'm with some issues in refresh my datasets. Most of the the refreshes that we try returns an internal error: Error: Internal error Request ID: ad8067f3-103b-4cde-a815-9869e2a3f98c Activity ID: 00000000-0000-0000-0000-000000000000 My dataflows are connected to Google BigQuery, with Powerbi Connector, and this never happened in the past. the error always happens at different refresh times, different entities, and happens on all the Dataflows we have on the server on the various PRO accounts. Do you have any idea of what is happening for this error

timalbers · ‎12-20-2023

Hi there, today I stumbled upon something interesting that cannot be a desired behaviour. If the application language of Power BI Desktop is English, then the default name for the first query in the new DAX Query View is 'Query 1'. So far so good. But in my case - I am working with the German version of PBI Desktop. In this case the default name of the initial query view is 'Abfrage "1"'. Note the quotation marks. This is actually quite some problem, because it leads to the unexpected behaviour that I am unable to save the entire pbix file the moment I start to use the new DAX Query View and execute a query with this default name. First I was confused, why I could not save my file anymore. Every time I tried to save it, I got an error thrown which states ""C:\...\..." ist kein gültiger Dateipfad." which means the target path is not a valid file path. So I looked up the error details and found the topmost entry of the stack trace, which was the following: "bei Microsoft.PowerBI.Client.Windows.Services.PowerBIFileSerializer.ValidateDaxQueryFileName(String fileName)" The corresponding stack trace message was: "The file name 'Abfrage "1".dax' contains invalid characters." It appears that the default query name - which is not user generated but comes from the product itself - is an invalid query name. The quotation marks are crucial. I removed those in my Query view and suddenly I was able to save my file again. I hope you guys get rid of those quotation marks as soon as possible, because this is a serious issue. The user suddenly becomes unable of saving the entire pbix file just by using the new DAX Query View. And the critical part is, that at first sight you have no clue what is causing this problem. Only after a deep dive in the error logs advanced users may identify the problem. Maybe there are even more languages affected, I have not tested it for others than English and German. Best regards and happy holidays Tim

aJayMitchell · ‎06-08-2023

After pressing Alt+Enter to add a new row when coding a DAX measure, the shortcuts such as 'H' for Home, 'JT' for Table Tools, etc are remaining active. When I press Alt+Enter in other programs such as Excel, it picks up that I was using the Alt key as part of inserting a new line and therefore doesn't show the shortcuts/expects the next keystroke to be a shortcut. Within Power BI, it is waiting for the next keystroke to be a shortcut - and therefore keeps putting me out of my flow with writing DAX as I need to click back into the formula bar so that I can continue typing. This is incredibly frustrating and needs to be resolved ASAP.

OHMark · ‎07-20-2023

I was updating our datamart and was given the following Internal error message: InternalError ErrorMessage: An internal error happened due to failed runtime assertion: Unable to change Model locale after other objects have been created.. HttpStatusCode: 500 Activity ID: 1f5701f1-7442-cc75-d9cd-c96cc0f3c052 Request ID: 1b170b49-996f-4b30-ab84-4bd0a398d679 Status code: 500 Error Code: InternalError Batch ID: 3733efbd-39bd-4549-b466-5c871f0d45f0@de9cc02c-e589-48f2-a133-1c26becf210e$2023-07-20T10:09:43.0781626Z@39f2741c-4c67-4302-b54b-b56ffb1da420 This also occurs when I haven't updated anything in the datamart and follow path Transform Data -> Save -> Error Message

Anonymous · ‎08-10-2022

I have a data sort which requires me to apply a couple different filters in the data view. When I open the report I select the first column and apply a filter on my table in data view. Whenever I select the filter button on the next column it automatically is hoping back to the last column I selected not pulling up the filter dropdown on the new column. This is a new issue as of last night and I can not seem to select any column for filtering other than the first one I click on when entering the data view. I have tried uninstalling and reinstalling powerBI but no luck

Kemei · ‎05-09-2023

Created a Power BI Dataflow with the connection to other existing Power BI data flow using "Dataflow" connector, worked in the editing, but failed in refreshing once saved it. Switched the connector from "Dataflow" to "Power BI Dataflow (Legacy)" and worked. Dataflow connector has the issue with connecting to other Power BI dataflow when refreshing data. The refresh error message was "Error: Data Source Error : DataSource.Error: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider error: 40 - Could not open a connection to SQL Server) DataSourceKind = <ccon>PowerPlatformDataflows</ccon> DataSourcePath = <ccon>PowerPlatformDataflows</ccon> Message = <ccon>A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections".

Arie · ‎10-13-2021

After installing the October 2021 update of Power BI Desktop, the layout in the Model view is messed up. The positions of tables in the model view are not situated as it was in the last configuration.

shephaliB · ‎10-25-2022

Hi All, I am getting bellow error while trying to apply the Score Sentiment using AI Text Analytics: DataSource.Error: An error happened while reading data from the provider: 'An internal error occurred.' Details: DataSourceKind=AIFunctions DataSourcePath=AIFunctions Other two text analytics functions( Detect Language & Extract Key Phrases) works fine. Issue is only with Score Sentiment. I am using Power BI Oct 2022 version. Any idea how to fix this issue? Appreciate your help!! Thank you! Shephali

dzfx · ‎06-12-2023

Scrolling a list of items in a workspace makes me dizzy due to the way the list is refreshing itself. It's as if it's constantly trying to repopulate all the items using JS. HELP!

EP1 · ‎10-27-2021

Hi Everyone Is anyone experiencing slow dataflow refreshes? Since this morning, I have a dataflow that is taking very long to refresh. I haven't edited the dataflow for at least a month and it has been working fine up to now. A simple text-inputed table (4 rows, 2 columns) took 15 minutes to update. Another similar table took 27 minutes to update. Both of these tables are not linked to an external data source and should usually take 30s to refresh. I cancelled the refresh after about 2h30. The dataflow was not even half-way through a refresh that normally takes 20 minutes. I aborted the second attempt at refreshing the dataflow after about an hour and the first table (text-inputed, 3 rows, 2 columns) had not yet refreshed.

vpatel55 · ‎03-12-2020

Hello, since the new ribbon interface was rolled out, my Power BI Desktop Pro is completely unresponsive and keeps freezing. I cannot minimise, maximise, or move the window at all. The ribbon is completely unresponsive. Occassionally, it will randomly unfreeze, only to re-freeze. This is affecting all my reports. I cannot get any work done. This is an issue with PowerBI and not my system, I have the latest Core i7 with 32Gb of system memory on Windows 10. All my other apps are fine. It was working fine before the new interface was rolled out. Any help would be appreciated, particularly on how I can roll this back to the previous version.

Share your ideas and vote for future features

Test as role "not supported" message for composite model

PowerQuery - Validating queries when saving is taking excessively long time

Power BI Dataflows not refreshing

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

Bug: Excel Power BI Datasets is showing Blank pane to Users

Cannot create a New DataFlow Gen2

Issue in Parquet connector in the November release

Refresh popup messages (and others) not displaying correctly

Apply changes not working

Dataflow Refresh - Internal Error

DAX Query View - Default German query name is invalid, which prevents entire pbix from getting saved

Alt+Enter behaviour - Alt shortcuts remain active

Bug: Datamart Loading Data Internal Error Code 500 - Failed Runtime Assertion

Column Stuck Selected; Can not filter other columns keeps jumping back to original selection

Bug - Power BI Dataflow with connection to other Power BI data flow fails in refreshing

After the October 2021 update the model view is messed up

Issue with Text Analytics- Score sentiment

BUG - Scroll in the Power BI service is jittery/jumpy

Slow Dataflow Refresh

New Power BI Desktop interface keeps freezing - HELP

Helpful resources

Publish to web url not working

Slicer bug?

TypeConversionFailure when not trying to convert

filter pane values in service are showing in black...

Wrong french translation for "reader" permission