Forum Discussion
Rejoin previously splitted dataset and report utility
Try to save the Dataset file as .pbip
Then do the same for the Report file.
Then try to overwrite the report folder of the dataset file with the one from the report.
Let me know if it worked.
You need to understand that the folders are tied to that .pbip
That is why I want you to overwrite the files inside the report folder in the dataset folder.
Basically you are overwriting the "report" of the dataset - which there is none - with the actualy report (the report folder of your report.pbix/pbip)
and then you launch the .pbip of that dataset (where you overwrote the report folder).
if that does not work out of the box you should check the following:
The definition .pbir file in the report folder mentions the dataset, make sure this path/name is correctly pointing to the new dataset/has its name
{
"version": "1.0",
"datasetReference": {
"byPath": {
"path": "../Sales Report.Dataset"
},
"byConnection": null
}
}i hope it is now 100% clear what we are trying to do here.
this .pbip format is nothing else but splitting the .pbix into report and dataset and then you get 2x the whole thing basically
and if we do this to your 2x .pbix files and then somehow put it back together, i would expect it to work.
Impactful IndividualIf you save a file to .pbip you get this
I want you to do that for your dataset file and your report file separately.
And then you overwrite the "Report" folder of your dataset file with the "Report" folder of the report file and see if you can then open the .pbip in Power BI Desktop and everything will work?
Hi again Brunner_BI
I am afraid I was too fast celebrating... When I open the new pbip file I can actually see all visuals but I do not see the dataset:
What is wrong here?
I have notice that if you then open the new .pbip file in PBI Desktop everything is together and you have the model and the visuals together:
- Brunner_BI
I cannot follow, you are saying in Power BI Desktop it is working?
No, it isn't.
I saved my dataset pbix as pbip and got one file dataset.pbip and two folders:
dataset.dataset
dataset.report
I made the same with the reports file and gor report.pbip and two folders:
report.dataset
report.report
I eliminated the folder dataset.report and renamed the folder report.report into dataset.report
Then I opened dataset.pbip expecting to get all in there and instead I got the report (all visuals) and just the connection to the dataset.
Hope I have made it clearer.
- Brunner_BI
You need to understand that the folders are tied to that .pbip
That is why I want you to overwrite the files inside the report folder in the dataset folder.
Basically you are overwriting the "report" of the dataset - which there is none - with the actualy report (the report folder of your report.pbix/pbip)
and then you launch the .pbip of that dataset (where you overwrote the report folder).
if that does not work out of the box you should check the following:
The definition .pbir file in the report folder mentions the dataset, make sure this path/name is correctly pointing to the new dataset/has its name
{
"version": "1.0",
"datasetReference": {
"byPath": {
"path": "../Sales Report.Dataset"
},
"byConnection": null
}
}i hope it is now 100% clear what we are trying to do here.
this .pbip format is nothing else but splitting the .pbix into report and dataset and then you get 2x the whole thing basically
and if we do this to your 2x .pbix files and then somehow put it back together, i would expect it to work.