Forum Discussion
Enterprise solution, how?
So, not sure that I can answer any/all of your questions but I'll give it a shot at some of them. Enterprise features for Power BI 2.0 are really just starting to appear. Power BI started out as a self-service BI tool and we are just starting to see the more Enterprise features come about.
For an enterprise, probably a good idea to look at using SQL cubes. This provides a solid backend for security and opens up the ability to use SSRS, Power BI or anything else that supports cubes. For Power BI, you would want to use the Enterprise Gateway to ingest that data and provide the autorefresh capabilities.
You'll also want to strongly consider SQL Server 2016 as it adds a lot of enterprise features to Tabular data models and supports some crossover between SSRS and Power BI. For some good articles, take a look at:
http://sqlmag.com/blog/what-coming-sql-server-2016-business-intelligence
And yes, my current understanding is that you cannot ingest a Power Pivot model into Power BI currently in terms of the Desktop. But, you can load an Excel file with a Power Pivot model into the Service and it functions.
Just on the point of ingesting Power Pivot models to PBI Desktop...
You can migrate Excel (including Power Pivot models, Power View reports, etc) to Power BI Desktop, through the Import >Excel workbook contents feature. - see here --> https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-excel-workbooks/
Hope that helps!
lukehayler - Cool, learned something, I was thinking via query.
With the rate Power BI gets updated it's hard to stay current! ;)
