Forum Discussion

Nathaniel_C's avatar
Nathaniel_C
Community Champion
3 years ago

Using a path name from an SQL query to open a csv file in power query

Hello, Helping a colleague with this project.  The colleague has created a SQL query that finds the path to a csv file. This path changes on a daily basis, so we need to have the path refre...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Nathaniel_C - it depends on the location of the file.  If you specify the file name and location in a connector like "Excel.Workbook" Power BI will try to create credentials for the specified file.  The Power BI service will not like the Dynamic Data Source, so it won't allow the Data Source credentials to change.

This would work if the file is located in SharePoint Online.  In this situtation, you can connect to the SharePoint URL and then dynamically find the file name using filter on the Folder Path and File Name.  This trick is that credentials are validated at the SharePoint site level, so the file can change dynamically.  Though you may need to "Ignore" the Privacy Setting to pass the file name from another source. 


  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    3 years ago

    Hi Anonymous ,

    Thank you for your quick response. So assuming that we can use SharePoint, how are you suggesting that item #5 happens.
    Thank you,


    Nathaniel