Forum Discussion
Create offline file for PBI publisher in excel
Anonymous,
I understand your scenario and I have tested it. As my previous post, it doesn't support to create offline file in this case, please vote the above ideas.
Regards,
Lydia Zhang
Advocate ILydia- Neither of the ideas you promoted apply to the scenario Anonymous wants. This is probably why he dropped conversing with you over the issue. As it is, I am now in the same position, needing to have a cached version of my Power BI data in the Excel file in which I've used the Power BI connection. In Power BI, I import data directly from a SQL Server DB (not an analysis cube) using a model I've designed and published with the Power BI for Desktop application. I can use this model in the cloud or via Excel (with the add-in). Using Excel, I now need to capture and cache the data so I can use the file offline. The "Create offline data file" is not available to me as I get the same error as AAllen in his initial post. No doubt, the system does not currently support this need, but voting for the ideas you promote isn't going to solve the issue either.