Versions

PowerBI: Version 2.66.5376.2521 32-bit

Power Query (M) Builder for Xrm ToolBox: Version 1.2018.1014.5

Problem:

The following errors are observed in Power BI when 'Close & Apply' is pressed after creating queries using Power Query (M) Builder for Xrm ToolBox.

Error 1:

If no changes have been made to the query the following message is displayed and no data is visible.

Error 2

If no changes have been made to the query the following message is displayed and no data is visible

Solution:

This occurred because my views had fields from related entities in the columns e.g. Account (Parent Company). I removed these and the queries worked fine so I just added additional queries for those related entities and created a relationship between them.

Maybe this is in the instructions of the Power Query (M) Builder tool but if it was I missed it and it took me a while to work it out. It didn't help that I'd just had my machine rebuilt and I was certain it was a memory issue.

Update 01/04/2019:

I’m completely aware that this error could be caused by any number or issues so I’ll just document other fixes I found when it occurred again in this article as updates.

I experienced this error again when trying to update an existing query after it had been merged and other modelling functions has been performed on it.

As the project I was working on didn’t require me to connect to any Office documents (I have the x86 version of Office installed) I managed to get around the error by using the x64 version of Power BI. From now on I will work mostly in the x64 version unless it’s absolutely necessary to use the x86 version.