Forum Discussion

DIACHROMA's avatar
DIACHROMA
Helper II
5 years ago

Dataflow table missing in Power BI Desktop

Hi everyone,    I've created a Power BI Dataset connected to several Dataflow tables. Suddently the refresh of this dataset doesn't work anymore.  I have the below error message :  Processing err...
Dataflow
Need Help
DIACHROMA's avatar
DIACHROMA
Helper II
5 years ago

Hi selimovd , 

 

Thank you very much for your quick reply 😊

 

Yes, in the dataflow the table exists and the loading is enabled. 

 

Pauline

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

DIACHROMA  that's strange. And when you open Power BI Desktop and connect to that data flow the table doesn't appear, right?

The load of the table is enabled, right? Right click on the table and "enable load" is activated?

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • DIACHROMA's avatar
    DIACHROMA
    Helper II
    5 years ago

    selimovd and jeffshieldsdev ,

     

    Yes the loading is enabled and the refresh is done correctly (in any case I have no error message).

     

    However I just realized that when I go to the Dataflow on the service, and that I develop the table I have nothing. I don't see the column names like other tables that are working fine.

     

    What is weird is that I have no error in the refresh but I have the impression that the contents of the table are not loading (while it is enabled correctly and I get data in the preview). 

     

    Pauline

    • selimovd's avatar
      selimovd
      Most Valuable Professional
      5 years ago

      Hey DIACHROMA ,

       

      yes, when the content is not there, there is something wrong with the data flow.

      Solve that and the load will be solved.

       

      Try to copy the M-Code from the advanced editor in data flows and paste it in a blank query in Power BI. That usually makes it easier to debug the issue.

       

      If you need any help please let me know.
      If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
       
      Best regards
      Denis
       
    • jeffshieldsdev's avatar
      jeffshieldsdev
      Solution Sage
      5 years ago

      I don't see the column names like other tables that are working fine.

      That makes me think there's something invalid about the table the query is producing.

      What is being returned is a Table and not a List?  Are all your columns properly typed and not using Any data type?

      Do you start to see columns and rows as you click up through the Applied Steps in the query?