Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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:grafik.pnggrafik.png
Thanks for your help,

 

Cheers,

 

Janik

1 ACCEPTED SOLUTION
v-lionel-msft
Community Support
Community Support

Hi @Anonymous ,

 

Like this?

k6.PNG

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.

k8.PNG

Second, manually refresh the imported entities in Desktop.

k9.PNG

 

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.

 

View solution in original post

5 REPLIES 5
asmalazar
New Member

i have the same problem even when i try to refresh   

v-lionel-msft
Community Support
Community Support

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

v-lionel-msft
Community Support
Community Support

Hi @Anonymous ,

 

Like this?

k6.PNG

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.

k8.PNG

Second, manually refresh the imported entities in Desktop.

k9.PNG

 

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
Not applicable

Brilliant!  That worked.  Awesome!

MFelix
Super User
Super User

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.