March 2024
Intermediate to advanced
814 pages
22h 10m
English
In the previous chapter, you saw an example of how to enrich existing data with external information. In that case, the data was exposed via CSV files, but this is not always the case. Very often, the data that is useful for enrichment is exposed through external application programming interfaces (APIs), most often in the form of web service endpoints. Power BI allows you to read data from a web service through a dedicated UI, but most of the time it is unusable. So, you have to resort to writing M code to get it done. Writing M code isn’t too difficult, but it’s not easy. You also have to be careful not to write code that causes refresh problems when you publish the report to the Power BI service. ...
Read now
Unlock full access