Power BI Data Imports

Question

What types of data imports does Power BI support?

Answer

Power BI can connect to various types of data. Common file import types include:

  • Excel spreadsheets
  • CSV files
  • Standard text files
  • Access database
  • PDF
  • Websites
  • Oracle database
  • SQL server

Third-party data is often accessible by making API connections to the data stored in those systems. 

Power BI utilizes a dataset/semantic model which is a collection of data that Power BI can import or connect to. One or many semantic models can be used in a single Power BI report.  Semantic models are found in workspaces and can be used by more than one workspace.  For example, an excel spreadsheet, an Oracle database, a text file, or a webpage could all be semantic models and all be used within the same report.

For additional assistance, please contact Information Technology Services at 419-372-0999 or through chat.

Print Article

Details

Article ID: 159343
Created
Wed 5/22/24 10:43 AM
Modified
Wed 5/22/24 10:43 AM