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 table for IP geolocation purposes: I have downloaded it from an online service into a CSV table, but it's not going to be refreshed, so that's basically static data.
At the moment Power BI is connected to the CSV file. I would like to create a table that resides in Power BI instead, so I can eliminate the query.
I tried to copy and paste the table into a new tablke in Power BI, but I have more than 1M lines, so Power Bi suggests that I create multiple shorter tables and then merge them with Power Query.
Is there a better/simpler way?
Also, would a table that large residing in Power BI impact performance?
Thanks!
~Alienvolm
Solved! Go to Solution.
Hi @Alienvolm ,
You could learn the merge/append operation from this link: https://radacad.com/append-vs-merge-in-power-bi-and-power-query.
Or you may try to create relationships among multiple shorter tables.
There're three connection type in Power BI: import, DirectQuery and live connection.
Reference: https://radacad.com/directquery-live-connection-or-import-data-tough-decision
The advantages and disadvantages of the three connection type are summarized from the link above.
When your pbix file is published to Power BI service, gateway is used to refresh data in Power BI service. If your connection is Direct Query, you need to configure the gateway to veiw the report in Power BI service.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Alienvolm ,
You could learn the merge/append operation from this link: https://radacad.com/append-vs-merge-in-power-bi-and-power-query.
Or you may try to create relationships among multiple shorter tables.
There're three connection type in Power BI: import, DirectQuery and live connection.
Reference: https://radacad.com/directquery-live-connection-or-import-data-tough-decision
The advantages and disadvantages of the three connection type are summarized from the link above.
When your pbix file is published to Power BI service, gateway is used to refresh data in Power BI service. If your connection is Direct Query, you need to configure the gateway to veiw the report in Power BI service.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, you can load it one time and then right click on the query in the query editor and uncheck "include in report refresh".
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks!
I had no idea I could do that...
At this point, would I still need the source file? I'm asking because I would like to make this report into an app to be shared. Would the data definitely reside in Power BI?
I also have another question: this report uses direct query mode. Since I added the IP locations table, it has switched to Mixed storage mode, and it requires a gateway.
With the data residing in Power BI, will I still need a gateway?
Thanks again!
~Alienvolm
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |