Forum Discussion

teolachev's avatar
teolachev
Icon for Helper II rankHelper II
11 years ago

Power BI Desktop Missing Data Features

What's the Power Pivot equivalent in Power BI Desktop of: 1. Existing Connections - so that the end users can change the server name in one place. 2. Table Properties - so that the users can bring ...
andre's avatar
andre
Icon for Memorable Member rankMemorable Member
11 years ago

teolachev In Excel, Power Pivot can connect to data sources directly or via Power Query.  Power BI Desktop only connects to data sources via Power Query, therefore, features of Power Query that were available in direct connect mode are not available in the Desktop (therefore no to Existing Connections, Query Builder and table properties among other things)

teolachev's avatar
teolachev
Icon for Helper II rankHelper II
11 years ago

I understand the difference between Power Query and Power Pivot import options. So, if I want to switch to another server, e.g. from QA to PROD, and I have imported 20 tables, I have the change the server name 20 times, right?

 

Greg_Deckler, thanks for pointing this out but it doesn't let me change the server name.