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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors