Cant edit Data source after import from Excel

[Anonymous]

Hi

I've imported an Excel file/Power Pivot modul to Power BI Desktop.

Under Data Source Settings the source string is grayed out - where can I edit it?

Regards, Henrik

[v-huizhn-msft]

Hi @Anonymous,

You import the Power Pivot model the way below, right? If it is, there is some limitations about import excel workbook contents, please review the limitation part of this article: Import Excel workbooks into Power BI Desktop.



Or you import data from excel by clicking "Get Data"->Excel, you have access to all the datasouce settings in excel? And what power Bi desktop do you use, please update it to the latest version.

Best Regards,
Angelia

[Anonymous]

Hi Angelina

I import the Excel workbook via Import > Excell workbook contents

The importet Data model, created in Power Pivot, works fine in Power BI Desktop, but the connection string is grayed out under Data source settings.

I need to edit the connection string, as I intend to use the pbix-file on various customers sql server.

Help is much appriciated.

Regards, Henrik

[Anonymous]

Hi @v-huizhn-msft

Any ideas?

Regards, Henrik

[v-huizhn-msft]

Hi @Anonymous,

In Excel, as what I said, if you have access to edit data source permission in excel as follows?



Best Regards,
Angelia

[Anonymous]

Hi @v-huizhn-msft
 
Oh, I am able to edit the data connection in Excel, but:
 
After importing the - big - datamodel in Power BI Desktop, I build a lot of visuals in Power BI Desktop, and then I want to reuse this bpix-file at various customers sql servers. If I have to edit the data source in Excel, then I have to rebuilt the - many - visuals in Power BI every time.
 
Is it impossible to edit the data source in Power BI desktop?