ssis
4 Topics
SSIS/ SSRS/SSAS confusions
hi I want to know about MS Report builder MS SQL Server Mobile Report Publisher POWER BI Report builder Power bi desktop version Now i want to to practise SSRS / SSIS/ SSAS with power bi .. so on which tool should i practise ? which is latest ? initially first i create dataset on MS Report builder and save on cloud . like on this http://desktop-fn84eoh/RS_WP/browse and then from this i use import databset on MS SQL Server Mobile Report Publisher ... but i face error like "could not connect to data" so i am very much confused.. like power bu desktop has also analysis service option .. so please suggest some correct guideline from which tool should i start.. so many tools so much confusions 😞Solved3.9KViews0likes3Comments
Programatic Rendering and Export of Paginated Reports on PBIRS
Hi, we recently migrated from SSRS to PBIRS, but cant shut down the the old SSRS because of one issue. We need to daily export a paginated report to a filepath in xls. format. The report is parameterized. The result is 50 complex excel files/day with specific naming convention. We achieve this using SSIS and a C# script with ReportExecutionService Class (link). It doesnt seem to be supported on PBIRS. Do you have any idea, how we can programmatically render and save reports from a PBI report server? Thanks a lot in advanceSolved1.1KViews0likes2Comments
