Topic -Power BI Paginated Reports with Excel or CSV file data source

Question

Hi All,
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.
Is anyone having idea that how we can achieve this?

Answer 1

Hi, @There,

With Power BI Desktop, you can connect to data from many different sources.

• You connect to data by using the Home ribbon. To show the Most Common data types menu, select the Get Data button label or the down arrow.
• To go to the Get Data dialog box, show the Most Common data types menu and select More. You can also bring up the Get Data dialog box (and bypass the Most Common menu) by selecting the Get Data icon directly.

File data sources

The File category provides the following data connections:

• Excel
• Text/CSV
• XML
• JSON
• Folder
• PDF
• SharePoint folder

I would suggest you go through this: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources and https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data