Paginated Reports - Parameters
Hi everyone! When I run the report to see rendered reports, as you see in the screenshot, only the Category and SubCategory parameters are enabled to write/select and I created all parameters in the same way but the Item key and Item no are not writable fields, what should I do to make them writable as default too? Thank you very much for the answers in advance!
Is there a way to embed view of reports from report server into another website?
Hi! Is there a way to embed view of reports from report server into another website? I want to embedd the area marked by a green rectangle into a webpage in antother application without the menu and other stuff marked by the red rectangle.
PowerBI 'Content' Setting changes theme of workbook
I'm setting up an app. I already have some pre-existing workbooks I'd like to add. However, when I add these it looks like the theme of the workbooks get changed and are showing different colors than what they are. Is this a bug or will it actually change the colors?
Changes within merges in power query
Hello, I will try my best to describe my problem: I have created a report that uses data from multiple sources. I have a table from Excel with different positions and ratios that I connected using SharePoint: and another table with employees (includes ratio column from merging the first table and then expanding the ratio column): When I apply changes to the ratios in the original Excel-Workbook (for an example ratio 15% is changed to 18%). The changes apply in the first table and the second table in Power Query and Power BI Desktop after refreshing the data. In Power BI Service however, the changes only apply in the first table and NOT in the second even after refreshing. This is frustrating and I need help to figure out how to let the change apply in the second table as well. Thank you!Publishing deleted connections between tables?
I have two tables - Activity and BusinessCase The tables are currently linked (Cardinality Many to 1) Cross filter direction Both I have a formula that calculates DIVIDE (CALCULATE ( COUNT(Activity[id]), ALL(BusinessCase[Status], L0_Raynet_BusinessCase[Group])), COUNT(BusinessCase[id]) , 0 ) The formula works for me. At the same time I have filters from BusinessCase (Type of service, Status, Owner of businessCase) in the desktop version. All filters work for me (Individual activities are linked and assigned to the groups I filter). The problem occurs when I publish the version to the online environment. For example, the moment I filter Type of service, I get a count of 0 activities (all are blank). When publishing PowerBi, is there any transformation taking place where the connection between the tables is modified?
Filtering Power BI Report Server Report With URL Parameters When Table or Column Has Space
I have created a basic report to test this scenario. My report has a table called Employees and this table has a column named FirstName. I can successfully filter the report using url parameter e.g. filter=Employees/FirstName eq 'John' This works fine. The Employees table also has a column 'Last Name' and when I attempt to filter it using the same method, the report is failing to recognize the field. I am using the following syntax: filter=Employees/Last_x0020_Name eq 'Smith' I have tried this scenario on several reports and attached is how the filter appears in the report (unrecognized) . Does Power BI Report Server filtering not work with spaces in the fields?Help needed regarding Power BI Metrics - Pulling Historical Data
Hello all, I'm trying to pull in historical data in my scorecard / metric by making a connection to a visual as shown in the picture below. Power BI Scorecard The visual I want to connect to: The visual above is about the percentage of the hours the employer was in a meeting. The measure for this is as follows: [Total hours in meeting]/[Total registered hours] When I connect the metric to the visual, it doesn't pull in the historical data. When I change the input of the visual from Month to Date (Datum), I can pull the historical data. But this way I don't have the desired visual I want to use. (See picture below) This visual shows the measure on daily basis. I need to have this on a monthly basis. Is there a way to pull in the data per month into Power BI Metrics? Is there a way to adjust the measure in such way, it shows [Total hours in meeting]/[Total registered hours] only at the end of each month? With kind regards, LazzaNova
