Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
Hope you can help me.
I am trying to create a dataflow in Power BI Service using data in a SharePoint folder.
This is my SharePoint main folder, containing multiple folders.
I would like to create a dataflow that combines only the files in the Test folder. The files' names change on a monthly basis.
If I select "SharePoint folder" as a new source and use the SharePoint url, I get all the files from all the folders. I could filter only the files I need but the problem, as said above, is that the files' names change monthly.
How could I fix it?
Thank you for your support.
Solved! Go to Solution.
Hi @MT123456
You may want to create parameters for each file in Power Query and you still need to go back to the service to change the parameters when thge files are changed in Sharepoint.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @aj1973 ,
Thank you for your answer.
In Power Query in Power BI Service, I have filtered the Folder Path instead of (File) Name and it seems working fine, also when I add or remove files from the specific folder. Do you think I will have issues in this way?
Thank you!
You should not have an issue by adding or removing files as long as you keep the same structure of your files.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @MT123456
You may want to create parameters for each file in Power Query and you still need to go back to the service to change the parameters when thge files are changed in Sharepoint.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook