Forum Discussion
PowerBI Premium Gen 2 Prequisites
Those are the min versions needed to leverage the XMLA endpoint in that particular tool. Use of any or all of those is not required, but you will likely want to leverage some.
Pat
ppm1 ,
Thanks for reply. Am sure i understood that these are minimum requirements. my question was more around what if Excel or SSMS versions dont fall into mimum requirement. What issues i may face? There has to be some reason why they are mentioned as "prerequisites". if you dont suffice them what will happen - will you be able to still connect to your data sitting in Azure Synapse table ? will you be able to refresh your data as before ? any performance issues ?
more digging in tells me that updated SSMS version would give me- Read-write access for scripting metadata.
example: PBI report with powerpoint integration requires specific O365 version. i dont have that version hence i am not able to integrate my PBI report in powerpoint.
Thanks
- ppm13 years ago
Solution Sage
For each tool, if you don't have at least the version specified, you won't be able to use that tool with XMLA. It won't affect the use of any of the other tools or creation/use of the Premium capacity.
Pat
- Krp3 years ago
Helper I
Thank you ppm1 ,
It has been confirmed by Msft that we dont need to upgrade the SSMS unless we are leveraging it to change dataset directly in SSMS using XMLA endpoint.
Even Excel upgrade is also not mandatory as long as users are not exporting data to user excel report designer.
Thanks