Forum Discussion

BPhetchamphone's avatar
BPhetchamphone
Icon for Advocate II rankAdvocate II
10 years ago
Solved

Q&A optimization issues in office 365

All,      I am in the begining stages of optimizing reports for Q&A. I feel like every article I read leads me down a rabit hole. First, the power bi site within office 365 does not support a power ...
  • leonardmurphy's avatar
    leonardmurphy
    10 years ago

    Power BI for Office 365 is the "previous" Power BI experience, which is why it does not support pbix files. It sounds like you want to use the previous experience, in which case you would have to build your data model in Power Pivot (Excel O365 Pro Plus Edition) for Q&A to work. After uploading your a Power Pivot model, you should be able to do the "Optimize for Q&A" feature since that's also the previous Power BI experience. A Power Pivot model with synoyms will also work with the new Power BI too.

     

    However, I wouldn't recommend spending a lot of time developing & deploying Power BI for Office 365 since Microsoft have since moved away from that in favour of powerbi.com. 

     

leonardmurphy's avatar
leonardmurphy
Icon for Skilled Sharer rankSkilled Sharer
10 years ago

Power BI for Office 365 is the "previous" Power BI experience, which is why it does not support pbix files. It sounds like you want to use the previous experience, in which case you would have to build your data model in Power Pivot (Excel O365 Pro Plus Edition) for Q&A to work. After uploading your a Power Pivot model, you should be able to do the "Optimize for Q&A" feature since that's also the previous Power BI experience. A Power Pivot model with synoyms will also work with the new Power BI too.

 

However, I wouldn't recommend spending a lot of time developing & deploying Power BI for Office 365 since Microsoft have since moved away from that in favour of powerbi.com.