Ensure that power bi desktop parameter is null from default when another user will open it

[jaryszek]

Hi,

we are using as Team bpip (projects) files. 
I want to be sure that when i will specify hardcoded path as my parameter with my local location to folder with csvs -> another user will need to specify it also. 

How to force it in power bi desktop?

Or what are your workarounds for it?

Best,
Jacek

[jaryszek]

Sorry @MadhaviT  topic is not resolved. Support not know it. 

Please keep topic open. 

[v-bmanikante]

Hi @jaryszek ,

I am a Senior Engineer from the CST team. Apologies for the inconvenience caused.

As you mentioned, we will keep the ticket open. Please let us know once your issue has been resolved, so that we can either close the ticket or take further action as needed.

Regards,

B Manikanteswara Reddy

[jaryszek]

thank you.

[Anonymous]

Hi @jaryszek 

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[Anonymous]

Hi @jaryszek 
 If the issue persists, we recommend raising a support ticket for further assistance. To create a support ticket for Fabric and Power BI, please refer to the steps outlined in the following guide:

How to create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn

Thank you.

[Anonymous]

Hi @jaryszek 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[Anonymous]

Hi @jaryszek 

Yes, if you hardcode a local folder path in your .pbip file, other users will need to update it on their side too. To make this easier, I recommend using a parameter for the folder path:

• Go to Manage Parameters > New Parameter

• Name it something like FolderPath , set the type to Text, and enter your local path

• In your query, use: Folder.Files(Folderpath)

This way, when someone else opens the file, they’ll just update the parameter instead of editing the query.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.

[jaryszek]

thanks but this is not solving the case. 
It is not forcing user to input parameter. 

Best,
Jacek

[MFelix]

Hi @jaryszek ,

Using the Power BI Project you cannot force it since the value is coded into the files when you save it, you can do it usnig the Power BI Template however that will not be store in a way you can do CI/Cd across multiple users.

[Anonymous]

Hi @jaryszek 

I wanted to check if you had the opportunity to review the information provided by @MFelix . Please feel free to contact us if you have any further questions. If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[Anonymous]

Hi @jaryszek 
Thank you for reaching out microsoft fabric community forum.

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[jaryszek]

Hi,

issue is not solved. There is no way to force it without using pbit. 

[MFelix]

Hi @jaryszek ,

You can saved your file to have the path with a null value however that will break your model since you need to have a location set in order to have the data loading into your model.

Since you are using the PBIP you can make the change directly on the files without opening the Semantic model folder the Expressions.TMDL file and replace the Parameter value by a blank one this will force a refresh when you open the file locally and since that would be blanked you would get an error saying  the path is not of legal form:

However using Power BI Project I assume you are using CI/CD to then merge the changes you will always need to do this change after a commit of your data otherwise it will pickup the local folder when the other user does the sync.

[jaryszek]

Thank you not that very friendly solution to keep this file always in mind. 

I think i will check if specific folder exists and if not i will throw the error to set up properly one for user. 
So if you will get the report, you will open and have to provide your local path if you forgot you will get error please provide correct path to your local environment. 

Best,
Jacek