Forum Discussion
Support from Microsoft Power BI
hereri I'm assuming when you set up the EG that you created a Datasource matching the same datasource, you didn't specify in your description. And were the reports built in Desktop and pushed to the Service, or did you connect directly from the Service?
Hi Anonymous,
You are correct regarding the EG. The reports were built from the website, not Desktop.
I also get the same problem directly when I click on the dataset itself (see attachment).
hereri You are correct in your assumption then, everything should have automatically moved over to using the EG datasource once you had configured it. The only unknown or sticking point I see in this scenerio is that you didn't build in the Desktop and instead direct connected... This was broken for a long time, and the only way to use the EG was via publishing from the Desktop. So, if there are transition issues your only option may be to create a support ticket... Or, rebuild the reports using that datasource.
Hi. Anonymous,
Rebuilding the reports would probably take a week or two so Id rather not :)
I did create a priority ticket andI got confirmation via e-mail that an engineer would contact me within 2 hours. This is now approx. 60 hours ago. :(
hereri Yeeeah,.. That is not cool. I can't really add anything additional. If you set up the EG, and can see the datasource and use it when you connect via "Get Data -> Databases -> SSAS", then your existing dataset should have moved over.
I can only throw in the recommendation to always build in the Desktop so you have a copy of your reports... and a future reference to the fact that they started work on the ability to export your report to a PBIX, but I have no idea when that will be available. And I realize that both these tidbits don't help at all in the current situation. I hope they respond soon.
Jeh Anonymous,
Though, I think Microsoft is going the wrong way here. First of, Power BI is presented as a "self-Service" solution where users are encouraged to create their own reports and alter reports through the web interface. Creating reports through the desktop edition is a good thing as long as it is *only* done on the Desktop. Especially since your modifications done from the app are overwritten if you do changes to your pbix and re-uploads it.
Allowing users to download a report to a pbix seems kind of half-way too. I dont really understand why they do not re-use the knowledge they gained from SharePoint and the flexibility we had / have there. Every report could be like an excel file (pbix vs. xslx). That is how we did alot of BI using SharePoint on-premise and PowerPivot for SharePoint).
You would automatically have versioning per report, you could seperate reports into folders, and you even had a recycle bin. I think we lost all that mature functionality for a few fancy new visuals in Power BI.
But that is a whoole other discussion that is better taken over a beer or two :-)
Thanks alot for your effort though. Have a nice weekend :-)