Archive

PowerQuery

Make Common Queries Available For Everyone By Saving Them To Office365

February 11, 2014
Business Intelligence, Dynamics AX, Excel, Office 365, PowerQuery
1 Comment

Queries are like mining for gold, because everyone is searching for the motherload of data that is hidden within Dynamics AX, and once they find it, they mine it until it dries out and they have to start prospecting again.  Also, the secret maps to that data are hidden away, usually on someone’s own personal hard drive, and are rarely shared with other prospectors.  Office 365 and Power Query changes that because it allows you to share any of your queries with everyone within the organization, allowing everyone including the non-technical users that would never create a query.

No more claim jumping, there is enough data out there for everyone to mine.

Read More

Publish Queries As OData Document Sources For Users To Query In Excel

February 10, 2014
Dynamics AX, Excel, PowerQuery
4 Comments

If you want to publish out data to the users so that they can create their own reports, or run their own analysis, there is in a simple and secure way built into Dynamics AX.  You can register your queries as Document Data Sources and then they automatically become available through the OData service within Dynamics AX.  Additionally, all of the default security that you put in place around the data will be respected by the service because you are using Dynamics AX to create the query.

No more ODBC connections, or even worse… unsecured Access databases.

Read More