Currently, our reports are accessed through a Power BI Workspace App. When I attempt to upload to the Workspace, only .pbix and .rdl files are supported. It seems that Excel files connected to a model can't be uploaded to the app and, therefore, wouldn't be accessible to our users. So, it seems that either 'Analyze in Excel' is best for personal use, or we need another interface to share model-connected Excel spreadsheets. Is that correct?
Great video, I really need to look into that dynamic subscription stuff for paginated! If you didn't want pivot tables in excel you can also connect to the xmla endpoint using the Azure Analasys Services connector in Power Query to pull the raw data (and also aggregations for measures).
Currently, our reports are accessed through a Power BI Workspace App. When I attempt to upload to the Workspace, only .pbix and .rdl files are supported. It seems that Excel files connected to a model can't be uploaded to the app and, therefore, wouldn't be accessible to our users. So, it seems that either 'Analyze in Excel' is best for personal use, or we need another interface to share model-connected Excel spreadsheets. Is that correct?
You can share those Excel files through OneDrive for Business or SharePoint. in a folder that your users have access to.
Great video, I really need to look into that dynamic subscription stuff for paginated! If you didn't want pivot tables in excel you can also connect to the xmla endpoint using the Azure Analasys Services connector in Power Query to pull the raw data (and also aggregations for measures).
Good solution. but it only works subscription equal or over PPU
Yes, possible
Although when you get data from it in Power Query then it will need refreshing to get updates
Yes, I’ve used Excel pivot tables and cube formulas for my “paginated” reports built by business users.
Thanks for sharing!
Useful 😃
Glad to hear that