Forum Discussion
Query data from another published dataset?
Hi I want to get data from another published dataset in the Power BI Service (not premium) I do not want to recreate the model in the new report since it has alot of complicated measures. I can...
amitchandak
Super User
Super UserAnonymous , You have an option to use the dataset. But in that case, you will not able to add any other thing
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
Yes, I know that, I even wrote it was not an option.
The only thing I can think of is to create a connection to the dataset in Excel (Analyze in excel). Make a report in excel. And then import the excel data to the new dataset. But there must be a smoother way?Why no option to create a direct OLE DB connection to the published dataset? Or use an API or something?