Forum Discussion
Data flow using sharepoint folders
Hi DomantasK ,
When you connect to Sharepoint, there will be a Combine operation, select this:
This will form a Transform File in Power Query, which contains some functions that can expand and append all files in the folder, but the limitation is that the field requirements in the two files are the same, otherwise an error will occur
Refer to：
Power Query SharePoint folder connector - Power Query | Microsoft Learn
When you publish the report to service, you could create a flow with Power Automate.
Add a new item to the SharePoint --> the flow will be triggered --> then will do the "Referesh dataset" action for Power BI.
https://learn.microsoft.com/en-us/power-automate/trigger-flow-powerbi-report
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi DomantasK ,
When you connect to Sharepoint, there will be a Combine operation, select this:
This will form a Transform File in Power Query, which contains some functions that can expand and append all files in the folder, but the limitation is that the field requirements in the two files are the same, otherwise an error will occur
Refer to：
Power Query SharePoint folder connector - Power Query | Microsoft Learn
When you publish the report to service, you could create a flow with Power Automate.
Add a new item to the SharePoint --> the flow will be triggered --> then will do the "Referesh dataset" action for Power BI.
https://learn.microsoft.com/en-us/power-automate/trigger-flow-powerbi-report
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.