This table is Empty in PowerBI Desktop but Data is loading from PowerBi Pro

[Anonymous]

I created a dataflow using PowerBI Pro - Oracle Database. I can see the data in the dataflow editor

But when I try to use it in Power BI Desktop the table is empty.

I have already tried the following:

1. After creating the new dataflow, refresh the DataFlow on service to make data loaded into the entity.

2. Click the "Refresh" button in "Navigator" pane.

3. If still no data is shown, please clear permissions under "Data Source settings", and establish the connection to dataflow again.

I have verified thet refresh has been completed for this Dataflow.

I was not able to solve this issue so far. Please help.

Thanks and Regards,

Abegail

[ridua]

I am having the same issue where I am loading data from a saved Application Insights query, it isn't loading the data for a query after the query contains a leftOuter join, the query, however, works expectedly in Application Insights. Can someone help?

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Have you confirmed that the dataflow is refreshed in the service and the data table can be loaded?

After confirmation, you can try to recreate the pbix connection to this dataflow to see if the problem persists, or you can try to  copy the M code from Advanced Editor into power bi desktop and try it again.

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create#using-the-dataf... 

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

[Anonymous]

Hello @V-lianl-msft 
I have the same issue here. there is data in the dataflow editor, but empty in Service. 

I tried to follow all steps as mentioned: refreshed data in service, remove permision and create new by copy code from advanced editor but it still show empty table.. 
Could you please help?

BR, 
BettyB