Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
i have a database which I want to query with odbc and with SQL to create a big master dataset or something like that in Power BI. With this master dataset I want to create serveral reports.
How do I do this?
For creating a dataset in the Power BI Report Server Web interface I need to open Report Builder. Why? I just want to inser my sql and the source...
It seems like I need some help 🙂
Solved! Go to Solution.
Power BI datasets and paginated report datasets are different in PBI RS. For creating RDL reports you can use shared datasets that can drive multiple RDL (paginated reports). See here for details.
Manage Shared Datasets - SQL Server Reporting Services (SSRS) | Microsoft Docs
Power BI Datasets are tied to a PBIX file - you can create multiple visualizations there as well as tabs - each tab can be a report.
To create those datasets you should look here. It happens in power bi desktop, not Report builder.
Connect to data in Power BI Desktop - Power BI | Microsoft Docs
regards,
Luis H
Power BI datasets and paginated report datasets are different in PBI RS. For creating RDL reports you can use shared datasets that can drive multiple RDL (paginated reports). See here for details.
Manage Shared Datasets - SQL Server Reporting Services (SSRS) | Microsoft Docs
Power BI Datasets are tied to a PBIX file - you can create multiple visualizations there as well as tabs - each tab can be a report.
To create those datasets you should look here. It happens in power bi desktop, not Report builder.
Connect to data in Power BI Desktop - Power BI | Microsoft Docs
regards,
Luis H
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
11 | |
5 | |
5 | |
3 |