topic Re: Redshift in Power Bi Embedded in Developer

Redshift in Power Bi Embedded

DrBiker — Tue, 02 Aug 2016 09:56:12 GMT

I have connected to redshift sucessfully using Power Bi desktop. I now need to use this in a Power Bi environment.

Is this feature available yet? And if it is any help with connecting would be useful. Error message is:

Power BI Exploration Couldn't retrieve the data for this visual. Please try again later.

Thanks

Paul

Re: Redshift in Power Bi Embedded

Eric_Zhang — Fri, 05 Aug 2016 07:05:04 GMT

I have connected to redshift sucessfully using Power Bi desktop. I now need to use this in a Power Bi environment.

Is this feature available yet? And if it is any help with connecting would be useful. Error message is:

Power BI Exploration Couldn't retrieve the data for this visual. Please try again later.

@DrBiker

Do you encounter this error when using the Power BI embedded?

Connecting to redshift is a preview feature in Power BI Desktop Jul's release. According to what I exprienced on preview features, most of them are implemented in Desktop only. I doubt this feature is not implemented in Power BI embeded yet. Meanwhile I don't find any content pack connecting to redshift in Power BI Service neither do I find any supported data source in gateways(if required to refresh redshift. I don't have much idea on redshift, it seems a cloud service and then a gateway is not needed). For whatever I am just trying to find anything on redshift on Power BI Service, but with no luck.

Could you try to publish the pbix to Power BI Service to see what happens? And the recommentation is not to apply a preview feature in your develpment, just wait for the GA release.

Re: Redshift in Power Bi Embedded

carldickson — Thu, 25 Aug 2016 23:44:56 GMT

Hi,

Its not currently in the gatway list of data sources, thats a feature that would be amazing for our company. The Redshift driver is already made us move to Power BI.

Any idea when the full release is sheduled for?

thanks

Re: Redshift in Power Bi Embedded

knov99 — Sun, 05 Feb 2017 06:31:40 GMT

This solution is still needed. See

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-redshift/
https://powerbi.microsoft.com/en-us/blog/building-power-bi-reports-on-top-of-amazon-redshift-data/

This last article, dated Aug 1 2016, said the Redshift connector doesn't yet work for "Power BI Gateway or PowerBI.com for refresh scenarios, which will come in the next couple of months."

These threads have essentially the same issue:

http://community.powerbi.com/t5/Service/Redshift-dataset-Refresh-not-working/m-p/97473#M16455
http://community.powerbi.com/t5/Developer/Redshift-in-Power-Bi-Embedded/m-p/55925#M1763
http://community.powerbi.com/t5/Service/Facing-issue-embedding-redshift-connected-pbix/m-p/83979#M15037
https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-Refresh-from-Amazon-Redshift/m-p/50587#M4404

It's been six months since "a couple of months" was promised. Any news? This is a big issue for my application, where I need to do scheduled refreshing in the PBI service, just like any other database.