Recent Discussions
Removing Duplicates from a Member Filter
Hi All, I have the following use case whereby in my parameter, I have a member list of C#Local,C#USD,C#JPY,C#|WFText2| whereby WFText2 will be currencies/consolidation members eg. CNY,EUR,SGD,USD,JPY Is there a way to filter the member list to remove duplicates such that if WFText2 is USD, the memberlist will return C#Local,C#USD,C#JPY instead of C#Local,C#USD,C#JPY,C#USD Any help is appreciated, thanks!
Quick Views in excel add-in disappearing
Has anyone ever come accross and issue where you've built out a quick view in excel to either faciliate reporting or to input values into a planning scenario and you open the workbook to refresh the quick views and they are all #refresh with the links broken? The quickview POV is greyed out as if its no longer there. I've tried refreshing the page, workbook/closed excel and restarted... Any solutions or troubleshooting would be appreciated!!!!
Unable to schedule refresh through Power BI Service
Hello OS Community, We are building Power BI dashboards using the new Power BI connector for OneStream. We can successfully retrieve OneStream data through the connector in Power BI Desktop. However, after publishing the .pbix file to the Power BI Service, we are unable to refresh or schedule a refresh from the service. We reached out to Microsoft, and they indicated that this is a third-party connector (Power Query OneStream connector - Power Query | Microsoft Learn) and redirected us back to OneStream. We also contacted OneStream support but have not been able to resolve the issue. I’m curious if anyone has had a similar experience and found a resolution. Below is the error we received: "Unable to update connection credentials. Failed to login with OAuth token, please update the credential manually and retry. Details: [DataSource.Error] Unable to connect to the remote server Please have this information handy if you choose to create a support ticket. Session Id: 0bd10fb7-cdd7-4519-8d3c-244e692fcc4b RequestId: 1faeb721-27d0-4928-aab3-539aeea6d2fd Cluster URI: https://api.powerbi.com Status code: 400 Time: Thu Nov 20 2025 12:42:05 GMT-0700 (Mountain Standard Time)"
Chart drops to zero instead of showing no data
Hi, A dynamically calculated KPI returns "Nothing" for future months in the Actuals and therefore I expected the line in the advanced chart to stop at the current month. However, it's not doing that, instead it is dropping to zero, creating a rather undesirable effect. I can't imagine that this is the default behavior of OneStream. Am I doing something wrong? Did I overlook a setting or is there another way to prevent the drop to zero for non-existing data?Open table as spreadhseet in dashboard
Hi everyone, I was wondering if anyone knows a way to open a table as a spreadsheet in a dashboard, allowing the user to create, remove, and edit the rows as a traditional spreadsheet. I already use the SQL table editor for updating tables, but it's not very user friendly, especially when the user has to add many rows. Any help is appreaciated!
