power bi report builder
60 Topicscopy paste list of values in power bi report builder prompt (In Multiselect parameters)
copy paste list of values in power bi report builder prompt (In Multiselect parameters) I have powerbi report builder report which is having project number as defined as multi select parameter value and it has 40k values which are listed down in the drop down list. But wanted to select 500 values out of it. Manually selecting one by one with pressing control is tedious manual work. Also tried with alt+tab keys which is working, but selecting 500 values is time consuming. Is there any way can we enter those values or simply copy paste with comma seperated from excel or notepad into prompt values? Please help Which is possble in SAP BO multi select PromptSolved2KViews0likes4CommentsPower BI Report Builder
I am facing some challenges in the Power BI Report Builder . I done the connectivity the datasource and created the dataset for the same , but when I drag and drop the columns to the designer and try to run the report data is always showing empty , The same report when I export the data is displaying , this happend only in the designer and run the report Kindly let me know any Suggestions for the sameSolved1.3KViews0likes5CommentsMatrix Page Scaling/Setting Static Matrix Width in Power BI Report Builder
I need to create a table that can vary widely in its rows and columns, depending on our customer. A table might be anywhere from 2 to 20 rows/columns and a customer could have 1+ tables, and it needs to be printable to PDF. I usually work with Power BI, but since there were a lot of dynamic parts to this report, it sounded like Report Builder was the way to go. I’ve been working with Report Builder for a bit now, but I’m running into an issue where my Matrix’s columns in Report Builder are overflowing to another page when there are too many columns, making the printable report look very messy. Is there something I can do to fix this? I can only make the font so small, and on tables that don’t have a lot of columns, having such a small font looks silly. I was hoping for something like scaling the matrix to fit to a page or setting a fixed max width, but I haven’t run into any useful info. I’m only worried about keeping all the columns on one page, not the rows.Solved821Views0likes3CommentsPreview not working in Power BI report builder
Hi community, when I insert a text field into a newly created report in power bi report builder, it doesn't show up in the preview, but it does when exporting to pdf. Why is it not previewed? I have also created completely new reports, checked text field properties... Thanks! Edition Windows 11 Business Version: 23H2 German Windows Feature Experience Pack 1000.22700.1055.0 Power bi report builder Version: 15.7.1813.16Solved1.6KViews0likes4CommentsCan Power BI report Builder connect to Azure Databricks?
Hi all, I am working on migrating SSRS reports to Power Report Builder. The data source is Azure Databricks, and I need to know if Power BI Report Builder can connect and refresh the data connecting to azure Databricks. Thanks, KavithaSolved2.2KViews0likes2CommentsPower BI Report Builder Not Formatting Numbers (Currency) Correctly
Greetings! I have table visual with several number columns that I need formatted as currency with a thousands comma separator. However, I when I select the options in the quick format poriton of the ribbon, nothing happens. Furthermore, when I try to apply these options individually at the column level, the sample output is displayed correctly, but the report output is incorrect (just a number with no currency symbol or thousand separator, only a decimal). Any help is greatly appreciated.Solved2.2KViews0likes3CommentsPower BI Report Builder: group unrelated data
Goal: Hi, I am a bit unfamiliar with Power BI Report Builder/ Report Server. The goal is to have multiple datasets "grouped" by one multivalue parameter for a print out based on a selected multivalue parameter. Example - FarmHouse: I have multiple chickens from my chicken dataset who own multiple eggs on an egg table. They also store which henhouse they are from in a henhouse table. I would like to select multiple chickens and display a print out per chicken of their eggs and henhouses grouped per chicken. Contraints: Power Bi Datasets DAX Problem: I cannot have static inner members when grouping or encapsulating data that is unrelated. At base, data is unrelated within Report Builder. I have had some success using TREATAS to relate/filter results in a single example, but that is as far as I have come. Any suggestions, advice, resources, or questions are welcomed. Thank you!984Views1like2CommentsPower Bi Report Builder using Power Bi Data Model
Hi All, I am using Power Bi report builder that is pointing to a PBI data model. When I click on Query Designer it sometimes shows me options to drag drop the required cols and sometimes it just shows me the option to write the DAX. When I then want to change this to Design Mode then I lose all my existing code. How can I stop this from happening please.Solved879Views0likes1CommentNavigation to other pages in Power BI report builder
Hi Team , We are using Power BI Report builder for designing the paginated reports and finally we render it using the PDF format in our respective application . We have one specific requirement where we have one icon in the first page and on click of the same , it has to navigate to last section of the report . We tried using the bookmarks and since bookmarks doesnt render in the PDF format , we are not able to achieve this particular requirement . Hence request the team to suggest some solution through which we can achieve this particular requirement. Thanks for the support !! Best Regards, Nitish953Views1like1Comment