Power BI turning uppercase to lowercase on a text column import and compression
Power BI desktop is definitely converting uppercase characters in a text field to lower case when importing directly from an SQL view and compressing. This may be some sort of data cleanse performed when compressing. A worked example has a text column as a 53-character word with each character being different depending on business rules. A specific simple data set could have 366 rows of this column, called WeekPresenceMap 363 rows are this with a lowercase m, in this case in position 13: "000000000000m0000000000000000000000000000000000000000" and 3 of this with an uppercase M in position 13: "000000000000M0000000000000000000000000000000000000000" In other words, character 13 in 363 records is a lowercase "m" and an uppercase "M" in 3 records When the 3 with uppercase were imported as a small table of 3 rows, power BI saved them correctly. When the whole 366 rows were imported, Power BI converted the uppercase M to lowercase. There is a major issue here as, in my business rules, the uppercase M has a business rule meaning a "Win" where a lowercase m means a "Loss" for that week, week 13, so completely changing the meaning. I suspect that the similarity of the 2 values caused the text compression engine to save to just the one value that appeared the most in the column
Field parameters or calculation groups for switching measures: how do you decide?
Hi all, We are trying to standardize how report authors let users switch measures in a visual, and the team is split between field parameters and calculation groups. My current understanding is that field parameters are better when the user wants to choose which measure or column a visual shows, and calculation groups are better when you want the same logic (time intelligence, currency conversion) applied across many measures. Is that how you split it? A few things I would like to know from people who have done this for real: 1. Do you ever combine both in the same model, and did precedence become hard to debug? 2. How do you document them so report authors do not get surprised by hidden logic? 3. Did you see any performance difference on larger models? Thanks!
What am I missing?
I am having trouble getting the first column(branch count) to respond to Slicer changes. Using this sample data I would like Branch Count to change from 4 to 2 when I set the "Active" Slicer to "Y". There are no relationships in my model, this is coming from a single data source. My Measure for Branch Count: Branch Count = CALCULATE( COUNTROWS('SQL_EOB_Forms'), ALLEXCEPT('SQL_EOB_Forms','SQL_EOB_Forms'[Branch]))Embed token refresh for long-lived sessions: how do you do it in a SPA?
Hi all, We embed Power BI reports in a single-page app for external customers (app owns data), and people tend to leave the page open for hours. I know embed tokens expire, so I want to refresh them before that happens without the user noticing. The plan is to schedule a refresh a few minutes before expiry and push the new token into the embedded report: const refreshAt = Date.parse(token.expiration) - 5 * 60 * 1000; setTimeout(async () => { const fresh = await getNewEmbedToken(); // our backend await report.setAccessToken(fresh.token); }, Math.max(0, refreshAt - Date.now())); Is that how you do it? How early do you refresh, and what do you do when the refresh call fails (retry, or just reload the visual)? Also, if there are several reports on one page, do you update each one separately? Thanks!
Dynamic Latest Month Selection in a List Slicer
Hi everyone, I've gone through a few existing discussions but haven't found a concrete solution, so I'd like to get some opinions on the following scenario. Requirement: I have a List Slicer using an MMM YYYY date field, configured for single selection. The issue is that when the dataset is refreshed and new month's data becomes available, the slicer selection does not automatically move forward to the latest month. Workaround I've explored: The List Slicer provides an option to display separate Values and Labels. Leveraging this, I created a substitute column with the following logic: The latest available month is tagged as "Latest Month". All other months retain their respective month-year values. In the slicer, I use the substitute column as the underlying Value and the original MMM YYYY date column as the Label. I then turn off the display of Values and keep Labels visible. This allows the user to see the actual month-year (e.g., Nov 2026) while the underlying slicer selection remains "Latest Month". Since "Latest Month" is a persistent value across dataset refreshes, the selection should remain intact, while the displayed month-year automatically updates as new data becomes available. My questions: Is this a valid and reliable approach to achieve dynamic latest-month selection? Are there any potential caveats or side effects with this approach, particularly concerning persistent filters or slicer behaviour? Is there a more native or recommended way to achieve this in Power BI without relying on a substitute column? Would appreciate any insights or alternative approaches. Thanks!
Change Semantic model
i am using two workspaces test and prod for power bi, one of the report in prod workspace is pointing to semantic model located on test workspace instead of pointing on to prod semantic model, the report is used in app, if i change the semantic model of the report from test to prod then will it change the report id, i do not want to change the report id used in app, if yes then is there a better way to switch underlying semantic of report from test to prod without changing the report id? The report is pointing to live semantic model on test workspaceUpgrading to Azure Map component breaks PDF Export
Hi, I have received notification to upgrade my reports to use Azure Map component. The problem is: - Is 10x slower than the old Map component; - When exporting to PDF the data is not presented on the map. Some times the terrain is not rendered, other times is an empty map without bubbles info; When in PowerBI desktop, the data is shown correctly, if we give time for the data be loaded. Since, I have a big report files (+90 pages), the map data lost is cache, so when exporting process reach the map pages, it starts loading again and skips to the next page after a few seconds... creating a page with bad info... Seems like the pdf export process is not giving enought time for the azure map component rendering all the information; Is there any workaround for this problem? Thank you
Combining Two Power BI Dashboards into One Report
Hello, I currently have two separate Power BI dashboards/reports, each connected to its own data source. I don't need to merge or combine the underlying data sources. What I'm trying to achieve is having copy the pages with my visualizations so users can access everything in one place. Is there a way to bring the pages/visuals from one report into another without having to rebuild them manually or merge the datasets? Ideally, I'd like to keep the existing data connections and simply consolidate the reporting experience. Has anyone done this before, and what would be the recommended approach? Thanks!Error to refresh Power BI in service online.
Over the past week, I’ve been having a lot of trouble refreshing my BI reports in the online service. For some dashboards, the refresh process throws an error, yet the error disappears when I perform the refresh on my desktop. The behavior is inconsistent—sometimes the BI report refreshes online, and other times it fails, with no discernible pattern. The errors I receive either indicate a lack of memory (which is impossible, as the dashboard is relatively small) or claim that columns are missing from the dataset (which is also impossible, given that the report refreshes in under five minutes on my desktop, with all columns present).
Need stacked Bar chart in Table
I have 2 measures named admission and readmissions. My requirement is instead of showing these 2 measures as separate fields in table visual and turning on data bars I want them to show exactly like in attached image inside the table visual. Please let me know how I can implement this in power BI. In the same table visual i have 3 columns one is dimension which will change dynamically based on user selection and readmission/admission is second field and 3rd field is also a measure which change dynamically based on selected metric.
