Display Images In Report Bulder using PowerBI dataset
Hello, My goal is the following: I have to display images, stored in PowerBI dataset into SSRS Report. The images were converted to Base 64 format and they are displaying correctly in PowerBI desktop. When I try to load them in Report Builder it's not possible and I receive error. This is what I've tried so far: - First - I select insert image --> the value of the Image with base 64 format. The source is "Database" and MIME type "image/jpeg" - Second - the same thing but instead of the base 64 image I select the text value of the image. Both give no result. I also tried the solutions from this post but they didn't work for me -->https://community.powerbi.com/t5/Report-Server/How-to-display-Base-64-PNG-images-from-a-database/m-p/1177424 Can you plese help with this? Regards, VassilHeader (distinct value) to be displayed in Paginated Report (Report Builder)
Hi, I need to display some name & id as a header. We are allowing only one name to select from filter, when we display as header using text box or table or list, we are getting same values duplicated in multiple rows though only row to be expected. Is there a way on this Paginated Report to display only one value as however I try same value getting repeated in multiple rows. Please let me know if you need more details. Its getting repeated like as in snap below: To be displayed like: Thanks NagNo Fields in Dataset
Hello, I've connected my Report Builder to a Dataset in my premium workspace. It is listed as a data source. The Table Wizard requires connection to a Dataset, so when I try to make a dataset out of this source it doesn't give me any fields to pick from. It's like the data source has no fields at all. I loaded this to PBI Service from PBI Desktop where I've made various reports with it. Any idea why I can't get the fields to show up?
Page break for column groups - paginated reports in Power BI Report Builder
Hi! I am creating a report with some year/month column groups (as below). I would like to have a page break for every year group (not month group) in Power BI report builder. I am able to do so with the row groups, but can't seem to do it with the column groups. Any ideas? Thanks!
Dynamic Paginated Report in Power BI Report Builder
Hello everyone. Till now, I have worked only with Power BI Desktop application. However, now, I need to create a paginated report that will get delivered to users' mailbox automatically everyday. I searched around a little bit and discovered Power BI Report Builder tool. However, I find it extremely unintuitive (compared to PBI Desktop) and the documentation is not as clear as that for PBI Desktop. Basically, I am fetching data which looks like below (from SQL Server) - What I want to do is have a paginated report created which will have X number of pages in it, where X = no. of distinct BUs found in the records. Each page in the report should have the BU name mentioned at the top. The first page should show the Total Aggregated Amount (ALL BUs combined). I plan on showing a line chart on each page. So, for my dataset shown above, the report should contain 4 pages - 1. Total, 2. EX1, 3. EX2 and 4. EX3. Everyday, at a certain time, the report generation process should start and create a PDF of this report and deliever to the users' mailbox. What I wonder is - are all of these things possible with Power BI Report Builder ? If so, could someone guide me through the process of report design. I have tried following a couple of articles I found on the web (links shared below) but no luck getting things the way I want 'em. Any help is appreciated. Article1 Article2 d_gosbell josef78 lbendlin Thanks in advacne, Nachiket P.Report Builder - Query Designer Error
Hello guys. I´m trying to create a dataset on Report Builder using a DAX query from a curren active Power bi Report, and I'm recieving this error. I'm new in power BI Report Builder so iam kind of drowning here. Any help or clue to track this error will be apreciated. Query preparation failed. (Power BI Report Builder) Query (84, 1) The syntax for '<pii>SELECT</pii>' is incorrect. (<pii>
