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.
Adescrit's avatar
Adescrit
Impactful Individual
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.