Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

Import PowerPivot workbook - keep connection


I wonder if its possible to import powerpivot excel workbook into powerbi but only import connection only?


My idea is that, I want to keep all the model and measures within the workbook and powerbi reads data from it. So really i just need to refresh powerpivot.


Idea behind this is - powerpivot can be located in the restricted folder with only nominated users who can refresh the model.

So even someone else can keep hold of the pbix file they cant find how model is built e.g calculated columns, measures etc...


THanks for your advice.



@Anonymous It sounds like you want to create a live connection, which is an interesting thought seeing as how the underlying technology is the same as tabular in SSAS, but "no" you currently can't do this. I don't see the difference between having an Excel file or PBIX file in a restricted folder... If someone were to gain access, either file would be accessible.


Looking for more Power BI tips, tricks & tools? Check out the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.