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 looking at them in the power query online editor, but as soon as I load the dataflow in Power Bi Desktop, it says "Empty Table".

I even tried it with just a simple table, that only has one value ("test"), but it still doesnt work.

 

Can this be a problem of Premium/Pro License? I only have a pro license.


Here's Some Pictures:
Thanks for your help,

 

Cheers,

 

Janik

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.

     

5 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Brilliant!  That worked.  Awesome!

  • MFelix's avatar
    MFelix
    Super 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.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Has your problem been solved? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best regards,
    Lionel Chen