questions

40 Topics

Is Direct Query better ?
I personally find Direct Query more flexible, what do you all prefer ? Below article has some more insights https://medium.com/@rishabh.gulati_94109/microsoft-fabric-direct-lake-is-fast-good-data-architecture-is-faster-340276de2e6b
ipkus
7 days ago Place Health and Life Sciences
14Views
0likes
0Comments
Stacked Column Chart Data Limit Issue
I am encountering an issue with a stacked column chart in Power BI. Even though my data source only contains 200 rows, I'm still seeing the "i" icon (indicating a data limit issue). My x-axis shows phases, and my y-axis represents indexes (used as the legend to create the stack). I need the columns to be stacked as they currently are, but I'm unsure why this error is occurring with such a small dataset and how to resolve it.
Solved
a-r-e-8-1
1 month ago Place Health and Life Sciences
13KViews
4likes
7Comments
Anybody knows the General Availability of datamart?
Hi, I love datamarts. It is a great solution for medium sized entreprises. It allows to replace the DBA in most projects and to develop at maximum speed. The functionnality is still in Preview. Does anybody knows when it will be General Availability? Do you see any risk of deprecation? thanks
Solved
JoelGagnon
2 months ago Place Health and Life Sciences
7.9KViews
3likes
5Comments
Create key for lookupvalue
I want to return the value of Historie in table 1, using lookupvalue. I need to create Klantnummer + Artikelnummer to search in SleutelHistory . What formula can I use to create this key? This will result in this column:
TomBrilliant
2 months ago Place Health and Life Sciences
8KViews
1like
2Comments
Healthcare Semantic Model
Hello all, I have been having some difficulty trying make the most efficient semantic model I can for my report. I'm finding a classic star schema to be challanging due to the content of my data. I'll do my best to summarize the organization of the data, in hope it can generate some ideas. General list of tables: Person_MRN (MRN as PK and Person_ID as FK) Person (Person_id as PK and wider table about the person) Condition_occurrence (features Person_ID, Visit_occurrence_id, diagnosis vist info) procedure_occurrence (features Person_ID, Visit_occurrence_id, procedural vist info) visit_occurrence (visit_occurrence_id as PK and care_site_id as FK) care_site (Care_site_id as PK) The design of my report is just to identify the distinct count of MRN with a filter selected condition and/or procedure, and the care site breakdown of those meeting the filter requirments. I am asking to map MRN -> condition_occurrence.person_id -> visit_occurrence.visit_occurrence_id -> Care_site.care_site_name but I also need MRN -> procedure_occurrence.person_id -> visit_occurrence.visit_occurrence_id -> Care_site.care_site_name since patients have more than one condition and/or procedure, I have to map through the visit_occurrence_ID's in order to capture the unique visits. There could even be a case where a distinct MRN with a distinct procedure was seen at more than one care site. I tried to make views to coalesce the information, but I haven't found the perfect fit yet. Any thoughts are appreciated!
Solved
Clowson
2 months ago Place Health and Life Sciences
19KViews
3likes
3Comments
Copilot ValueError: Schema healthcare1_msft_bronze.substancedefinition is too long to be added in NB
I am trying to use Copilot in a notebook in my HLS public preview workspace. I get the following error when I execute the Copilot package installation cell. Any advice on how I can address this? Thanks. ValueError: Schema healthcare1_msft_bronze.substancedefinition is too long to be added to the vector store.
sharp1FL
2 months ago Place Health and Life Sciences
6.4KViews
1like
3Comments
Data analysis
How to Analyze which product segments contribute most to profit. Use measures to calculate profit margin %, and add conditional formatting in visuals based on performance thresholds.
Lubna-Gafer123
2 months ago Place Health and Life Sciences
13KViews
0likes
5Comments
Show whole year while slicing on one month - DAX
Hello, I am trying to get whole year for a diagram when using the filter "month year". For example when using the filter 202201 I want the whole 2022 to result in values for my diagram. How can I do that? I have one date table "Calendar" and I have one Sale table "DimSale". Greatful for all help!
powerBI_User123
10 months ago Place Health and Life Sciences
6.6KViews
0likes
3Comments
Suggestion for creating editable Word reports (not using report builder)
Hello I'm crowd sourcing suggestions for creating editable reports in Word that don't use report builder. A bit of background for context. I do all of the reporting across our state for a hospital program. Our sites input data into a centralised data management system (REDCap), I then export this to Power BI for reporting purposes. The reporting fields and visualisations are standardised, but our sites like to tailor the reports, so I provide the report in Word. Ideally I'd use Power BI Report Builder to do this, but for the life of me I can't get it to work (even with the help of Copilot), so I've given up on this as a solution. Currently I'm copying each visualisation from Power BI using the 'copy as image' function and pasting into word. This is quite time consuming because of the rendering time and I can't control the formatting of the output. How would you do it? Thanks!
Solved
AngelaB
1 year ago Place Health and Life Sciences
5.8KViews
1like
5Comments
Automating API link updates
I've been using PowerBI to directly import a web API to get up-to-date clinical trial information for my dashboard (from Clinicaltrials.gov, example link with 2 random studies here: clinicaltrials.gov/api/v2/studies?postFilter.ids=NCT07123961%7CNCT06868654&pageSize=400). Previously if I wanted to add a new study, I'd just concaconate it to the link with %7C (for example, to add study NCT06354998 I just do clinicaltrials.gov/api/v2/studies?postFilter.ids=NCT06354998%7CNCT07123961%7CNCT06868654&pageSize=400). Now I have a growing list of studies on an excel sheet that I want to add to this API, how do I do it without manually going into the advanced editor each time to add a new NCT number to the API link?
Solved
tiannie
1 year ago Place Health and Life Sciences
13KViews
1like
2Comments