Creating Datasets for Power BI and Tableau

This video will show how to load data into Power BI and Tableau from Sharperlight. The video shows a example dataset coming from SAP Business One but the same would apply for any Product. The video demonstrates how to refresh datasets using Sharperlight Scheduler or Power BI personnel Gateway. Because data is coming from the Sharperlight Datamodel all the BI logic including row level security and dynamic context sensitive logic is respected in the delivered final dataset. The Sharperlight RESTful service can provide JSON datasets to Power BI via an simple URL address or it can schedule the creation of CSV files in Scheduler.

The video shows how to:

• Create a dataset for Power BI and Tableau
• Load data into Power BI and Tableau
• Refresh datasets using Sharperlight Scheduler or Power BI personnel Gateway

Published: 17/10/2017 12:00PM