KPI Visual on SSAS Model doesn't work anymore
Hi all We have installed SSAS 2019 on a server and have the Januar 2021 Release on PBI RS installed. The KPI Visual doesn't work as expected anymore since the update to the actual PBI RS Release. I found a machine with the October 2020 Release of Power BI Desktop, where the KPI visuals are displayed correctly: After the update to the January 2021 Release I see the following: As you can see, I use exactly the same pbix file. The first two KPI Visual (from left) uses Measures from the SSAS model. You can see that the comparison value is no longer displayed. The third KPI Visual uses local Measures, which works correctly. Furthermore, SSAS based Measures, which are formatted as percentage, are not shown as percentage since last year. I posted this issue here: https://community.powerbi.com/t5/Report-Server/KPI-Visual-in-Life-connecton-doesn-t-show-Percentage/td-p/1541322 We have a lot of PBIX files, which are using SSAS based Measures. We cannot replicate all measures into the pbix file. This is not practical. Has anyone experienced this issue already? Regards SalvatoreKPI Visual in Life connecton doesn't show Percentage
Hi all We have a lot of KPI Visuals displaying Measures formatted as Percentage. All was OK, until the last update of PBI RS. Since the Update, the KPI Visuals are showing decimal number only, but no Percentage. When I look at the Data (Show data) all looks OK This happens only when I access an SSAS model with a live connection. When I create a new PBI File in Import modus all looks OK. Has anybody experienced this as well? Any help is greatly appreciated. SalvatoreDatasets for KPI's in Power BI Report Server
OK, I've been recreating content from Power BI service on our local Power BI Report Server. I've been struggling with the limitations of Report Server and currently I can't figure out how to create a dataset for a KPI. I need to put KPI's in my report folder because Report Server doesn't support dashboards... argh! When I try to create a KPI, I'm prompted for a dataset, but unlike Power BI service, there are no datasets on the report server to support the reports... argh! When I try to create a dataset, PBI Report Server opens SQL Server Report Builder, which won't work for me because I'm connecting to an Oracle database... argh! It seems like Power BI is an afterthought on Report Server. Can anyone help me create a dataset as an import from the Oracle database so I can use it as the dataset for a standalone KPI in the report folder? Thanks in advance!RLS for PowerBI report server Paginated Reports and KPI
Hello All, I am trying to create a dashboard kind of user experience in powerbi report server using KPI's and Paginated Reports using SQL Server Report Builder. I did created some KPI's and published on to our powerbi Report Server. But i would like to restrict the data at user level, like as we apply RLS in Cube or Reports by creating Roles and giving access to them based on their username. Is RLS is available on PowerBI report server KPI's or paginated reports. If it is possible, then please guide me. Regards, Mohan V.
