Forum Discussion

CRV's avatar
CRV
New Member
2 years ago

Dataflow tables not available

I have created a dataflow by importing the existing json file. I opened the dataflow and was able to save and close without any issue and was able to refresh the dataflow successfully. When I tried ...
dataflow
Need Help
CRV's avatar
CRV
New Member
2 years ago

Hi aj1973 & v-yanimei-msft , Thank you for your responses. 

I can confirm that there were no refresh failures in the Dataflow. 

The Dataflow is set to source the data from an Azure SQL Database and there is no issue with the permission. 

 

I opened the power query of the Dataflow on the service and let the Evaluation complete for that missing table and then saved the dataflow. Then I refreshed the same and now I can see that table when I connect  from Power BI desktop. I no longer have the issue. 

However , in the past, when I had created the dataflow using an existing json file, I never had to open the Power query of the Dataflow and complete the evaluation of each and every table and then click on save. 

Would you happen to have any insight on this behavior?

 

 

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

No insight on my end, but I would recommend to save a new json file for the newly refreshed Dataflow.