[help needed]
5 TopicsSortorder in Report Builder
Hi, In Power Bi I have a FactTable of 227 project records with Start Dates starting from 1 Jan 2017 till 26 jan 2023. In PQ i added an Index Column starting from latest Start Date 26 jan 23 (Index 1) till 1 Jan 2017 (Index 227) . I am loading in Reporting Builder 5 fields from the PowerBI dataset: Year (=YEAR([Date])) ClientType (text) Location(text) Project (text) Sector(text) using the Query EVALUATE SUMMARIZECOLUMNS('ReferenceList'[Year], 'ReferenceList'[ClientType], 'ReferenceList'[Location], 'ReferenceList'[Project], 'ReferenceList'[Sector]) In Report Builder a Tablix is used and all 5 Fields are dropped in the Value box The issue: The Sorting Order is not correct. There are 5 pages and 46 lines per page. The first 3 pages is in ascending order till 1 jan 2017. But then the Project Years start with 2021 , then 2020, then 2019, then 2022, then 2022 , then 2018...later 2023 the year are all over the place. How can I force a sorting order (descending from Start dates 2023 -> 2017) either at the source data or in the Query ? Many thanks !Solved1.2KViews0likes1Comment[HELP NEEDED] Intermittent error while opening report
Hi All , We have a report connecting to HANA Views in direct query mode and it throws the below error sometimes while trying to open the report on the report server . I have saved the credentials in the data souce properties in the report. "Something went wrong" "We couldn't connect to the Analasys Services server.................." This happens sometimes and it works well other times . Thank you.589Views0likes0CommentsReport on the report sever taking too long to open
Hi All, Reports on the report sever using direct query mode connecting to HANA source gets stuck with loading message. It is almost stuck at the same point for more than 15- 20 mins . It opens correclty when opned on the desktop. Please help provide inputs on what needs to be checked. Thank you628Views0likes1CommentSSRS report error on Power BI report server
Hi All , We have a SSRS report that is hosted on Power BI platform . The report connects to Teradata source and is passing parameters which is selected in the como box to the query in the WHERE clause . The report works fine with single value is selected in the drop down but gives error when 2 or more values are selected . Error : [.NET Data Provider for Teradata] [110083] A null has been specified as the Value for a parameter. The same report works fine when hosted on the SSDT. Could this be an issue with the provider on the Power BI platform ? Thanks !540Views0likes0CommentsUnable to upload pbix file to report server
Hi All , I am able to open the pbix file on the desktop but unable to upload it to the report server . I was able to upload it few days ago but not now . I have developed it on August2018 desktop . The report server shows Jan 2019 version . I installed Jan 2019 desktop version and saved the report on it and try to upload it . Still facing the same error . Thank you.Solved2.1KViews0likes1Comment