Share via

Importing Power BI data into Excel

Anonymous
2023-10-05T21:15:41+00:00

I'm trying to import this Power BI database into Excel.

I tried the "Basic" import "From Web". No luck.

Any suggestions?

TIA!

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-10-05T22:28:43+00:00

    Hi,

    To import Power BI data into Excel, you can use the "Get Data" feature in Excel. Here are the steps:

    1. Open Excel and click on the "Data" tab.
    2. Click on "Get Data" and select "From Power BI".
    3. Sign in to your Power BI account.
    4. Select the dataset you want to import and click "Load" or "Edit" to customize the data before importing.

    If you're still having trouble, make sure that you have the latest version of Power BI Desktop installed and that you have the necessary permissions to access the dataset. You can also try exporting the data from Power BI as a CSV file and then importing it into Excel using the "From Text/CSV" option in the "Get Data" feature.

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-10-06T00:04:48+00:00

    I tried the Power BI for Desktop, without success.

    I don't have a login nor should I need one.

    I'm trying to download a public database or licensed nurseries in Michigan.

    It's easy enough to cut-and-paste records. But I would like the entire list.

    Thanks!

    2 people found this answer helpful.
    0 comments