Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Disconnect Desktop Report from Power BI Service Dataset - connect to a completely different dataset

Hi All ....    I'm running a simple B2B business ...   Customer 1  - For my first customer I have Sharepoint Online Site Power BI Dataset connected to the Sharepoint site Power BI Reports in ...
Need Help
Aedmunds's avatar
Aedmunds
Frequent Visitor
5 years ago

Not a single reply?  Surely I'm not the only one who has come across this problem and wants to use Power BI for a B2B service?

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    5 years ago

    All you need to do is change the data source in the Desktop file and point it to the dataset2 on the local drive (bear in mind you will need to set up a Gateway to update the data when changes to the dataset occur). 
    You can change the source dataset  easily by going into Power Query and select the query, click on settings icon in the first step in the query (Source) and redirect to the local file.

    Obvisouly save the new file with a different name. You might also consider using different workspaces in the service for different clients.