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 data stored on a Cassandra database and I'd like to know these two points:
1. Is it possible to take data from Cassandra in Power BI? I haven´t seen an available connector to do so.
2. In case that it is possible to take data from Cassandra, would it be possible too to schedule a programmed refresh of the data? I have checked this page of the official Power BI documentation: https://docs.microsoft.com/es-es/power-bi/refresh-data but I haven't found what I was looking for.
Many thanks for yur help.
Regards
Solved! Go to Solution.
Hi @Anonymous ,
There is no direct Cassandra database connector in Power BI currently.
By my research, you could try with ODBC driver to connect Cassandra database in Power BI.
For the detail steps, please refer to this bolg Connect to Cassandra as an ODBC Data Source.
If you want to refrsh the dataset in Power BI service, you should add the data source in data gateway in Power BI Service.
And then set the schedule refresh under Settings>>Datasets>>Schedule refresh.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi @Anonymous ,
Have you solved the problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi @Anonymous ,
There is no direct Cassandra database connector in Power BI currently.
By my research, you could try with ODBC driver to connect Cassandra database in Power BI.
For the detail steps, please refer to this bolg Connect to Cassandra as an ODBC Data Source.
If you want to refrsh the dataset in Power BI service, you should add the data source in data gateway in Power BI Service.
And then set the schedule refresh under Settings>>Datasets>>Schedule refresh.
If you still need help, please feel free to ask.
Best Regards,
Cherry
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 |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |