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.
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!
Organizational account credentials from Power BI Server?
Hi, I've created a report with a Sharepoint Folder data source (specificaly, an excel xlsx file in a folder of my Sharepoint site). My Sharepoint is hosted on Sharepint Online and I access it via Organizational Credentials. I've been able to do it in Power BI Desktop for Report Server (October 2017). Once I publish my report to POwer BI Server, I go to "Manage > Data Source" , there in Credentials I can only choose Anoymous or WIndows Authentication. Is there a way to have a report pulling data from Sharepoint Online from Power BI Server as of now? (and have it refresh on a scheduled basis). THe idea is to have some select users edit data in the EXcel file, and management can open the report done in POwerBI. (I'd like to avoid having to open the report in PowerBI Desktop and republish it everytime there is a change in the data source, which is what I am doing for now.)
Scheduled refresh power BI report with sharepoint list and excel
Hi, I have created report using multifuel data sources- Share point lists and excels from share folder. Currently I need to manually refresh the report and publish it again so the data will get updated…. I want to add scheduled refresh but do not succeed to make it happen. I entered "Mange"--> "Scheduled refrash" tab but i can't becouse there is notification: "Stored credentials for this report are missing. Please go to the Data Sources page for this report and set your credentials for each data source to enable scheduled data refresh " So i moved to "data sources" tab and tried to connect sources but i get error "log on failed": tried various combinations but not sure what credentials they request or which password.... How can i find the correct credentials? Is it possible to schedule refrash for this kind of report? Thanks, HilaPower BI Scheduled Refreshes not working. Only change is upgrage of Apache Poi from 4.1.2 to 5.2.3.
We have been successfully running these reports for many months. The only change is upgrading Apache Poi 4.1.2 to 5.2.3 which the generating application uses to generate the excel file with dynamic data programatically. I can supply an example filing excel file if required. Dont seem to be able to attach here. The files are saved directly onto sharepoint by the generating program and Power BI reads them from there wih a web connection. Now we get the following error when performing a schedule refresh, or manual refresh, through Power BI online. If we load the report, refresh the data and republish it in Power BI desktop it works successfully. Also, if I open the excel file, force a save, and then retry the Power Bi online/scheduled refresh works. In order to get the files under Apachi 5.2.3 to load to power BI Desktop I had to make the following change to the Transformation code navigation step: From: = Source{[Item="Metric Report",Kind="Sheet"]}[Data] To: = Source{[Name="Metric Report"]}[Data] Refresh is fine in Power BI Desktop
