Forum Discussion

Helper 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 ...

teolachev

Helper 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.

andre

Memorable Member

11 years ago

teolachev there is no elegant way to do it (although my definition of elegant may be drastically different from yours) . here is a tutorial on how to do it in less than perfect but workable way (the tutorial is for PQ in Excel)

http://businessintelligist.com/2015/05/12/power-bi-tutorial-how-to-parameterize-connection-variables-in-power-query/

Forum Discussion

Power BI Desktop Missing Data Features

Related content

Preview Features missing

MISSING QUERY FEATURE from Lookup activity

DW Missing features compared to SQL server

Forecasting feature is missing

missing data