PBI Dataflow: Loading stuck at Importing data path phase from sharepoint online

[arridhonabil]

Hi All,

Im having issues in creating a new data flow with Pro Account. The data flow takes so much time to load for just importing data path from Sharepoint Online. This is my 3rd data flow, the first 2 is working fine. 

After 11 minutes running, the error shown below. I've rerun the same method and the error pops up after 18 

Appreciate for any suggestions to try and help from the expert.

Thank you

[v-luwang-msft]

Hi @arridhonabil ，

There may be occasions when connecting to data sources for dataflows run into issues. This section provides troubleshooting tips when such issues arise.

• Salesforce connector - Using a trial account for Salesforce with dataflows results in a connection failure with no information provided. To resolve this, use a production Salesforce account or a developer account for testing.

• SharePoint connector - Make sure you supply the root address of the SharePoint site, without any subfolders or documents. For example, use link similar to the following: https://microsoft.sharepoint.com/teams/ObjectModel.

Reference: https://docs.microsoft.com/en-us/power-bi/service-dataflows-create-use.

And similar question :

https://community.powerbi.com/t5/Power-Query/Combining-files-from-SharePoint-Folder-using-Dataflows/... 

Wish it is helpful for you!

Best Regards

Lucien

[Adescrit · Accepted solution]

Have you tried creating the same query in Power BI desktop?

Power BI desktop tends to be much quicker than dataflows. For this reason when creating a dataflow I find it preferable to:

1. Create and test queries in PBI desktop
2. Open advanced editor
3. Copy the entire query
4. Paste into a blank query in the dataflow.