Forum Discussion
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
- Anonymous1 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,
ZhuIf 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
- AnonymousNot 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,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- tecumsehResolver III
Thanks Anonymous ,
Great solution - working.Thanks,
w