Solving Common Issues When Using Python and R in Power BI

Sometimes you may run into some problems that are quite common for those developing solutions in Power BI using Python and R. This chapter systematically addresses those most common problem cases by providing the most appropriate solutions to each of them.

This chapter will cover the following topics:

  • Avoiding the ADO.NET error when running a Python script in Power BI
  • Avoiding the Formula.Firewall error
  • Using multiple datasets in one Python and R script step
  • Dealing with dates/times in Python and R script steps

Technical requirements

This chapter requires you to have a working internet connection and Power BI Desktop already installed on your machine (we used version 2.112.603.0 ...

Get Extending Power BI with Python and R - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.