The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have a scenario where I have to use PBI to retrieve and store data to act as a data source for other PBI reports to consume.
The original source data I need to pull from are mulitple SQL Views, from a single SQL Server, via a Standard Gateway. The reason why I shall be seeking to use PBI for this method is due to not having another integration tool available.
My thinking is to use a Power BI Dataset - so a normal PBI report that I connect to the source SQL Views, via the Standard Gateway, using Import mode.
I then publish that report (although it is simple a Dataset - no visuals) to the PBI Service. The report sits in the PBI Service as a Dataset.
When others need to create PBI reports using that SQL View data they would connect to the published PBI Dataset, which I understand will be in the form of 'Direct Query', and our own in-house data, using Import mode, then they would need to use a 'composite' model PBI report so to consume both Direct Query (PBI Dataset) and Import mode (in-house data).
Is all I've stated correct?
Is there another method to acheive what I need to using the Power BI tool only?
Any confirmation/suggestions will be much appreaciated?
Thanks.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
52 | |
22 | |
11 | |
11 | |
9 |
User | Count |
---|---|
112 | |
32 | |
30 | |
20 | |
19 |