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.
I have a large report that is currently linked to a direct query, published PBI dataset. I want to have the SQL logic that creates the published PBI dataset within the PBI report as a SQL Server import dataset.
I want all the visuals in the report to auto regonise this new dataset (all columns and data types will be the same as the orginal dataset) as the direct query will be deleted. Is there an easy way to do this rather than having to manually update each visual?
If it was a mater of switching between 2 sql server import queries that is easly managed in Power Query. Obviously when attched to a direct query, PBI dataset there is no advanced editor avaiable in transform data for obvious reasons.
Do it in two steps
1. Change the Direct Query source from dataset to SQL server table or view. Make absolutely sure that the result is exactly the same, down to the spelling and punctuation. Cannot emphasize this point enough
2. Change the storage mode from Direct Query to Import Mode.
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 |
---|---|
111 | |
109 | |
89 | |
76 | |
67 |
User | Count |
---|---|
125 | |
111 | |
100 | |
83 | |
71 |