BI Server Data Source Windows Authentication Problem with Share Excel File
I have setup Power BI server on 172.17.5.15 (PC1) and Keep an Excel file on another (PC2) whose address is 172.17.5.22. I uploaded the test pbix file to the Power BI server, which worked fine. But when I tried to connect to the data source it's asking for windows authentication. I tried to give PC2 user name and password but it's not working. Please help me with what windows user id I will provide or how I write the user ID. Example: My user ID MIS_Share.Compare dates in two columns and then sum 3rd column
I am using Power Pivot in EXCEL not Power BI. Trying to compare dates with an if statement from two columns and when the date matches I want to sum a 3rd columns. Here is the DAX formula I have, which is not working. What do I need to change to be able to compare the dates and then sum up the values? I also created date tables for the two date columns. Didn't work either. MM CM:=IF(VALUE('Vendor Trend'[CAP Date Paid])=VALUE('Vendor Trend'[CAP Date Aff]), SUM([TOTAL MM])) MM CM:=IF(VALUE('Calendar'[Date])=VALUE('Calendar_Dt Aff'[Date]), SUM([TOTAL MM]))
Analyze in Excel: How to force Credentials Window / Password Prompt to pop up
I need assistance to force Excel to ask for User Credentials / Password Prompt when accessing Power BI data. I am using Analyze in Excel that connect to a Power BI datamodel that is located in the service. I am logged into my Excel Desktop app and can see the Power BI Datamodel/Dataset. However, once selected, as it tries to load there is an error that says: "Cannot create the PivotTable. An error has occurred when creating the PivotTable. Please make sure that you have permissions to the data, that the model is valid and the credentials are correct." There is a similiar issue when using Excel for Web. The user profile has full permissions over the datamodel/dataset. The first image is what I need to pop up. The second image is the error I'm getting (without being prompted to confirm credentials. user already signed in)
Getting one extra row while exporting paginated report to excel
THIS ISSUE IS RELATED TO POWER BI REPORT BUILDER: I have built a Matrix in PBI report builder (Paginated Report). Whenever I export the report to Excel, I get first row of every row group duplicated at bottom. This issue is not found when exported to other formats like PDF, Word, CSV. Any help would be appreciated!How to sync Excel data with Microsoft Fabric on a certain interval?
Hi Team, I have used this custom visual to create the following chart in my Power BI dashboard. The survey data is currently stored in Microsoft Excel but we want to push it to Microsoft Fabric after every survey and wants to run the dashboard from the Fabric. What is the best way to push data from Excel to Microsoft Fabric at a certain interval? What would be the cost involved in using Microsoft Fabric for this use case? thank you.Measure that filters a table to a single row and returns text from a specified column (Excel365)
Hi there I still have a lot to learn about DAX, and have become stuck trying to develop a measure that will filter down my source table to a single row by using values in two columns and return the (text) value from a different, specified column. I have two measures that filter a table and calculate the expected values for (a) the oldest date for an unresolved service ticket and (b) the corresponding number of days elapsed after that date, but what I am unable to do is to retrieve the text value from a column for the row that table is calculating the age and date from. I've been going around and around in circles researching and trying different functions for far too long and am super confised now. I would really appreciate some help! 🙂 Most of my attempts at developing a measure result with an error message advising ~ that multiple have been supplied where a single value was expected, but by now I have failed in dozens of different ways. I've knocked up a file with dummy data and measures for reference - hope this helps with understanding my request and developing a solution. The pivot table I'm working with is used to generate statistics that are consolidated and presented as part of a dynamic and interactive 'dashboard' on another sheet; it is the "SYS" values that I am trying to populate with this measure: The image below is from the sample file provided, with the column in pink manually created to illustrate the desired result. Thanks in advance for your help!🤗
