A new cool feature added to Power BI Service is the ability to download Power BI reports from Power BI Service. This feature is highly demanded and it’s available from November 2016. I was really excited when I noticed that and I had to try it straight away. I was in a bus back to home on Friday, but, I couldn’t wait until I get home and test this cool feature. So I created a personal hotspot and started testing it in the bus. To make the level of my excitement clearer, I should reveal a secret. I get motion sick in the bus very quickly. It gets worth when I read something, even reading a text on my mobile. Man, it’s really horrible feeling. Knowing that I’ll potentially get sick, I turned on my tablet (a Windows 10 tablet of course) to test this new cool feature. So I logged into my Power BI Service account, I opened a report, clicked File menu and this is what I got
Two possibilities jumped into my head immediately:
- The dataset of this particular report is not supported at the moment
- The “Download report” feature is NOT supported in my area
So I opened Power BI Desktop and created a report on top of an Excel file very quickly, then I published it to the service and voila! It worked. So it is also available in my area.
But, what was wrong with the previous report though? The dataset?
I checked the report’s dataset, it was on-premises SQL Server. Could it be a problem?
I created another Power BI report in Power BI Desktop on top of adventure works on SQL Server 2016. I published the model and interestingly the download report feature was still active. So how on earth I shouldn’t be able to download that report?
Well, I was in the bus, wobble about and I was feeling that the motion sickness symptom is coming for me and there were a bunch of “whys” in my head.
So I had to experiment some other datasets as well. I tested the following datasets:
- CSV files
- SQL Server Direct Query
- SQL Server Analysis Services (SSAS) Multidimensional (Connect Live)
- SQL Server Analysis Services Tabular
- From Web
- Azure SQL Database
- Azure SQL Data Warehouse