Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dataflow operation is timed out

Hi Community!   We are trying to import all our dimensions and fact tables into dataflow. We have managed to import all except one. The fact table contains around 2.5 mill. rows and we have Pro lic...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Maggie,

     

    It seems our SQL statement needs to be rewritten, so the problem is not solved yet, however it has been postpone to an unknown date. I will close the case for now.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

Which is the data source?

SQL SERVER database?

 

After others are imported correctly, you could save the dataflow, open Power query online for the imported tables,

you could get data in the dataflow authoring tool.

https://docs.microsoft.com/en-us/power-bi/service-dataflows-data-sources

 

 

I find a workaround in this similar thread.

I created the desired query in PowerBI Desktop.  Then I captured the M code from the advanced editor and pasted it into the editor in Dataflows.  Then I just clicked 'Close and Save' and navigated away without waiting for the preview to finish.

The dataflow loaded without problem, but managing the query has to be done out of Power Query Editor, and then copied into the editor in the Dataflows interface.  

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.