Forum Discussion

petesuen's avatar
petesuen
Frequent Visitor
4 years ago

Unable to connect to Power BI Datasets from Excel

Hi all   Hopefully I'm asking in the right place!   I have been trying to connect to Power BI Datasets from Excel via "Data" ➡ "Get Data" ➡ "From Power BI". It is giving me an error that says: ...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, petesuen 

 

Sorry, I can't reproduce your scene in my computer. Do you use a pro license? 

There is also a function on the service called ‘Analyze in Excel’, can you use it?

Please refer:

Analyze in Excel for Power BI - Power BI | Microsoft Docs

Troubleshooting Analyze in Excel in Power BI Desktop - Power BI | Microsoft Docs


Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.


Best Regards,

Community Support Team _ Janey

 

petesuen's avatar
petesuen
Frequent Visitor
4 years ago

Everyone in our company should have the Pro license.

It does work while clicking on "Analyze in Excel" on a report from app.powerbi.com

Unfortunately that's an extra step that's unlikely to appease the crowd. 

 

I have been in touch with Microsoft so I'll report back if I have anything new. 

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    petesuen 

     

    Okay, hope you can solve the problem soon.

     

    Best Regards,

    Community Support Team _ Janey

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hello petesuen 

     

    Has the problem been solved? How is the progress?

     

    Community Support Team _ Janey