Forum Discussion

tessahurr's avatar
tessahurr
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services.  To learn more about this feature, please visit this blog post or our documentation.   ...
General Comment
deepti1309's avatar
deepti1309
Regular Visitor
5 years ago

We are getting this error message. 

 

 

Step by Step Screenshots are here:-

 

 

Data in, and working:

 

 

Opened “Get Data” à “Excel File” à Add a Local Model

 

Before you even get to select the file, you get the error (you can see the navigation window in the background)

 

Select the Excel file anyway and load it. No relationships or anything….

 

Once the new data loads, all visuals relating to the data from Power BI are broken:

  • jeroenterheerdt's avatar
    jeroenterheerdt
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    thanks - can you make sure the dataset does not have any supported features such as calculated tables?

    • deepti1309's avatar
      deepti1309
      Regular Visitor
      5 years ago

      thanks! So we upgraded to the latest Feb 2021 version that supports calculated columns and now we are getting this error message

       

       

      OLE DB or ODBC error: COM error: COM error: Microsoft.AnalysisServices.AzureClient, Failed to resolve PBI workspace. Description: <HTML><HEAD>
      <TITLE>Access Denied</TITLE>
      </HEAD>
      <BODY>
      <FONT face="Helvetica">
      <big><strong></strong></big><BR>
      </FONT>
      <blockquote>
      <TABLE border=0 cellPadding=1 width="80%">
      <TR><TD>
      <FONT face="Helvetica">
      <big>Access Denied (authentication_failed)</big>
      <BR>
      <BR>
      </FONT>
      </TD></TR>
      <TR><TD>
      <FONT face="Helvetica">
      Your credentials could not be authenticated: "Credentials are missing.". You will not be permitted access until your credentials can be verified.
      </FONT>
      </TD></TR>
      <TR><TD>
      <FONT face="Helvetica">
      This is typically caused by an incorrect username and/or password, but could also be caused by network problems.
      </FONT>
      </TD></TR>
      <TR><TD>
      <FONT face="Helvetica" SIZE=2>
      <BR>
      For assistance, contact the ITSS Help Desk on 03-9641-1111.
      </FONT>
      </TD></TR>
      </TABLE>
      </blockquote>
      </FONT>
      </BODY></HTML>
      • deepti1309's avatar
        deepti1309
        Regular Visitor
        5 years ago

        We made sure that the user is logged in with the right credentials and can access the dataset.