![]() However, while this post was sitting in draft status, John White wrote up a blog post covering this exact topic, so I'll just refer you to John's blog for details: Using Excel with External Data - What's the Right Tool? Here's where I was planning to write up a summary of obtaining SSAS data 3 ways: (1) Data menu ODC connection, (2) Power Query, (3) Power Pivot. This requires installation of the newest version of Power BI Designer. Power BI Designer: Update A live connection is now available in the Power BI Designer and works as described in the previous paragraph. ![]() Ideally the 10-minute interval becomes a configurable option at some point because many SSAS models are refreshed less frequently, such as once per day. Therefore, I tend to think of this as a "near real time" connection. Though it's considered a live connection, to improve performance the data is cached in the Power BI service this cache is currently refreshed every 10 minutes. Power BI Website: A live query connection to the SSAS Tabular Model which sends DAX statements to the SSAS server for processing. Part IV: Connecting to Analysis Services From Power BI Website, Power BI Designer, and Excel (you are here) Comparison of Connectivity Options Part III: Monitoring the SSAS Connector in the Power BI Preview Part II: What You Need to Set Up the SSAS Connector in the new Power BI Preview Part I: Overview of Using Analysis Services Data in the new Power BI Preview This information is as of early June 2015 and will definitely change as the Power BI Preview evolves. Welcome to part 4 of a 4-part series on using the SSAS Connector with the new Power BI Preview. Refer instead to the Power BI Enterprise Gateway.*** ***Note this post applies to the SSAS Connector which has been deprecated as of mid-2016.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |