Power BI code
When using the connectors that would pull your data from the source and present them into Power BI, it can happen that you will get no file, or the file with the empty results, whether it is in JSON or CSV format.
Users will get a very vague and confusing message that something went wrong. To avoid confusion, we can put a piece of code and test if we have our data pulled. If not, show the message of our choice. A great example of that you can see in Windsor.ai templates like this one shown in the image.
If you download the .pbit file and connect your data, you can see the code itself using an advanced editor in the Power BI Desktop application. That way, we can eliminate the endless questions from our users. We can point them to solve the problem by themselves, use help pages, etc. That is a relief, isn’t it?
If you want to know more
For more details about using Excel, Power BI, Windsor.ai platform, and other advanced productivity tools, you can contact me here or request a custom offer on Upwork and Fiverr. It is also possible to have a direct relationship using Payoneer or PayPal. If you have some other preferred options for collaboration, please use this contact form for suggestions.
Share
