Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Long Time unsolved Problem: Empty Table when loading Dataflow in PBI Desktop

Hey Power BI Community,   this seems to be a common problem, but I did not find any solution anywhere: When I created dataflows (from sharepoint excel files sources), which work fine when lookin...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    Like this?

    I have encountered this problem. The reason why this problem occurs is because when you save dataflow, it is not refreshed, so you can do this:

    First, manually refresh the Dataflow you created in Service.

    Second, manually refresh the imported entities in Desktop.

     

    Best regards,
    Lionel Chen

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

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

Some while ago I created some dataflows and got the same issue. If i'm not mistaken (it was around 1 year ago) what I did was to make a refresh on the dataflow on service (even those with a value in it) and then go back to the desktop verison and make the connection again.

 

On those that were connected to gateways or sharepoint folders I activated the connection and schedulle refresh on the service and forced a refresh of the data in the service, after that everything appeared on the desktop.

 

Be aware that you need to check if the refresh finalized, if you have large amounts of data may take a few minutes to finalize the refresh (of course not for this test dataflow).

 

Hope I have remembered correctly the workaround.