Forum Discussion

misiek5510's avatar
misiek5510
Icon for Helper III rankHelper III
4 years ago
Solved

Getting Data From Multiple PowerBi's

Is it possible to get data from multiple powerbi's and store it either within a powerbi or table in excel or similar? (We have over 30 powerbi to go through every week and then once a month generate ...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

    Ways to give Build permission

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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