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'm wonderind is in Power BI posibility to make report on one DB and after that send file with report to someone else, who has DB with same structure (same tabels, colums, etc) and diffrent records in it. So he could see how this report looks with his set of data in his wersion on DB.
Solved! Go to Solution.
I found a solution,
You can go to Query Editor. Click on Manage Parameters in it. Type Your DB (it is temporary), and use this parameter instead of text value, every time You load new table from DB. After that, when You save it as template, and import, new window will appear with fild in it that You can use to type DB in it. And it works on every DB with this parameter.
Proud to be a Super User!
Paul on Linkedin.
Thanks for help. It works I think, but it is not all I need.
Is it posibility to choose from which DB You want to import data at start?
When I open new report I can import data from DB to make report I have to choose my DB. But this choice is remembered and I can't change it in easy way. I can change it manyally in query editor for each table, but what if I have 100 or more tables? I don't want to waste much time every time I need to use this report on different DB.
Is it one simple way to do it?
I found a solution,
You can go to Query Editor. Click on Manage Parameters in it. Type Your DB (it is temporary), and use this parameter instead of text value, every time You load new table from DB. After that, when You save it as template, and import, new window will appear with fild in it that You can use to type DB in it. And it works on every DB with this parameter.
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 |
---|---|
105 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |