User Profile
varelapablo90
Helper II
Joined 5 years ago
User Widgets
Contributions
Measure returning a different value depending on the visual.
Hello community I have the following situation. I've made a table that should only display information when there is input in 3 key values. These are: - Company Code (a measure returns 1 when this field is filtered) - Supplier (a measure returns 1 when this field is filtered) - Invoice Reference (a measure returns 1 when this field is filtered) 3_way_match is the measure that sums the above measures, if all "mandatory inputs" are given result should be 3 and data table should be displayed, else would be less than 3 and nothing should show up. As you see, despite the result is 2 in the table it returns 3, what could be the reason of this? Table contains no duplicate values, its all unique and very basic star schema. Look forward to hearing from you. Thanks in advanceIncremental Refresh Question & SQL Views
Hello community I have some questions on Incremental Refresh that honestly after going through the documentation, questions already published here & youtube channels I still dont get exactly the answer behind. I've build a report for my organization to see the current status of an Invoice using incremental refresh, thefore I've loaded a lot of data (millions of rows) for for the main table with most information on invoice details, and some other dimension tales with all my suppliers, and payment information, etc. Question 1 For the invoice details the source is a SQL view (not a table) I made querying data from multiple table (invoice,goods, payments) therefore here my understanding here is that incremental refresh does not work with SQL Views, can someone confirm? is there a workaround to make it work? Question 2 For some of the dimension table that contains also a lot of rows (some million suppliers) I've appended a row to each of them so I could have a "XXXX - No Selection" selected for the very first time. Example of how I did this: Table A -> SQL source with incremental refresh Table B -> Manual input data in Power Query Final Table -> Dax union of Table A & B (no incremental refresh) The question here, is the incremental refresh on my Table A working? The supplier information is information that could change at any point in time (adresss, telephone, contact person) so. For it and all the incremental refreshes I am using my "updated_on" column from SQL that contains the date-time the row was modified for the last time. Question 3 (About incremental refresh in general) I've set archieve data for the last 10 years because actually I dont want to archve any data from this table. Incremental refresh last 10 days, this means that we query only the last 10 days from my sql database from my field "updated_on" and compare it to the same rows in PBI and if something changes automatically is updated in PBI (I assume PBI recognizes the KEY columns from SQL, is this understanding correct?) - Rows that already exist are updated - Rows that do not exist are append - What is the behaviour of rows that were deleted? I do not store deleted items in my database And very last question, in MS documentation, blogs and videos it says you shouldnt use the same column used for incremental refresh in the detect data changes. Can someone explain further the background of this? what would happen if I use it? Should I add 2 columns in my database with the same information to avoid this issue? Thanks a lot! look forward to hearing from you!Visual reading images works partialy
Hello community I am having the following issue. I am using cards to display some images of my reports, but some of them when publishing to the workspace randomly are not shown, despite all images are stored in the same source with the same .png or .jpeg format Does anyone know what could be causing this problem?Re: New RLS
Hello I am having this same exact issue and I see no one has replied with a solution answer. Steps are correctly applied. Assign of roles in PBI desktop, but when moving to PBI service in the 3 dots of security can not asign the groups. Does anyone know how to solve this problem and what causes it? I have already applied RLS in other reports, its happening with just one.Visual trying to display all my data despite its filtered by measure
Hello community I am having the bellow issue with a table visual that I dont want anything to be displayed until the user inputs specific information in the report. For this reason I've done a measure to indicate when and when not to display information. Despite the measure works fine, when nothing is selected it loooks as it tries to load all data into the report, can this be fixed somehow? Image 1 Image 2 (Doing only one selection) this is how I would expect to see the table when no Company and Vendor are selected (an empty table) Image 3 when everthing is correct.
