Dear Community,
I am asking for your support in my struggles regarding Power BI Report Server. I have a common database of which multiple datasets were created. In case of smaller datasets (~36000 rows), the data loading in Power BI Desktop (Report Server) works just fine, however if I want to ingest constantly updating datasets of hundreds of thousands rows, then I got the following error:
Query2
OData: Request failed: The remote server returned an error: (422) Unprocessable Entity. (The data set could not be processed.)
-There are big datasets, where I am able to ingest the data in Power Query and do my transformation steps, but regardless of the steps, after hitting 'Apply', PBIRS desktop just throws the error above. This happens even if I limit the number of rows to keep to a small number (e.g. 5).
-I even tried to limit the number of rows of the dataset while creating it; it did not help either
-Attempted to manually set Timeout of dataset to multiple minutes, but the error is thrown anyways.
Have you encountered this issue before? If yes, I would appreciate to hear about your solution.
Best regards,
Matyas
