Hi @tvedachalam ,
Please have a try.
Get data from excel:
- In Power BI Desktop, go to the "Home" tab and select "Get Data" > "Excel".
- Browse to your Excel file, select it, and then choose the tables or sheets you want to import.
- Once the data is loaded, you can transform or shape it using the Query Editor if necessary.
Get data from odata:
- Again, in Power BI Desktop, go to "Get Data" but this time select "OData Feed".
- Enter the URL of the OData service you want to connect to. If authentication is required, select the appropriate authentication method and provide the necessary credentials.
- Select the data you wish to import from the OData feed. You can also transform this data in the Query Editor as needed.
Depending on your requirements, you might need to combine or relate the data from Excel and OData. This can be done by creating relationships between the tables in the model view or by using Power Query to merge or append queries.
More details: Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Learn
Power Query OData Feed connector - Power Query | Microsoft Learn
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output.
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
