A brand new cool function added to Energy BI Service is the power to obtain Energy BI stories from Energy BI Service. This function is extremely demanded and it’s obtainable from November 2016. I used to be actually excited after I observed that and I needed to strive it right away. I used to be in a bus again to house on Friday, however, I couldn’t wait till I get house and check this cool function. So I created a private hotspot and began testing it within the bus. To make the extent of my pleasure clearer, I ought to reveal a secret. I get movement sick within the bus in a short time. It will get value after I learn one thing, even studying a textual content on my cellular. Man, it’s actually horrible feeling. Figuring out that I’ll doubtlessly get sick, I turned on my pill (a Home windows 10 pill in fact) to check this new cool function. So I logged into my Energy BI Service account, I opened a report, clicked File menu and that is what I received
However, why?
Two potentialities jumped into my head instantly:
- The dataset of this explicit report is just not supported in the meanwhile
- The “Obtain report” function is NOT supported in my space
So I opened Energy BI Desktop and created a report on prime of an Excel file in a short time, then I revealed it to the service and voila! It labored. So it’s also obtainable in my space.
However, what was mistaken with the earlier report although? The dataset?
I checked the report’s dataset, it was on-premises SQL Server. May it’s an issue?
I created one other Energy BI report in Energy BI Desktop on prime of journey works on SQL Server 2016. I revealed the mannequin and curiously the obtain report function was nonetheless energetic. So how on earth I shouldn’t be capable to obtain that report?
Nicely, I used to be within the bus, wobble about and I used to be feeling that the movement illness symptom is coming for me and there have been a bunch of “whys” in my head.
So I needed to experiment another datasets as properly. I examined the next datasets:
- CSV information
- Folder
- SQL Server Direct Question
- SQL Server Evaluation Providers (SSAS) Multidimensional (Join Dwell)
- SQL Server Evaluation Providers Tabular
- From Net
- Azure SQL Database
- Azure SQL Information Warehouse
So, it will possibly’t be an unsupported dataset, I reckon.
I shortly created a report on Energy BI Service itself and… once more, it’s greyed out.
So this function is just not obtainable once we create a report in Energy BI Service from scratch which is not any good. I hope that is simply a place to begin for Energy BI improvement crew they usually enhance the obtain function sooner or later in order that we will obtain the stories created in Energy BI Service.
However, a query nonetheless remaining, why it’s inactive for all of my present stories which revealed some time in the past?
The bus continues to be going…
So I googled it and I discovered this handy article, thanks Matt Allington.
Hmm, Matt says the obtain report function is NOT obtainable for the stories created in older variations of Energy BI Desktop. In order that’s the rationale that it’s greyed out for all present stories which can be created in an older model of Energy BI Desktop.
I ought to soar out of the bus now and fortuitously I haven’t received sick, properly, a bit bit, however nothing to be fearful about.
After I received house I reopened an previous report within the newest model of Energy BI Desktop and republished it and sure, Matt is correct. The obtain report function is now activated.
It’s attention-grabbing that the PBIX file construction is modified within the newest model of Energy BI Desktop. I observed that after I uploaded a newly created report utilizing the newest model of Energy BI Desktop to a buyer’s VM and I used to be unable to open the PBIX file utilizing an older model of Energy BI Desktop. So I needed to set up the newest model and I used to be good to go.
So if this new function is just not obtainable for you then
- You’re attempting to obtain a report created and revealed by an older model of Energy BI Desktop
- The report is created in Energy BI Service from scratch
What if I reopen a report created in an older model of Energy BI Desktop and republish it? Will this resolve the previous report drawback?
Sure it does. Simply open the PBIX file created in an older model of Energy BI Desktop, save the mannequin then republish it. It ought to work.
What occurs if I alter a downloadable report in Energy BI Service?
One other query is that may I nonetheless obtain a report if I modify it on-line in Energy BI Service? The reply is YES you may.
I attempted it and it labored for me.
What about safety? Who can obtain the stories? What if we don’t need this function to be avaibale for all customers?
You may allow or disable this function by means of “Admin Portal” if you’re a “World administrator “.
- Click on the settings gear (
) on the highest proper on Energy BI Service - Click on “Admin portal”
- Click on “Tenant settings”
- Scroll down abit to seek out “Export information” then change it off and apply
- Now “Obtain report” disappeared from “File” menu
In order for you another folks in your organisation to have the ability to obtain the report then you may
- create a brand new workspace in Energy BI Service
- add explicit customers you need to have the ability to obtain the report
- make them admin over the workspace and save
- Publish the report from Energy BI Desktop to the brand new workspace
Now when the customers log into their Energy BI Service account they solely have to open the brand new workspace then they’ll be capable to obtain the report you created and revealed to the service.
Due to Mudit Marwah for bringing the final half to my consideration.
As I acknowledged earlier, it is a superb begin, nonetheless, there are nonetheless some limitations utilized to this function. I hope Energy BI improvement crew enhance the function in order that we will obtain the stories created in Energy BI Service from scratch which might make the function extra useful.
