https://community.fabric.microsoft.com/t5/Report-Server/Excel-Input-and-ODATA-connection-in-same-Power-BI-file/m-p/3886421#M34760 <P>Hello Experts,</P><P>I have a situation to generate the data model for a same dashboard from 2 different data base. 1 is from Excel and another 1 is via ODATA services. Is that, possible while create Power BI file to have 2 different type of data models</P> Thu, 02 May 2024 14:31:38 GMT tvedachalam 2024-05-02T14:31:38Z https://community.fabric.microsoft.com/t5/Report-Server/Excel-Input-and-ODATA-connection-in-same-Power-BI-file/m-p/3886421#M34760 <P>Hello Experts,</P><P>I have a situation to generate the data model for a same dashboard from 2 different data base. 1 is from Excel and another 1 is via ODATA services. Is that, possible while create Power BI file to have 2 different type of data models</P> Thu, 02 May 2024 14:31:38 GMT https://community.fabric.microsoft.com/t5/Report-Server/Excel-Input-and-ODATA-connection-in-same-Power-BI-file/m-p/3886421#M34760 tvedachalam 2024-05-02T14:31:38Z https://community.fabric.microsoft.com/t5/Report-Server/Excel-Input-and-ODATA-connection-in-same-Power-BI-file/m-p/3887522#M34770 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="735941" data-lia-user-login="tvedachalam" class="lia-mention lia-mention-user">tvedachalam</a>&nbsp;,</P> <P>Please have a try.</P> <P>Get data from excel:</P> <UL> <LI>In Power BI Desktop, go to the "Home" tab and select "Get Data" &gt; "Excel".</LI> <LI>Browse to your Excel file, select it, and then choose the tables or sheets you want to import.</LI> <LI>Once the data is loaded, you can transform or shape it using the Query Editor if necessary.</LI> </UL> <P>Get data from odata:</P> <UL> <LI>Again, in Power BI Desktop, go to "Get Data" but this time select "OData Feed".</LI> <LI>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.</LI> <LI>Select the data you wish to import from the OData feed. You can also transform this data in the Query Editor as needed.</LI> </UL> <P>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.</P> <P>More details:&nbsp;<A href="https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data" target="_blank">Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Learn</A></P> <P><A href="https://learn.microsoft.com/en-us/power-query/connectors/odata-feed" target="_blank">Power Query OData Feed connector - Power Query | Microsoft Learn</A></P> <P>&nbsp;</P> <P>&nbsp;</P> <P><A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">How to Get Your Question Answered Quickly - Microsoft Fabric Community</A></P> <P>&nbsp;</P> <P>If it does not help, please provide more details with your desired output.</P> <P>&nbsp;</P> <P>Best Regards<BR />Community Support Team _ Rongtie</P> <P>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 03 May 2024 01:54:32 GMT https://community.fabric.microsoft.com/t5/Report-Server/Excel-Input-and-ODATA-connection-in-same-Power-BI-file/m-p/3887522#M34770 Anonymous 2024-05-03T01:54:32Z