Do not have permission to export underlying data

I created a dataset in PowerBI Desktop which consists of 9 queries to a SQL Server using DirectQuery and the 9 queries are connected with each other. I published the dataset to PowerBI Web for others...