Forum Discussion
ERROR IN SAVE & RUN
- 8 months ago
Hi nknwn,
Can you give us more details?
Where are you seeing this error? Is this in Power BI? Is this a dataflow gen 2?
THis appears to be a power query error, what data types are you using? Can you share the structure of your table?
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
- 8 months ago
Hi nknwn,
Are all the data types Text? I would assume that fields like Start_time would be a datetime column no?
I see you're trying to write to SharePoint, what happens if you instead try to write the data to a lakehouse?
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
hi nknwn,
- The final step in Power Query returns an empty table (#table(...) , {}).
- Or the table structure is not correctly defined for the destination (for example, Lakehouse, Warehouse, or Dataflow).
Why does this happen?
#table({"id", "start_time", "completation_time", ...}, {})If this response was helpful in any way, Iβd gladly accept a πmuch like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop π.
And how can I solve this? I use dataflow gen 2 server. I am in the browser. But my table is not empty, I see it in the data view
- tayloramy8 months agoSuper User
Hi nknwn,
Are all the data types Text? I would assume that fields like Start_time would be a datetime column no?
I see you're trying to write to SharePoint, what happens if you instead try to write the data to a lakehouse?
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
- Zanqueta8 months agoSuper User
could you give us a print screen (hiden personal information) about your previsou step to better clariry the scenario?