Forum Discussion
No Fields in Dataset
Hello,
I've connected my Report Builder to a Dataset in my premium workspace. It is listed as a data source. The Table Wizard requires connection to a Dataset, so when I try to make a dataset out of this source it doesn't give me any fields to pick from. It's like the data source has no fields at all. I loaded this to PBI Service from PBI Desktop where I've made various reports with it. Any idea why I can't get the fields to show up?
The fields tab relates to the fields from your Query, not all the fields in the PBI dataset. If you have not created a query yet you will not have any fields.
3 Replies
The fields tab relates to the fields from your Query, not all the fields in the PBI dataset. If you have not created a query yet you will not have any fields.
I see, so it looks like this is the page that describes how to find the correct Query. That right? Create a paginated report with a Power BI shared dataset - Power BI Report Builder - Power BI | Microsoft Docs
Yes, the section on getting the DAX query shows how to copy a query from a visual. There is also a drag/drop query designer built into Report Builder. Either method would work.