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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
DVAvinash
Regular Visitor

User selection to import selected version of a same excel file from SharePoint folder

Hi All,

 

I have a folder in sharepoint which has many versions of an excel file that I use. I am currently importing the latest updated file to my Power BI.

But now instead of selecting the latest updated file I want to select an older version of the excel file. For this I created a parameter which stores the list of all the file names of the various versions present in that folder on the SharePoint and through this parameter I am controlling which file should be imported. 

I am able to do the parameter selection through the edit parameter option on the main screen of Power BI desktop . When ever I make a selection in the parmeter the data refreshes and the selected version of the excel file is imported into the Power BI.

Unfortunately when I publish the Power BI dashboard to the Web I do not get the option to change any parameter.

Because of which the end users who use the webapp when they want to select a different version of the file they are not able to do it. 

Is there anyway in power bi where i can allow the user to provied inputs on which file to be imported?

1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@DVAvinash,

 

There is already an idea, you may leave a comment and vote it up.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.