Microsoft teams grayed out save feature for power bi embedded report
Hello, I am trying to upload power bi visuals / reports within microsoft teams for easy to use daily access across my members. Unfortunately when I go to click on the tab the save feature to display the report is grayed out. Please help.
Collapsing Fields and Visuals - MEMCM/SCCM Reporting
Hi all - This may be an elementary question as I've recently started diving into SCCM reporting using Power BI. Please advise if I'm not posting in the correct area. I've been able to create some useful visuals so far, but with simple single datasets. What I have now is a table that pulls duplicate values in a few columns (resource ID, net bios name). In SQL/SSRS, I'm able to collapse the values. For example, my query looks for any device in our environment that has a required MS update that is not installed, and will generate a compliance status of "Not Compliant" and so-forth. Because of this, I'm having trouble creating a visual where it shows correct numbers. Here's what I see in SSRS: I have it structured to expand by machine name. Here's what I have in Power BI: Here, each resource ID and machines name is associated to each update value. I'd like to create a visual of the overall compliacne of only one machine, say "count of machines where = compliant or not compliant". Can someone help give me a nudge on this one? Thank you!re: Joining multiple visual report table to calculate the sum
Hello Community, I have multiple tables giving information like business unit code, payer type, region. The objective is to calculate the estimate revenue coming from each unit by different payer. So from table we are calculating average per day revenue from each payer "Insurance" at specific Business unit "SN000". We have taken total SUM of the revenue and divided by total day categorizing average pay based on Business unit code and payer type. From another sheet. we have service. we are pulling data like service date and number of patient served on that day. Which is also categorize by Business Unit and Payer type. I had to create seprate table because when I'm trying to put all this information in average rate estimation it will create total patient number instead of giving result like one above telling number of patient on specific date, BU, and payer. We are trying to multiply Number of patient * Average pay to calculate total for each to calculate rough cash inflow from different unit. How can I multiply two seprate design by using table visualition to calculate each day revenue based on different categories. Final objective is to get something like this Is their away I can do setup this table like the above one ? id there anyway we can automize the above report to gather this census number everyday for particuliar day and calculate the total of that days and for all days days combineReport Server Security Reporting
I have now created reports using the Power BI Server logs on who has added, requested and updated reports on the server, but I am interested in being able to report on the users and AD groups that have access to reports (not just who uses them). Is there a log or available dataset(s) to query the group or users and their associated roles for a security report? So permission setup rather than usage?
Using OAuth to connect to Power BI Reporting Services 401
Hi I try setup oAuth for power BI Reporting Services and use WAP + ADFS, using article. https://powerbi.microsoft.com/en-us/documentation/powerbi-mobile-oauth-ssrs In power bi reporting services add new virtual directory (powerbi), i get error 401 for try use WAP. How to setup Power BI Reporting Services for OAuth?
Dimension Table of emails
Hi, good afternoon, I am very new in DataWareHouse, please can yo give me advice, I have a fact table from a select where i have got two rows, one raw by any incident, which columns than identify the caseid and the productid which has produced the incident, one product has generated two incidents. The problem is when i select a query than returns me by any incident the id of the email that the user sent to communicate the incident. Of course i have my DimensionMail, which a primary key that is the id of the email and a column that is the email, of course is a varchar colum, buit i am a little confused with the results, i mean the number of rows in the 2 fact tables. Please have a look at the squema, i thin is correct, buy i would like your opinions. Thanks a lot
