Dynamic File Import
I have a model that is built off of four Excel files that are stored in a network folder. The network folder contains several files that aren't associated with my model, but I need the most recent version of the four files. My dilemma is that the files have datestamps, and files from previous days need to be kept for auditing purposes. My steps are as follows: 1. = Folder.Files("FolderPath") 2. = Table.SelectRows (Source, each Text.Contains ([Name], "Text in Filename")) 3. = Table.Sort(Filtered,{{"Date modified", Order.Descending}}) 4. = Table.FirstN(#"Sorted Rows",4) 5. = Table.SelectRows(#"Kept First Rows", each Text.Contains([Name], "Text in Filename")) 6. = #"Filtered Rows"{[#"Folder Path"="Filename with Specific Date"]}[Content] How should I modify my steps so they find the most recent file that contains "X" in the name?
Data Source Connection Issue
Hi there. This is going to be a hard one to troubleshoot but here goes. My company has 2 process accounts that had a password change over the weekend. I have them configured in ODBC manager 64 bit and the new passwords test successfully. I then proceeded to update the passwords in the 3 dashboards that I have and refresh the data to ensure the new passwords work and the refresh is successful. However, when I publish all 3 dashboards back to the PBI server and try to refresh from there, I get a data source error - shown below. I also check the gateway settings and see the below. In my data source credentials, I see the below. I did refresh the gateway and the screen states it is online and ready to be used. I don't know what to do from here. I also tried the troubleshooting docs for PBI to no avail. Help! Thanks, LB
Problem configuring data source to SAP BW
Hey! I have built a PBI report in Desktop app which used SAP BW as a data source, everything was ok, data was imported successfully and uploaded it to on-premise PBI report server. I needed to configure scheduled refresh, so I installed the SAP .NET connector on the server, typed the username and password in a report's data source window in a browser. When I test the connection it throws "Log on failed. Ensure the user name and password are correct." error. SAP audit doesn't catch any failed logins. In other words, SAP BW credentials work in PBI Desktop but not in PBI Report Server. Can you help with the problem?
Data source connection strings read-only and cannot be modified?
Greetings! We have DEV,TEST,UAT,PROD environments and on each environment, the same pbix has to be connected to different data sources. However, pbi report server does not allow modifying connection strings of data sources of pbix files. What is the recommended way to deploy pbix on report server?
Can you connect to a published paginated report from BI Report Builder as a data source in Power BI?
I've published a report on Power BI Report Builder on to the workspace but it has only published the report, not the dataset. I want to connect to the report as a data source because when I try to input my SQL in advanced editor it, Power BI gives me an error below.
Updating data from two sources
Hello! Faced with the following problem: I have two data sources. The first is oracle database, and the second is SQL Server database. I have set up auto-update, but the update occurs only in the SQL database, how can this be solved? At the same time, if you update the data in BI Desktop, then everything goes well. P.S. the connection does not give errors.Unable to update this data source's credentials. Unknown error
I have successfully publish a test pbix file to my powerbi web~ however, when I set the data source authentication. this error pop out~ Unable to update this data source's credentials. Unknown error Details: Please have this information handy if you choose to create a support ticket. ActivityId: 94640c9c-faba-469c-8d70-6ffe8fcb5bb5 RequestId: 1644bbba-25ef-4443-ab1e-4e496fd4555b Cluster URI: https://api.powerbi.com Status code: 500 Time: Wed Mar 01 2023 17:03:14 GMT+0800 (Singapore Standard Time)
