The queries on desktop can refresh, but the refresh fails in the service (the error message is about Binary)
I ran into a similar issue with another very similar set of queries and moving them to a dataflow solved the problem.
However, with this set of queries in dataflows, I click the Save & Close button and the last query fails in the Validating queries process. The last query that failing is appending around 6 previous queries into a single table. I put in some Table.Buffer functions at the end of the queries that are being appended. I also changed it so uses the advanced append to append all 6 queries in a single step.
However, when I click Save & close, it is stuck Validating queries - Waiting to fix issues.
Can you post the M Code for “Projections” Query here? Also, check on the query list to the left. Does it show a lightning icon next to Projections query table icon? Also, can you post the full error message you get when you try to refresh in the service?
I had given this problem over to Microsoft Power BI tech support. They came back and told me to make a tweak in the Admin Portal → Capacity Settings. Unfortunately, I don’t have admin rights, and couldn’t make the change myself. I think the tweak was to a query time setting in Capacity Settings.
Part of the problem might have been that my dataflow was too complex. I took all the queries from my Power BI desktop and pasted them into a single dataflow. Microsoft suggested creating separate dataflows and using staging dataflows. Breaking up the dataflows and having one refer to the other might be a better way to solve the problem. I’m going to work on breaking up and rebuilding the dataflow in smaller pieces. I’ll let you know if that solves the problem.
Just a note, if you use staging dataflows, you will have to append them into a dataset rather than another dataflow as calling one dataflow within another dataflow will trigger Linked Entities and you will have to upgrade your workspace to Premium as this is a premium feature.
I am a Premium per User license holder. Does that allow dataflows to reference other dataflows. The link you provided doesn’t mention Premium per User.
I am not a Premium per User license holder. But you should be able to find out one way or another as you will get an immediate notification to upgrade to Premium if you try importing a dataflow within another dataflow.
