Forum Discussion

qsong's avatar
qsong
Helper II
6 years ago
Solved

Cannot load data from dataflow to Power Bi Desktop

Hi Everyone,

 

I created dataflow and then used PowerBi Desktop to load data from dataflow. It turns out that all tables loaded are empty in powerbi desktop. I check tables in the dataflow and they are all fine. What might be the reason? 

 

Thank you

 

Best, Qianru

Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi qsong ,

     

    Please check how much memory do you have and how much space you have used.

     

    By my research, sometime this may be a temporary error. You could have a reference of these similar threads which have been solved : case1, case2, case3.

     

    You may need to improve the dataflow performance: https://community.powerbi.com/t5/Service/SQLServer-performace-issue-will-dataflows-help/td-p/783770.

     

    Or use incremental refresh for dataflow, see more detail:https://docs.microsoft.com/en-us/power-bi/service-dataflows-incremental-refresh.

     

    After creating the new dataflow, you may refresh the Dataflow on Power BI Service to make data loaded into the entity. Then, click the "Refresh" button in "Navigator" pane when use Power BI dataflows connector in Power BI Desktop . If still no data is shown, please clear permissions under "Data Source settings", and establish the connection to dataflow again.

    Best Regards,

    Amy

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    After you have created your dataflow, you need to refresh it first before being able to use it in Power BI Desktop.

     

    Have you refreshed it yet?

    • qsong's avatar
      qsong
      Helper II
      6 years ago

      Yesterday when I created the dataflow and I refreshed data; however, today I saw it failed to refresh again. Why does it happen? I try to refresh again and it takes for a while, but it is not able to refresh properly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hard to say without any details. What error message are you getting?

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi qsong ,

     

    Please check how much memory do you have and how much space you have used.

     

    By my research, sometime this may be a temporary error. You could have a reference of these similar threads which have been solved : case1, case2, case3.

     

    You may need to improve the dataflow performance: https://community.powerbi.com/t5/Service/SQLServer-performace-issue-will-dataflows-help/td-p/783770.

     

    Or use incremental refresh for dataflow, see more detail:https://docs.microsoft.com/en-us/power-bi/service-dataflows-incremental-refresh.

     

    After creating the new dataflow, you may refresh the Dataflow on Power BI Service to make data loaded into the entity. Then, click the "Refresh" button in "Navigator" pane when use Power BI dataflows connector in Power BI Desktop . If still no data is shown, please clear permissions under "Data Source settings", and establish the connection to dataflow again.

    Best Regards,

    Amy

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.