Ok, I built and published a report (Import mode with a model to a Data Warehouse) and decided I wanted to reuse that model going forward, so I built my next report using a Live Connection to the first one.
I built and published these to Workspace "Dev". Now I want them to be published to Workspace "Prod".
I can publish the original report (with model and dataset) to "Prod" and can refresh the data. All is good.
However, it looks like I cannot publish the 2nd report to "Prod" because it was built using a Live Connect to a dataset in my "Dev" workspace? I just saw this limitation listed on the Live Connect page:
Please tell me this isnt true. There has to be some sort of workaround.
You could check the Issues forum here:
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Proud to be a Datanaut!
I'm afraid that is true. The workaround could be using the old pbix file or downloading it from Power BI Service. Then upload it to PROD.