Forum Discussion

arridhonabil's avatar
arridhonabil
Frequent Visitor
5 years ago
Solved

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

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 ...
Dataflow
Need Help
Show and Tell
  • Adescrit's avatar
    Adescrit
    5 years ago

    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.
v-luwang-msft's avatar
v-luwang-msft
Community Support
5 years ago

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/m-p/708587#M23657 

 

Wish it is helpful for you!

 

Best Regards

Lucien