The use of Power BI tools in any version, Desktop or Services, is an excellent way to improve your data reporting. Also, using some specialized BI platforms like Windsor.ai is a way to have your marketing data well structured, with some AI insights, and ready to be used with provided templates, which you can easily customize.
Specific users were not able to open the paginated report in the PBI service which used to work fine in PBI Report Server.
Could not connect to the data source. There was an error communicating with Analysis Services. Please verify that the data source is available, and your credentials are correct. The connection either timed out or was lost.
WARNING!! If this post was not part of a series, it would probably be titled something along the lines of "Things that Greg Feels Like Ranting About at the Moment that are Tangentially Related to Translating Excel Functions to DAX". So...just so you're warned...and stuff...
Well, after about two weeks, we have reached 91% coverage of Excel functions translated to DAX. The original goal I had in mine was 80% coverage so we've exceeded my original goal and since progress has definitely slowed and become increasingly difficult to move the needle I figured this would be a good time to pause and reflect upon what we’ve learned thus far.
An on-premises data gateway is software that you install in an on-premises network. The gateway facilitates access to data in that network.
If you have installed the gateway already and are looking forward to updating it to the current version released by Microsoft, then this section is for you. I am trying to highlight the steps that I have implemented in my organization which can help to provide the one-place reference for you to update your gateways.
I have used the November 2019 update from Microsoft while working on this blog, and Microsoft may change the steps in the future, but they can still be used as a reference, as per my understanding.