Forum Discussion
export data from power bi
Hi Anonymous,
Regarding exporting data from the Power BI, there could be two aspects. One is exporting data from the visuals and another is exporting the .pbix file from the Power BI Service. As far as I know, we can't do other actions like exporting a SQL query.
Indeed, we can import a pbix file into the Azure Analysis Service. BUT it's deprecated, which means this isn't a good idea. Please refer to analysis-services/analysis-services-import-pbix. I think there are many other wonderful tools can do better than Power BI. Such as SSDT.
Best Regards,
Dale
The Power BI data model under the hood is a tabular cube (SSAS) and there are blog articles about how to connect it, etc. It is not beyond the realm of possibility that at some point it will be super easy to build your data model in Power BI and then export to Azure Analysis Services but I do not believe that easy integration exists yet.
thank you for your reply.
Therefore, using a tabular cube tool (ie. sql server data), I can work on the data modelling and then connect it to another tool, right?
thanks
Not sure I understand what you mean but sure?