Showing results for 
Search instead for 
Did you mean: 

Dataflows validating queries - error message

In power bi service data flow, I loaded excel files from one drive, completed transformations, and when clicked save & close button getting error after 2 minutes of validation.


dataflows error - query loading.png





An error occurred while validating your queries (session ID:a1862deb-dc87-4364-a78c-b122f2b7a7a5).


Could anyone advise what does this means and any suggestions with the next steps? 

Status: New
Advocate III

@FireFighter1017 because sadly they do a crummy job of cleaning up ideas and requests, I wouldn't always go by the state of the status of ideas or issues. 😞 The issues can come up again and again based on the fact that it's a service based issue. They might just need to fix it again.


Yes when you set up the initial connection to the data source you should be able to specify the column count in the initial data source M code.