Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a PBI report that accesses delimited text files from a web server. Every day a new text file is added to the directory and the file name contains string representing the date. I have created a function to access these files. I have to first construct the name(s) of the file(s) I want. So if I want to get a file generated yesterday, I will calculate the proper date string based on DateTime.LocalNow() and adjust for -1 day. I then use Web.Contents() with my properly constructed file name. This works when I am running the query from Power BI Desktop for Report Server. However when I save the report to the Report Server, and try to set up automatic refresh it fails. The dyanamic data source is not "seen" as a source for which I can enter credentials. Apparently the server expects to have crendentials set for every individual file, but the file names are not constructed until run time. Due to the hand-edited functions and queries, these sources are "invisible" at the time of entering credentials.
I would like to be able to enter credentials for the web folder that the files are in, and have it apply those permissions to any file in the folder. I can't see a way to do this.
Why does the refresh work from PBI Desktop but not from the report running on the report server? And does anyone have a suggestion of how to solve this problem? Thanks for any clues you can provide!
Solved! Go to Solution.
Hi @Anonymous
You can probably resolve the issue with the scheduled refresh by the method on this blog:
Here's official trouble shotting document could also provide some hints:
https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh-troubleshoot
https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh
Hi @Anonymous
You can probably resolve the issue with the scheduled refresh by the method on this blog:
Here's official trouble shotting document could also provide some hints:
https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh-troubleshoot
https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh
Hey copious "thanks" to @v-diye-msft v-diye-msft! The post from Chris Webb's blog on the RelativePath argument to Web.Contents, held the key. Once I started using that, I was able to provide credentials to the 'base' URL and no longer got errors. Now my report will auto refresh using Report Server.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
1 |
User | Count |
---|---|
7 | |
7 | |
6 | |
4 | |
3 |