Obtain Energy BI Reviews from Energy BI Service

A brand new cool function added to Energy BI Service is the flexibility to obtain Energy BI studies from Energy BI Service. This function is extremely demanded and it’s obtainable from November 2016. I used to be actually excited once I seen that and I needed to strive it right away. I used to be in a bus again to residence on Friday, however, I couldn’t wait till I get residence 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 once I learn one thing, even studying a textual content on my cellular. Man, it’s actually horrible feeling. Understanding 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 prospects jumped into my head instantly:

• The dataset of this specific report just isn’t supported in the intervening time
• The “Obtain report” function is NOT supported in my space

So I opened Energy BI Desktop and created a report on high of an Excel file in a short time, then I revealed it to the service and voila! It labored. So additionally it is obtainable in my space.

However, what was flawed with the earlier report although? The dataset?

I checked the report’s dataset, it was on-premises SQL Server. May or not it’s an issue?

I created one other Energy BI report in Energy BI Desktop on high 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 have the ability to obtain that report?

Properly, 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 nicely. I examined the next datasets:

1. CSV information
2. Folder
3. SQL Server Direct Question
4. SQL Server Evaluation Companies (SSAS) Multidimensional (Join Reside)
5. SQL Server Evaluation Companies Tabular
6. From Net
7. Azure SQL Database
8. Azure SQL Information Warehouse

So, it might’t be an unsupported dataset, I reckon.

I rapidly created a report on Energy BI Service itself and… once more, it’s greyed out.

So this function just isn’t obtainable after 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 workforce they usually enhance the obtain function sooner or later in order that we are able to obtain the studies created in Energy BI Service.

However, a query nonetheless remaining, why it’s inactive for all of my present studies which revealed some time in the past?

The bus remains 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 studies created in older variations of Energy BI Desktop. In order that’s the explanation that it’s greyed out for all present studies which might be created in an older model of Energy BI Desktop.

I ought to soar out of the bus now and by chance I haven’t received sick, nicely, just a little bit, however nothing to be frightened about.

After I received residence I reopened an outdated 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 seen that once 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 just isn’t 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 outdated 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 possibly can.

I attempted it and it labored for me.

What about safety? Who can obtain the studies? What if we don’t need this function to be avaibale for all customers?

You may allow or disable this function by “Admin Portal” in case you are a “International 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 knowledge” then swap it off and apply

• Now “Obtain report” disappeared from “File” menu

If you would like another folks in your organisation to have the ability to obtain the report then you possibly can

• create a brand new workspace in Energy BI Service

• add specific 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 must open the brand new workspace then they’ll have the ability 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 excellent begin, nevertheless, there are nonetheless some limitations utilized to this function. I hope Energy BI improvement workforce enhance the function in order that we are able to obtain the studies created in Energy BI Service from scratch which might make the function extra helpful.