Help with relationships: visualizing comparison of two datasets
I'm working on a project where I need to compare two similar tables with several columns/attributes; let's say "Table A" and "Table B". Both are imported as CSV files. When trying to visualize the comparisons of specific attributes of A and B, I find that they are only properly graphed when there's an active relationship between the two necessary columns; I can't have more than one active relationship between two tables, and graphing data with an inactive relationship shows one of the two attributes incorrectly as nearly a flat line/with constant values. The closest solution to this problem I've found is that I can import copies of the tables (one copy of each table per attribute I want to graph), then draw active relationships between the necessary attributes. However, I can then only draw active 1 to 1 relationships between the copies either Set A or Set B, but not both because it results in ambiguity? This results in filtering only applying to one of the two tables, not both. I have no experience with DAX or SQL, and I've been teaching myself Power BI via poking around and documentation for only a few days. I've got some Excel experience, but my boss wants this done in Power BI as the dashboards are (absolutely) much nicer to use. How do I make these two tables easy to compare in graphs? I'm struggling to understand data relationships and how to properly make use of them within Power BI.
Dataverse connection error : DataSource.Error: Microsoft SQL: Error code 8657
Hi all, Hope someone can shed some light on this issue I am having. I inherted a PBIX file which is connected to a dataverse backend using the new connector , CommonDataService.Database When I perform a refresh I get a DatabaseSource connection error "DataSource.Error: Microsoft SQL: The service has encountered an error processing your request. Please try again. Error code 8657." The error is occurring at the Navigation step of a query which is part of the staging process, so there are no major transformations involved. There are only two steps in the query - Source and Navigation Here is the full error message with the source url hidden DataSource.Error: Microsoft SQL: The service has encountered an error processing your request. Please try again. Error code 8657. A severe error occurred on the current command. The results, if any, should be discarded. RequestId: TDS;bc1c4f65-7a54-45e5-a81e-6a09cd305ea8;4 Time: 2026-08-03T03:26:44.7380879Z Details: DataSourceKind=CommonDataService DataSourcePath=<<hiddenURL.com>> Message=The service has encountered an error processing your request. Please try again. Error code 8657. A severe error occurred on the current command. The results, if any, should be discarded. RequestId: TDS;bc1c4f65-7a54-45e5-a81e-6a09cd305ea8;4 Time: 2026-08-03T03:26:44.7380879Z ErrorCode=-2146232060 Number=40001 Class=16 State=1 ConnectionId=bc1c4f65-7a54-45e5-a81e-6a09cd305ea8 Here is the m code of the query let Source = CommonDataService.Database("<<hiddenURL.com>>", []), dbo_msdyn_project = Source{[Schema="dbo",Item="msdyn_project"]}[Data] in dbo_msdyn_project My model has other queries which seem to work fine, but they use CDS.Entities as the source which is the legacy connector ( correct me if I am mistaken on this ). Thinking that this could be the cause I tried a new report connected to the dataverse using the same M code above but I still get the error What could be causing this ? Any help will be much appreciated! Edit: I also had a look at this similar post here https://community.fabric.microsoft.com/t5/Desktop/Dataverse-table-failing-to-load-in-Power-BI-and-Excel-with-Error/m-p/5301932
Retrieving Values from Single Column
Hi, I have the following simple table in my Datamodel: Month Active caseload 01 March 2026 100 April 2026 125 May 2026 148 June 2026 178 July 2026 198 August 2026 September 2026 In order to retrieve the first Active Caseload figure of 100 I use this measure: 2026/2027 Start Total = FIRSTNONBLANK ( Caseload[Active Caseload], SUM ( Caseload[Active Caseload] ) ) Is this the best function to use? I also want to retrieve the last figure (198) and the penultimate one(178) from the Active Caseload column, with the aim of using conditional formatting showing a triangle icon showing up / down, depending if the active Caseload rises or drops compared to the previous month in a Card visual. What are the most efficient measures I should use to get something as simple as this? Ps: I tried pasting my code into the 'Code' selector and it didn't work, I'm hoping this and other issues resolve themselves tomorrow when I have the Aug version installed. I cannot paste screenshots either so I've had to draw this table - what a mess. ThanksSchool tutorial not the same setup as my Power BI application
I'm watching a tutorial video from my school on how to use POWER BI. I've downloaded an example file they've provided so that it should have all the revelant data already inserted. But as I'm following the steps, the Power BI in their video does not look the same as mine and so I can't properly follow the steps. The image on the right (with the red circles) is from the school tutorial and has the steps that I am suppose to follow. The image on the right is what my Power BI looks like. The paint roller icon isn't even there and the dropdown options aren't the same. I've followed all previous steps exactly, so I'm not sure why my version doesn't look like theirs.
Capacity Utilization Reporting by Entity
As a Power BI Administrator, I want to access weekly and monthly utilization data from the Fabric Capacity Metrics app, So that I can analyze how much percentage of shared capacity is consumed by each entity on a daily or weekly basis, enabling better resource planning and performance monitoring.
BigQuery Connection Using DEV Project Instead of PRD
I'm encountering a connection issue where my query is intended to use the production project prj-gcp-bq-sharing-prd-rti However, when the query executes, the error message shows that it is trying to access a table in the development project instead: prj-gcp-bq-sharing-dev-rti:P_GENERAL_VIEWS.F_SUBSCRIBER_EVENTS Resulting in the following error: I've tried with and without the preview feature, none is working. ODBC connector works fine tho. Any ideas?Anyone know how to get all data from Dstny?
I do not use a Datawarehouse by connect directly through API. My problem is that I get a lot of missing rows no matter how I alter things in the m-code. I have no clue on what to do now. Through postman evenrything looks fine, but through Power BI I get all sorts of errors that Dstny support don't get, and they say it is Power BI and not their service. So if anyone have any helpful knowledge using Dstny plz respond.Japanese Localization for Existing Power BI Reports – Feasibility and Effort
Hi Team, We currently have a set of existing Power BI OOB reports developed in English for a US client, and we are planning to deploy the same reports for a Japan client. The database structure for Japan is expected to be similar, but the client requires the reports to be localized in Japanese. We would like to understand the recommended approach for supporting Japanese localization for the following report elements: Report/page names Table/Matrix column names Slicer and filter names Visual/chart titles Text boxes and other static text Tooltips Measure names / field names Our intention is to reuse the existing English reports rather than maintain completely separate report designs for US and Japan. Could you please advise: Can all the above report elements be localized into Japanese in Power BI? What is the recommended approach — Translations Builder/model translations, a translation table with DAX/dynamic titles, or another method? Are there any Power BI elements that cannot be dynamically localized or require manual changes? Can the same PBIX support both English and Japanese based on the user's locale/language? For an existing report that was originally developed only in English, how much development/rework is typically required to make it localization-ready? Once the Japan database is ready, what areas should we consider when estimating the effort to deploy/localize a complete set of existing OOB reports? We are trying to estimate the feasibility and deployment effort before committing a timeline to the client. Thanks in advance.Power BI Dekstop Issue
Dear Team, I'm unable to launch Power BI Desktop on my Windows 10 laptop. Power BI appears in Task Manager as a running process, but the application window never opens. I have already updated Windows 10 to version 22H2 (OS Build 19045.6466), restarted the laptop multiple times,reinstalled Power BI Desktop from Microsoft's official website, and confirmed that Microsoft Edge WebView2 Runtime is already installed. I also checked Event Viewer and found an event related to PBIDesktop.exe. Could you please advise whether you have encountered this issue before or whether there is another way to troubleshoot Power BI Desktop startup. Any guidance would be greatly appreciated.
