Power BI Semantic Model As Power Pivot Data Source

[tecumseh]

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 · Accepted solution]

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 · Accepted solution]

Thanks @Anonymous ,

Great solution - working.

Thanks,

w

[Anonymous · Accepted solution]

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.