PBIRS Sep. 2026 using excel as datasource
PBIRS Sep 2026 has been released and the change log shows "Setup no longer installs the Microsoft Access Database Engine. To use Access or Excel data sources, install the Access Database Engine on the report server". Is there any documentation or SOP tell us about which version of Access Database Engine to install? or I have to install it from M365 Office installer?
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, Hila
