Error importing dataflow (dataverse)

[deerzzxdell]

Hello community, 

I came upon a problem with importing a dataflow from my working workspace. 

In the dataflow everything's fine, I'm able to see all the data that I've import from dataverse into DF.

But this happen when I import the DF into power bi desktop. There's message state that my table is empty. Did I do it in awrong way or do I need to create any more connection from my workspace?

I'm able to get my hands on another power bi from another co-worker (with connection from dataflow but different workspace)

They have created parameters for dataflow id and workspace id in power query. Do I need to do that to make my datatable works? Ad this expression error appear when I try to look into their query. I assume this is because I don't have permission/connection to their workspace.

This is my first time using dataflow as a data source in power BI. Any answer is very much appreciate. 

[Anonymous]

Hi @deerzzxdell 

When you create a dataflow, it only loads some data for preview in Power Query Online to help transform the data. It doesn't load all data into the dataflow. After you save and close the dataflow, you have to execute a manual refresh or a scheduled refresh to load all data from the data source. Ensure the refresh has completed, then refresh data in Power BI desktop. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[lbendlin]

https://blog.crossjoin.co.uk/2020/04/06/understanding-the-the-key-didnt-match-any-rows-in-the-table-...