Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

publish pbix

Hi all,  I have 10 reports connected to one dataset, when I download the pbix from the online version, some of the pbix's are limited access to power query or manage relationships, some of them are ...
  • v-robertq-msft's avatar
    5 years ago

    Hi, Anonymous 

    In my opinion, the limited pbix uses the live connection to connect the existed dataset in your Power BI workspace. Because when you use live connection mode, you are not able to see the power query or manage relationships. Therefore, the dataset won’t be added again to your workspace when you publish the pbix to Service. The unlimited pbix is connecting to data source using import mode so that as long as you made any change in the Power query, there will be a new dataset with its name.

    To solve this problem, I suggest you to use Import mode for the first pbix you created and publish the pbix with the original dataset to Service. For the rest reports, you can just use the live connection to connect it and publish it. Then there will be one dataset and 10 reports in your workspace.

     

    Connect to datasets in the Power BI service from Power BI Desktop

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.