Salesforce Reports Broken when Grouped
As far as I can tell there is no support in Service for grouping by date so as an attempted workaround I created a summary report in Salesforce (technically we use a force.com CRM) that had such grouping. I created a new dataset that imported the regular report and the grouped report and while all the fields are available on the regular report as expected, the only fields available on the grouped report are "Record Count" and "Sale: Net On" the latter of which is the date field used to create the groups in the Salesforce report. What additional information can I provide you to help troubleshoot this issue?
OneLake shortcut to Lakehouse SQL endpoint fails to create table
We have an Eventhouse database with a single table synced to OneLake. We've then created a table shortcut from the Eventhouse to a lakehouse - and everything works as expected: The table is visible in the lakehouse explorer, and can be queried using the SQL endpoint of the lakehouse. All good. A week later we then try to create another table shortcut from the eventhouse (same table) to a new lakehouse (in a different workspace). Now, the table is visible in the lakehouse explorer, but it fails to load the table to the SQL endpoint, giving the error in the image attached. The original (and completely similar) shortcut still works, and can be seen/queried in the SQL endpoint with data up to date. How can a shortcut work, and continue to work, when established at one point in time, but not a week later - when the source and destinations are structurally identical? All workspaces are hosted in the same region (West Europe).
How to add user to a published app without updating the app?
I can not figure out how I can add people to my app without publishing the app with the newest changes? I am under 2nd fase of development of a already published app. I would like to add user app in access tab. But I do not want to published the newest changes I have made to the app, as they are not finalized. What to do? If I add people I can not figure out to "save" these changes without updating the app.
matrix and slicer
I am currently working on a project where in my table i have columns Product Option A and Product Option B which are the costs from the Base QTY column which is all 1. I want to be able to create a slicer to dynamically change my matrix and find Subtotal A and Subtotal B cost based on selected value, So if i elect 7 from the slicer, the New QTY would be 7, which is the value you selected from the slicer. The Base QTY is still 1, but now you have a new QTY value of 7 that you can use to calculate the new Subtotal A and Subtotal B costs. The measures i currently have are New QTY = SELECTEDVALUE('New QTY Values'[Value], 1) * MAX('Overview'[Base QTY]) Subtotal A = VAR NewQty = [New QTY] RETURN IF(ISBLANK(NewQty), BLANK(), NewQty * SELECTEDVALUE('Overview'[Product Option A Cost], 1) ) Subtotal B = VAR NewQty = [New QTY] RETURN IF(ISBLANK(NewQty), BLANK(), NewQty * SELECTEDVALUE('Overview'[Product Option B Cost], 1) ) and I also have a table New QTY Values = GENERATESERIES(1,20,1). The slicer is made with the Value column from that table and all of the measures look correct so why isnt my matrix dynamically changinh? if I choose a value other than 1 the whole table goes blank
