https://community.fabric.microsoft.com/t5/Report-Server/Power-BI-Paginated-Reports-with-Excel-or-CSV-file-data-source/m-p/1311421#M15653 <P>Hi All,</P><P>&nbsp;</P><P>I am new into paginated reports. I need to use my data files (Excel, CSV or any text file)as data source to Power BI Report Builder.&nbsp;</P><P>Is anyone having idea that how we can achive this ?</P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks in advance.</P> Thu, 20 Aug 2020 14:10:12 GMT Anonymous 2020-08-20T14:10:12Z https://community.fabric.microsoft.com/t5/Report-Server/Power-BI-Paginated-Reports-with-Excel-or-CSV-file-data-source/m-p/1311421#M15653 <P>Hi All,</P><P>&nbsp;</P><P>I am new into paginated reports. I need to use my data files (Excel, CSV or any text file)as data source to Power BI Report Builder.&nbsp;</P><P>Is anyone having idea that how we can achive this ?</P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks in advance.</P> Thu, 20 Aug 2020 14:10:12 GMT https://community.fabric.microsoft.com/t5/Report-Server/Power-BI-Paginated-Reports-with-Excel-or-CSV-file-data-source/m-p/1311421#M15653 Anonymous 2020-08-20T14:10:12Z https://community.fabric.microsoft.com/t5/Report-Server/Power-BI-Paginated-Reports-with-Excel-or-CSV-file-data-source/m-p/1312550#M15661 <P>Hi, you have a few options</P><P>&nbsp;</P><P>1. If the data doesn't change, you can copy and past the CSV into the ENTER DATA feature:&nbsp;<A href="https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-enter-data" target="_blank">https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-enter-data</A></P><P>2. If you are using PBI Report Server or SSRS you can use an ODBC connection to yoru Excel file:&nbsp;<A href="https://www.xtivia.com/sql-server-how-to-setup-a-data-source-in-ssrs-to-ms-access-ms-excel-and-csv-files/" target="_blank">https://www.xtivia.com/sql-server-how-to-setup-a-data-source-in-ssrs-to-ms-access-ms-excel-and-csv-files/</A></P><P>3. If you are using PBI.com you can connect it to a PBI Report/DataSet:&nbsp;<A href="https://powerbi.microsoft.com/en-us/blog/power-bi-dataset-data-source-support-for-paginated-reports-is-now-available/" target="_blank">https://powerbi.microsoft.com/en-us/blog/power-bi-dataset-data-source-support-for-paginated-reports-is-now-available/</A></P><P>&nbsp;</P> Thu, 20 Aug 2020 21:26:03 GMT https://community.fabric.microsoft.com/t5/Report-Server/Power-BI-Paginated-Reports-with-Excel-or-CSV-file-data-source/m-p/1312550#M15661 Jon-Heide 2020-08-20T21:26:03Z