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.
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?
@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.