Forum Discussion
Getting Data From Multiple PowerBi's
Hi misiek5510 ，
If you want to use shared dataset to create your own reports, you need to have build permission for the dataset first, but it seems that you only have read-only permission, so you can't connect to the corresponding dataset in Power BI Desktop. For more information on how to give build permission, how to connect to datasets in Power BI Desktop, and some consideration or limitations, you can check out the official documentation below.
Connect to datasets in the Power BI service from Power BI Desktop
Only users with Build permission for a dataset can connect to a published dataset using the Power BI service live connection.
Also, if you can connect to the dataset, if you make some updates but do not publish to the original workspace and use the same name, there will be no change to the original dataset. The owner of the dataset will not get notified either.
Best Regards
misiek5510 , Power Bi Dataset as direct query.
Enable preview feature - Direct query Power Bi dataset as ..
Then once you add the power bi dataset you can change the model type using the option under modeling tab and then you can add another model.
Once add all models, you can copy-paste visuals from all 30 files to this file. Do not add duplicate models.
You can also use dashboard add page from different power bi files
Right, so I've added directquery for pbi datasets and AS in the preview features settings, restarted the powerbi and do I now go to get data > Power BI datasets ? I don't need whole dataset just the filtered output.
Also what is worth mentioning is that I'm not the owner of the other dashboards and I just have read only access to them.
