Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Link external csv/excel with existing dataset

Hi

 

I have a usecase where I am controlling some config with csv file. (Basically RLS user data)

I want to give control to a few other Admins(outside my organization) to do the config.

I can place this file on sharepoint where they can easily modify it, but I have restrictions that I cannot share files via sharepoint to external organization.

Is there a way someone can place this csv directly in PowerBI Services ?

I see an option in PowerBI Services to upload csv/excel directly, but that creates a separate dataset and I cannot connect my existing dataset with this new dataset.

 

Basically, the issue is - connect an independent csv to existing dataset that can be edited by someone outside the org.

Or if there is any other approach.

 

Thanks

Gori Shanker

Need Help

2 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    HHey Anonymous ,

     

    you could load the CSV files with a data flow to Power BI and then share the result of the data flow with multiple users that wouldn't have access directly to the files.

    Would that work for you?

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Denis

       

      Thanks for the solution.

      I check dataflow and found that I can create a table by manually entering data. This will solve my issue as I want the end user to feed data to Power BI services directly.

      But there is no option to upload a local csv to dataflow. When I select the data source as text/csv, it ask me for a web link(eg. OneDrive) of the file.

       

      Although manually entering the data will work but a direct csv upload would be more convenient to end user.

       Manual data entry to table