data modeling
4913 TopicsStop Auto update on Power BI Desktop
My team has been experiencing a lot of problems every time there is a Power BI Desktop updates. Our latest problems were - Data Pane flickers/jitters when using mouse scroll - Backend engine update isn't complete during the new update causes my previous version of Power BI not to work!!! This happened to me because I've over 70 tables and over 30 reports tabs. Even the basic command like calculate filter and count function doesn't work!!! This is horrible!!!! My question is how do I stop auto update on Power BI desktop!!!!! Your programmer team when update need to considered the fact that there are thousands of corporate users using your product and every time you update the product, it causes big problem!!! Our Power BI expert is very tired after every new update!!! what used to work in the past now doesn't!!!! You guys better test the program properly before update12Views0likes0CommentsData Pane flickers/jitters uncontrollably during mouse scroll
Power BI Desktop (Oct 2026) - Data Pane flickers/jitters uncontrollably during mouse scroll. The latest version of Power BI Desktop causes a lot of problem. Please update it immediately.!!! Power BI desktop should not have auto update. YOur auto update sucks!!! I have over 100 dashboards using Power BI and your latest update has given me a lot of problems13Views0likes0CommentsLakehouse shortcuts do not persist variables from Variable Library (Connection, Location, Subpath)
I am trying to use variables from a Variable Library when setting up an ADLS Gen2 shortcut in my Lakehouse. Specifically, I select variables for the Target Connection, Target Location, and Target Subpath. The UI lets me pick the variables without any problem, but once I click save, the changes are not saved at all. Expected result: The shortcut should keep the selected variables linked. Actual result: The variables did not appear, and the settings reset to previous values. What I already tried: Tested this across different Lakehouses. Tried both editing existing shortcuts and creating new ones from scratch. The issue happens every time. Is anyone else having this problem, or is this a known bug?77Views6likes5CommentsPower Query Intellisense not working well
Having an 'auto complete' feature in a coding language is great. When it work right. Power Query auto complete does NOT. Try this: Open a query and click the Custom Column on the Add Column menu. The dialog box opens where you input your M language statement. Now type into the formula box "Text.Combine" and see the suggestions it brings up and more importantly WHERE IN THE LIST it places the highlight. If you're fast on the keyboard and hit the TAB key without looking at the suggestion it gives, you will get "TextTable.Combine". What is TextTable.Combine? That's not even a Power Query Function. It an erroneous amalgamation of the FISRT word I typed plus the full command that it chose. Look at the screen shot below and note the SUGGESTED row it highlights (the one it will take if you simply hit <Tab>) as opposed to the one three rows below it THAT IS AN EXACT MATCH OF WHAT YOU ARE TYPING Seems Intellisense cannot match on the entire phrase, but only looks at the last word after the period? After typing "Text." I shouild see a list of all the functions that start with "Text." not ones that start with other words. I see this as a bug5.4KViews7likes8CommentsOption to preserve original text casing for imported text values
Idea. Add a column or model level setting to keep the exact casing of each text value on load, for example a case sensitive option for text columns. Why. Power BI treats text values as case insensitive and shows the casing of the first value it encounters. In a reported example a City column with PunE, Pune, pune and PUNE loads as four rows that all show PunE. This is expected engine behavior, but it surprises people building connectors and models where the original casing matters, for example codes, identifiers or names. Suggested behavior. An opt in setting per column or per model that preserves the source casing and treats differently cased values as distinct, with clear documentation of the storage and performance impact. Benefit. Fewer workarounds such as adding a helper column with a hash or a prefix, and more predictable results when the source data is case sensitive. Source thread (raised by another community member) https://community.fabric.microsoft.com/discussions/power-bi-services/x/536814315Views0likes0CommentsPower query steps can't be edited since Sept 26 update
The overhauled power query editor in power bi is not allowing edits on steps created via the UI. It's bad enough that adding Missing.Ignore disables the edit, but now I can't even reopen a Choose Columns step and change my mind. Same issue on Expand Fields after a merge, and Added Items on a SAP view.21Views0likes0CommentsRegression: Google BigQuery connector loses Native SQL Query UI on gear icon click
Hello Power BI Team, Following the recent updates and the rollout of the new BigQuery connector implementation (ADBC), the Power Query UI is experiencing a significant regression regarding the Value.NativeQuery step. Previously, clicking the gear icon on the "Source" step of a BigQuery connection opened a dialog box clearly displaying the Native SQL Statement, allowing for easy copying, pasting, and formatting. Now, this UI is completely missing or fails to map for BigQuery connections. As a BI Architect, this severely disrupts the workflow. Instead of a clean SQL text box (which is still perfectly functional and stable in the SQL Server connector), we are forced to use the Advanced Editor. This exposes the raw M code, wrapping the SQL in double quotes and converting all line breaks to #(lf), making it extremely tedious to copy/paste the query directly to BigQuery Studio for testing without manual text parsing. The SQL Server connector handles NativeQuery UI mapping flawlessly. The BigQuery connector needs to maintain this same parity and stability. Steps to Reproduce: Step 1: Connect to Google BigQuery and input a Native SQL query via Advanced Options. Step 2: Apply the step, then click the gear icon on the "Source" step to edit the SQL. Step 3: Notice the UI no longer provides the clean SQL input box. Please investigate and restore the Native Query UI parsing for BigQuery connections.17Views0likes0Comments[Fabric Copy Job] Unable to parameterize SQL Database name for Deployment Pipelines (CI/CD)
I spotted an issue with the Fabric Copy Job item regarding the parameterization of SQL Server sources within Deployment Pipelines. Scenario: I am using a Copy Job to ingest data from an on-premises SQL Server to a Fabric Lakehouse. My environment utilizes Deployment Pipelines to promote content from Dev to UAT/Prod. I am attempting to use Variable Libraries to handle connection differences across these environments. The Issue: While I can successfully bind the SQL Server Connection object to a Library Variable, the Database Name field in the source settings does not support parameterization or variable binding. It remains hardcoded. Consequently, when I deploy the Copy Job from the Development workspace to UAT/Prod, the job continues to target the hardcoded Development database name (e.g., fabnavtest1), which is incorrect for the target environment. Troubleshooting Steps Taken: Verified that the Connection ID is successfully parameterized using the Variable Library VL_FDL_Config. Attempted to locate the underlying JSON definition via OneLake Explorer (similar to the workaround available for Dataflow Gen 2 destination issues) to manually inject a parameter, but the Copy Job folder appears empty/inaccessible. Technical Evidence: Below is the JSON definition of the source. You can see that connectionVariableLibrary is set correctly, but the database property is a hardcoded string with no option to bind it to a variable. JSON { "properties": { "jobMode": "Batch", "source": { "type": "SqlServerTable", "connectionSettings": { "type": "SqlServer", "typeProperties": { "database": "fabnavtest1" }, "externalReferences": { "connectionVariableLibrary": { "variableName": "SQL_CONN_ID", "libraryName": "VL_FDL_Config" } } } } } } Impact: This prevents the successful use of Deployment Pipelines for Copy Jobs using SQL Server sources, as we cannot dynamically change the database target per environment. Thank you for your help236Views2likes1CommentData pipeline stored procedure activity connections not updating
I have a data factory pipeline with an activity that runs a stored procedure in a warehouse in the same workspace. When run in dev, it works fine, but after deploying to test using deployment pipelines and attempting to run the data pipeline in test, I get the below error: The server address (ending ho4e) referenced in that message is the dev workspace, but when I investigate the connection settings node in the test pipeline's JSON, I see that the server address is: The server address ending oxdey is the correct address, i.e. the test workspace, so the deployment pipeline has in fact updated that, but something is still in place attempting to connect to the dev workspace. I added a single space into the whitespace of the JSON, saved and reran, and the connection was made successfully and the pipeline was able to complete. I don't believe the error message is correct either - it uses my personal Warehouse connection in both cases, which is not dependent on workspaces. Clearly a bug! Repro steps: Create a Warehouse in a dev workspace Create a stored procedure in that Warehouse Create a data pipeline in the same workspace Add activity to pipeline to run that stored procedure Run in dev workspace Run deployment pipeline to deploy to test workspace Run data pipeline in test workspace18Views1like0CommentsCMD Prompt Popping Up During Changes
Hi all, I’m seeing recently a recurring issue in Power BI Desktop where a brief CMD window appears during report load and sometimes during semantic model-related changes. After digging into it, I found that the CMD window is actually SQLDUMPER.EXE. From what I understand, SQLDUMPER.EXE is a Microsoft diagnostic utility that gets triggered when an internal Microsoft component crashes or throws an exception. In this case, the actions seem to be tied to msmdsrv.exe, which is the backend model/query engine used by Power BI Desktop. What the issue looks like The black CMD window appears briefly. It first happens while the report is opening, specifically during “Preparing report”. It can also happen later when making changes that affect the semantic model, for example renaming a field or making other model-related modifications. The issue does not seem to be a simple visual/UI problem. It looks more like the backend model engine is hitting an exception and SQLDUMPER is collecting a dump. My troubleshooting so far Confirmed the CMD window is SQLDUMPER.EXE Using process monitoring, I confirmed that the CMD window is SQLDUMPER.EXE. Looking deeper, the process triggering it appears to be msmdsrv.exe, which is the Analysis Services/model engine running behind Power BI Desktop. No issue with a PBIX that has no external file connection In my tests, the issue does not appear when the PBIX contains only embedded data and no external data source connection to a file. You can simulate it just entering a dummy data using "Enter Data" in power bi. Issue will not happen on those reports. Happens in both Store version and downloaded version I tested both: the Microsoft Store/App version the downloaded installer version The issue happens in both. Preview features do not seem to be the root cause Turning off some preview features, such as On-object interaction, seemed to reduce the frequency somewhat, possibly because they trigger semantic model changes more often. However, this did not solve the issue completely, so I do not think this is purely a preview feature problem. Cache clearing and fresh install did not fix it I tried: clearing cache fresh installation switching to the downloaded version None of these resolved the problem. Running Power BI as Administrator prevents the issue While investigating logs, I noticed some apparent file access-related problems involving msmdsrv.exe. That led me to try Run as administrator. When I ran Power BI Desktop as Administrator, the issue did not appear. I even turned all preview features back on and tested again as Administrator, and it still did not happen. Moving the PBIX to a simple local folder did not help I also moved the report to a simple folder path such as: C:\test. This did not solve the issue. Current conclusion So far, on my machine, the only thing that prevents the issue is running Power BI Desktop as Administrator, which is obviously not a real solution. At this point, I suspect this may be one of the following: a Power BI Desktop bug a permissions / file access / credential issue something related to external data source connections possibly some interaction between the local Analysis Services engine (msmdsrv.exe) and file-based external sources Main questions Is anyone else seeing SQLDUMPER.exe appear during “Preparing report” or during semantic model changes? Has anyone identified the exact trigger? Has Microsoft acknowledged this anywhere? Is there any proper fix besides running Power BI as Administrator? Thanks in advance. I’m sharing this in case it helps others narrow down the issue.5.8KViews35likes16Comments