Forum Discussion

BugmanJ's avatar
BugmanJ
Icon for Helper V rankHelper V
2 years ago

How to avoid the problem of not being able to refresh Calculated Tables off Direct Query Tables

Good Afternoon All, Having fallen for the same problem I have seen many people suffer from on here, I am asking what is the best solution to avoid this? Problem You have a Dataset you are acce...
Need Help
BugmanJ's avatar
BugmanJ
Icon for Helper V rankHelper V
2 years ago

How would I do this? I believe from what I have read online that analysis devices would only connect to a server and not a semantic model?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You can connect to any semantic model as if it were an Analysis Server since a semantic model is pretty much an instance of SSAS Tabular.

 

In your workspace navigate to the semantic model's settings page.  Go to the Server setting section and copy the connection string

 

Use that connection string in your new file.  It will then give you the option to connect live or via import mode, and you can specify your own DAX query if you want.

 

  • BugmanJ's avatar
    BugmanJ
    Icon for Helper V rankHelper V
    2 years ago

    Thanks, when i try, i have to cut down to the part which goes

     

    api.powerbi.com

     

    It then gives the error: "We could not connect to the Analysis Services server because the connection timed out or the server name is incorrect."

     

    What should be the correct name? Do i need a value in for the database? My original dataset is pulling data from a AWS if that helps

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

       

       

      when i try, i have to cut down to the part which goes

api.powerbi.com

       

       

       

      You need to keep that part.  Remove the "Data Source="  part, and the "Initial Catalog" part including the semicolon.

       

      The server part should be 

       

      powerbi://api.powerbi.com/v1.0/myorg/<workspace name>

       

      The database part is the name of the semantic model.  

      • BugmanJ's avatar
        BugmanJ
        Icon for Helper V rankHelper V
        2 years ago

        Thanks that really helpful.
        I now suffer with this problem:
        Details: "This server does not support Windows credentials. Please try Microsoft account authentication."

        But no where does it give me the ability to enter MS account details?