Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power BI Report Builder Error

I have a report which I've transitioned to Power BI Report Builder from Report Builder 3.0. I've set everything up the same as it was on Report Builder 3.0 with the exclusion of a dsDefaultDates data...
report builder
report builder parameter
Report Data Set
FarhanAhmed's avatar
FarhanAhmed
Community Champion
5 years ago

What are the other queries and datasets that you are using?

Make sure that all queries working properly and returning all columns that are being used in the report.

 

Are you using Table/Matrix in the report while going to the next page?

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I have two Datasets which hit Oracle SQL Developer and then 3 others which hit SSMS. I did use the "Table or Matrix Wizard" initially to build my report and connect my first Data Source and Dataset (both Oracle SQL Developer) before manually adding my Data Source which hits SSMS and then the Data Sets which use the SSMS Data Source. I've confirmed all queries run independently of each other. I also logged onto my etl server (where the original report is being ran from) and can flip through pages without any issues.