Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Analyze in Excel: Invalid value for key 'integrated security'

I have a dataset in the Power Bi Service that I'm trying to use in Excel. The "Analyze in Excel" option works fine when generating the Excel file and I can even refresh without issue.   The proble...
Need Help
  • GilbertQ's avatar
    GilbertQ
    5 years ago

    Hi Anonymous 

     

    As far as I know currently it is not possible to connect from Power Query in Excel to a Power BI Dataset in the service.

     

    You can vote for the idea on https://ideas.powerbi.com

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

Hi Anonymous 

 

As far as I know currently it is not possible to connect from Power Query in Excel to a Power BI Dataset in the service.

 

You can vote for the idea on https://ideas.powerbi.com

  • RobertSlattery's avatar
    RobertSlattery
    Icon for Responsive Resident rankResponsive Resident
    4 years ago

    It is quite possible to connect to a PBI Dataset in the service, with power query in excel.  A dataset is an AAS Cube and power query has an AAS connector: Get Data\From Database\From Analysis Services, then enter the Workspace Connection URL.  Select Use the following User Name and Password and leave them blank (assuming MFA is enabled).