Parameters to set up in order to switch local user folder location and service one

[jaryszek]

Hi Guys,

I have 2 ways of loading data into power bi using *.pbip files. 

So one is that user will open power bi desktop, power bi connect to his local folders using parameter or windows environment variable

Second data source is azue blob storage. How to switch between them ?

Best,
Jacek

[v-nmadadi-msft]

Hi @jaryszek ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the advice provided by the community members for the issue worked.

Thanks and regards

[v-nmadadi-msft]

Hi @jaryszek 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[jaryszek]

https://community.fabric.microsoft.com/t5/Fabric-Ideas/Skip-Credential-Validation-for-Queries-Exclud...

here is idea to exclude local sources  from being refreshed in power bi service.

[v-nmadadi-msft]

Hi @jaryszek 

May I ask if the responses have helped you? 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.

[lbendlin]

Having a data source in a local folder is not a good idea.  Why would you allow a gateway to rummage around on your PC?

[jaryszek]

@lbendlin Because i need to import large files locally and not wait for blob storage minutes and hours. 
This is why i need a switcher for both service load and local load.

How people are solving it in power bi world? There is no possibility to set it up? 
Assuming that developer1 has local folder path and developer2 has another local folder path with csvs inside, 
how you would organize it? 

Best,
Jacek

[lbendlin]

I would not have that scenario. We don't allow our developers to use local paths.

[jaryszek]

So how you are using pbip projects and git? If you are using only service and download it to dekstop ? How to make changes and publish them after? 

So assuming that i have service refreshed i am downloading report, and changing it and pushing to git as bpip project?

[lbendlin]

Only via OneDrive/SharePoint.

[jaryszek]

thank you. 

Ok but if you are not using sharepoint, how your deployment pipeline is looking?

In my case:
1. bpip project created in power bidekstop
2. Pushed to service 

That'is all. 

Are you using the reverse engineering approach like:
1) power biservice report connected to cloud data sources
2) downloading report and changing it via power bi desktop
3) pushing to service and refreshing data

What approach do you have?
Best,
Jacek

[v-nmadadi-msft · Accepted solution]

Hi @jaryszek  ,
Thanks for reaching out to the Microsoft fabric community forum.

You should consider using deployment pipelines:

When you're using source control only for development purposes, and prefer to deploy changes directly between stages of the release pipeline.

When deployment rules, autobinding and other available APIs are sufficient to manage the configurations between the stages of the release pipeline.

When you want to use other functionalities of Fabric deployment pipelines, such as viewing changes in Fabric, deployment history etc.

Consider also that deployments in Fabric deployment pipelines have a linear structure, and require other permissions to create and manage the pipeline.


I hope this information helps. Please do let us know if you have any further queries.
Thank you