Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm having issues with refreshing my PowerBI data in service. The Scheduled refresh fails and proves the message:
"Processing error: Information is needed in order to combine data".
I use OData feed to get data. The report worked fine until i added a combine to my Power Query editor. Basically i get 2 Odata feed's and combine them in the Query Editor. The refresh works when i download the .pbix file from PowerBI Service and refresh it on Desktop. What is the issue here?
Hi @CarlsBerg999 ,
I found these similar posts which might be helpful to solve your issue:
Information is needed in order to combine data
Information is needed in order to combine data Table - without Gateway
Information is needed in order to combine data Table: machine_shop_OEE.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @CarlsBerg999
Please download the report and open it in the Power BI desktop, go to Query Editor, refresh data to see if any message pops out. Also please go to the Data Source Settings, click on Edit Permission for these two data sources, ensure both privacy level is Organizational.
Then republish the report to Power BI service, go to Manage Gateways, ensure Privacy Level for these two data sources is Organizational as well. Then refresh the dataset again.
Regards,
IF MY SOLUTION HELPED YOU IN SOME OR THE OTHER WAY PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT RESOLVES YOUR ERROR!
Thanks @NimaiAhluwalia so much. I was struggling with this too and your solution helped. Thanks tons mate!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.