Forum Discussion

tecumseh's avatar
tecumseh
Resolver III
1 year ago
Solved

Power BI Semantic Model As Power Pivot Data Source

Hi,

Using Excel MSO365 Version 2410 Build 16.0.18129.....

 

I connected to a Semantic Model and built a Pivot Table
But I manually selected 15 customers in the Row Filter and decided this was horrible UX if I want to pass this to another user.

So I listed out customer on a separate table and imported as table to the Data Model.

Now I need to add the PBI Data Model to the Power Pivot Data Model so I can join the 2 tables to filter.
This is where the error begins.

Failed to connect to the server. Reason: Invalid value for key 'integrated security'.

Details

Provider=MSOLAP.8;Integrated Security=ClaimsToken;Persist Security Info=True;Initial Catalog=sobe_wowvirtualserver-a595474b-e05c-40b5-860a-1f6b80432d57;Data Source=pbiazure://api.powerbi.com;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Identity Provider=https://login.microsoftonline.com/common, https://analysis.windows.net/powerbi/api, 929d0ec0-7a41-4b1e-bc7c-b754a28bddcc;Catalog Rebound=True;Update Isolation Level=2

 

Any ideas here?

Thanks,

w

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi tecumseh ,

     

    Instead of clicking "Manage Data Model" and "Get External Data", you can follow the steps below to add tables to the data model:

     

    Result:

     

    Best Regards,
    Zhu

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

  • Thanks Anonymous ,

    Great solution - working.

     

    Thanks,

    w

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi tecumseh ,

     

    Instead of clicking "Manage Data Model" and "Get External Data", you can follow the steps below to add tables to the data model:

     

    Result:

     

    Best Regards,
    Zhu

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

  • tecumseh's avatar
    tecumseh
    Resolver III

    Thanks Anonymous ,

    Great solution - working.

     

    Thanks,

    w