When you use Excel and Linked table in powerpivot you want that your user can’t edit column name or cells data, because their change will create problem to your model. But if you block your worksheet, how permit your user to delete or insert new row? With VBA
When you create a power bi report and publish it online you have the possibility to print it in pdf. During my test i found a “little” problem with this function.
For example, i created this power bi desktop report:
THe report work correclty on power bi online. to print in pdf you have to select a report ( not a dashboard) click on file tab and print:
The problem is when you try on differet browser to print pdf the result is this:
We have lost all the images! we can’t export and print a report like this. I have found a little trick, unfortunately it’s work only with chrome, if you find a different solution write to me. With chrome is very symple, whe you are in the print preview there si in the left corner a flag to tick, “graphic in the background”. If you tick the flag the result is this:
Now we can Print it !
2 days ago Microsoft just released another monthly update of Power BI Desktop. They introduce following Update:
- Ability to publish reports to a Group Space in Power BI Service, permit user to creare and publish report only for specific members of workspace.
- Reports respect Do Not Summarize model setting from SSAS MD. Power BI respect the SSAS property IsAggregatable.
Microsoft have realeased on 25th March a new power bi app for Apple Watch. That permit to access your critical information and insights directly from the watch face without opening the Power BI app itself.
When you open the Power BI app for Apple Watch, you will see an Index screen with a quick overview of all applicable tiles from the synced dashboard. Keep a close eye on your most important metrics. You can drill into a specific tile by tapping on it to get more data:
To sync a Power BI dashboard to your Apple Watch, first open the Power BI app on your phone, load a dashboard, and tap the dashboard actions menu. Next, open the Power BI app from the Apple Watch springboard.
Download now the app : Power BI App
In this post we introduce a new feature of Power BI, the Drill down function On PowerBI, we are going to learn how we can create a drill down report in Power BI.
We can start from every type of Dataset, the importat is that there must be a hierarchical relationship between attribute that we use to create the chart. we we have our dataset we: Continua a leggere
Sometimes when on excel you want to filter data in a pivot table you can’t use a slicer but you have to us a filter. For example when you have :
- A long list of data (100/200 customer for example)
- Different type of data
- Long Description
In these cases you prefer to use a classic filter for use search query to improve your filtering. But Filters works only with one pivot table and it isn’t possible to use same filter to connect two table. For Example we start from this situatio:
We want to Filter data by project but this attribute have long words and many rows ( 200 different project) but we don’t want to repeat our filter. To solve this problem we have to do one simple thing : create a slicer. IN particular:
- Create a new slicer connected to the first pivot table. the slicer have to refer the same attribute that we want to filter, in our case Project.
2. After that we connect the slicer to the second pivot table and we remove the second filter:
At this point we can hide the slicer and use only the filter. if you have done all the passages correctly the filter of first pivot table should filter the second one.
This solution can be repeated with 2 or more filters.
This month Microsoft has released a new feature to power BI. We can connect an Excel File directly to PowerBI and using pivot table to analyze DataModel.
What We need?
- PowerBi Account Pro ( use the trial) , the same used on excel
- Excel 2013-2016
- An Existing datamodel on powerbi ( i use a powerbi desktop model on powerbi)
- SQL_AS_OLEDB feature: you cand find on this Link32bit or link64bit
How to Connect?
Go to powerbi site and select one of your datamodel or report :
Click on Analyse in Excel. PowerBi create a ODC file in automatic and download it on your computer.
Open your excel and go on data tab, select existing connection,:
Click on browse in le left corner and select the connection created by power bi. After that create a pivot table and you have completed alle the operation.
Congratulation now you can use your PowerBI model on your excel!
During this period we have been heard often in the “R” language associated with power bi. I suggest to who is interested to use it these Cheat Sheets:
R Cheat Sheet: simple pdf with the principal function and script that you can use on R
Data Table Cheat Sheet: a series of suggestion to understand ad use data in the table format on R
GGPLot2 Cheat Sheet: a pdf only on ggplot2 library, the most used library to create chart visualizations.
Moreover i suggest two another link about data science:
Data Science base: an article about what we need, hardware and software, to start to become a data scientist
Data Science Advance: a list of 20 tutorial about data science, R, big data and manchine learning
Durin my browsing i found this very interesting Cheat sheet. The Microsoft Azure Machine Learning Algorithm Cheat Sheet helps you choose the right machine learning algorithm for your predictive analytics solutions from the Microsoft Azure Machine Learning library of algorithms.
Download the cheat sheet here: