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 Team,
We have created few dashboards using existing Excel file. Now as a part of long term strategy we have uploaded the excel data into SQL Azure and automated the process of data refresh.
Now we would like to use the same .pbix file for dashboard from SQL Azure DB by changing the connection string from Excel source to SQL azure connection string.
The Database contains exactly the same column name and table name which was used in Excel.
Could you please help? Please let us know if you need more information.
Thanks
- Sandeep
You best bet is to use Advanced Editor in the Desktop. View | Advanced Editor.
What I would recommend would be to backup your PBIX file (obviously). Create a new PBIX file and createa a query to to Azure SQL DB for a particularly table. In Query Editor, go to View | Advanced Editor and look at the "Source" line:
Source = Csv.Document(File.Contents("C:\temp\powerbi\pivot.csv"),[Delimiter=",", Encoding=1252]),
That one is for a CSV file. Copy the entire Source line.
Now, go into your original PBIX, edit the corresponding query in it, View | Advanced Editor and replace its source line with the one you copied. Save.
If everything is the same (big if) then it should work seamlessly.
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 |
---|---|
101 | |
52 | |
21 | |
12 | |
11 |