Solved: Excel linked to PBI

Saloni · ‎05-25-2017

Urgently need some advice. I have a .pbix file which is linked to an excel file on my system. I want to transfer the .pbix file and the excel sheet to my colleagues system so that he can make changes to the excel file and subsequently "Refresh" the .pbix file to update data in the charts. How can I do this so that my colleague has access to the excel file linked to PBI. Thanks in advance.

Greg_Deckler · ‎05-25-2017

He can just go in and update the Source path to where the Excel file exists on his system.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Greg_Deckler · ‎05-25-2017

He can just go in and update the Source path to where the Excel file exists on his system.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...